Goal Scale Assignments Table Schema (goal_scale_assignments)


Description

Tracks which scales are assigned to which goal frameworks

goal_scale_assignments table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scaleid BIGINT 19 null
goal_scale.id goalscalassi_sca2_fk R
frameworkid BIGINT 19 null
goal_framework.id goalscalassi_fra2_fk R
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

goal_scale_assignments table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalscalassi_fra_ix Performance Asc frameworkid
goalscalassi_sca_ix Performance Asc scaleid

goal_scale_assignments table relationships

Close relationships within degrees of separation