Dp Objective Settings Table Schema (dp_objective_settings)


Description

Settings for a template's objectives

dp_objective_settings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
templateid BIGINT 19 null
dp_template.id dpobjesett_tem2_fk R
duedatemode SMALLINT 5 0
prioritymode SMALLINT 5 0
priorityscale BIGINT 19 √ null
dp_priority_scale.id dpobjesett_pri2_fk R
objectivescale BIGINT 19 √ null
dp_objective_scale.id dpobjesett_obj2_fk R

Table contained -1 rows

dp_objective_settings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpobjesett_obj_ix Performance Asc objectivescale
dpobjesett_pri_ix Performance Asc priorityscale
dpobjesett_tem_ix Performance Asc templateid

dp_objective_settings table relationships

Close relationships within degrees of separation