Goal Scale Values Table Schema (goal_scale_values)


Description

The individual values that make up a goal scale

goal_scale_values table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goal_item_history.scalevalueid goalitemhist_sca2_fk R
goal_personal.scalevalueid goalpers_sca4_fk R
goal_record.scalevalueid goalreco_sca2_fk R
goal_scale.defaultid goalscal_def2_fk R
name LONGTEXT 2147483647 null
idnumber VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
scaleid BIGINT 19 null
goal_scale.id goalscalvalu_sca2_fk R
numericscore DECIMAL 10,5 √ null
sortorder BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
proficient TINYINT 3 0

Table contained -1 rows

goal_scale_values table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalscalvalu_idn_ix Performance Asc idnumber
goalscalvalu_sca_ix Performance Asc scaleid

goal_scale_values table relationships

Close relationships within degrees of separation