Dp Priority Scale Table Schema (dp_priority_scale)


Description

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

Close relationships within degrees of separation