Dp Priority Scale Value Table Schema (dp_priority_scale_value)


Scale values for development plan priority scales

dp_priority_scale_value table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
dp_plan_competency_assign.priority dpplancompassi_pri2_fk R
dp_plan_course_assign.priority dpplancourassi_pri2_fk R
dp_plan_objective.priority dpplanobje_pri2_fk R
dp_plan_program_assign.priority dpplanprogassi_pri2_fk R
dp_priority_scale.defaultid dpprioscal_def2_fk R
name VARCHAR 255 null

Name for scale value

idnumber VARCHAR 100 null

Identifies a value that can be given to a scale value

description LONGTEXT 2147483647 null

Description of the scale value

priorityscaleid BIGINT 19 null
dp_priority_scale.id dpprioscalvalu_pri2_fk R

Identifies the priority scale that a value belongs to

numericscore DECIMAL 10,5 null
sortorder BIGINT 19 null

Identifies the order scale values appear in

timemodified BIGINT 19 null

Identifies the last time a scale value was modified

usermodified BIGINT 19 null
user.id dpprioscalvalu_use2_fk R

Identifies the id of the user who last modified the scale value

Table contained -1 rows

dp_priority_scale_value table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpprioscalvalu_pri_ix Performance Asc priorityscaleid
dpprioscalvalu_use_ix Performance Asc usermodified

dp_priority_scale_value table relationships