Dp Objective Scale Table Schema (dp_objective_scale)


Description

Contains objective scales for development plans

dp_objective_scale table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
dp_objective_scale_value.objscaleid dpobjescalvalu_obj2_fk R
dp_objective_settings.objectivescale dpobjesett_obj2_fk R
name VARCHAR 255 null

Name of the objective scale

description LONGTEXT 2147483647 null

Description of the objective scale

timemodified BIGINT 19 null

Identifies the last time the objective scale was modified

usermodified BIGINT 19 null
user.id dpobjescal_use2_fk R

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

defaultid BIGINT 19 null
dp_objective_scale_value.id dpobjescal_def2_fk R

Identifies the id of the default scale value

sortorder BIGINT 19 null

Table contained -1 rows

dp_objective_scale table indexes

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

dp_objective_scale table relationships