Dp Priority Scale Value Table Schema (dp_priority_scale_value)


Description

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

Close relationships within degrees of separation