Goal Scale Table Schema (goal_scale)


Description

Scale represents the different levels of achievement of a goal

goal_scale table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goal_personal.scaleid goalpers_sca3_fk R
goal_scale_assignments.scaleid goalscalassi_sca2_fk R
goal_scale_values.scaleid goalscalvalu_sca2_fk R
name VARCHAR 255 √ null
description LONGTEXT 2147483647 √ null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
defaultid BIGINT 19 √ null
goal_scale_values.id goalscal_def2_fk R

Table contained -1 rows

goal_scale table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalscal_def_ix Performance Asc defaultid

goal_scale table relationships

Close relationships within degrees of separation