Comp Scale Values Table Schema (comp_scale_values)


Description

The individual values that make up a competency scale

comp_scale_values table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
comp_record.proficiency compreco_pro2_fk R
comp_record_history.proficiency comprecohist_pro2_fk R
comp_scale.defaultid compscal_def2_fk R
dp_plan_competency_assign.scalevalueid dpplancompassi_sca2_fk R
name LONGTEXT 2147483647 null
idnumber VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
scaleid BIGINT 19 null
comp_scale.id compscalvalu_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

comp_scale_values table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compscalvalu_sca_ix Performance Asc scaleid

comp_scale_values table relationships

Close relationships within degrees of separation