Comp Scale Assignments Table Schema (comp_scale_assignments)


Description

Tracks which scales are assigned to which competency frameworks

comp_scale_assignments table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scaleid BIGINT 19 null
comp_scale.id compscalassi_sca2_fk R
frameworkid BIGINT 19 null
comp_framework.id compscalassi_fra2_fk R
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

comp_scale_assignments table indexes

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

comp_scale_assignments table relationships

Close relationships within degrees of separation