Dp Priority Scale Table Schema (dp_priority_scale)


Contains priority scales for development plans

dp_priority_scale table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
dp_competency_settings.priorityscale dpcompsett_pri2_fk R
dp_course_settings.priorityscale dpcoursett_pri2_fk R
dp_objective_settings.priorityscale dpobjesett_pri2_fk R
dp_priority_scale_value.priorityscaleid dpprioscalvalu_pri2_fk R
name VARCHAR 255 null

Defines the name of the priority scale

description LONGTEXT 2147483647 null

Description of the priority scale

timemodified BIGINT 19 null

Identifies the last time this scale was modified

usermodified BIGINT 19 null
user.id dpprioscal_use2_fk R

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

defaultid BIGINT 19 null
dp_priority_scale_value.id dpprioscal_def2_fk R

Identifies the id of the default scale value

sortorder BIGINT 19 null

Table contained -1 rows

dp_priority_scale table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpprioscal_def_ix Performance Asc defaultid
dpprioscal_use_ix Performance Asc usermodified

dp_priority_scale table relationships