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

Close relationships within degrees of separation