Dp Objective Scale Value Table Schema (dp_objective_scale_value)


Description

Objective Scale values for development plan priority scales

dp_objective_scale_value table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
dp_objective_scale.defaultid dpobjescal_def2_fk R
objscaleid BIGINT 19 null
dp_objective_scale.id dpobjescalvalu_obj2_fk R

Identifies the objective scale id this value belongs to
name VARCHAR 255 √ null

Name of the scale value
idnumber VARCHAR 100 √ null

Defines a id that can be assigned to a scale value
description LONGTEXT 2147483647 √ null

The description of the scale value
numericscore DECIMAL 10,5 √ null

Identifies a score that can be assigned to a scale value
sortorder BIGINT 19 null

Defines the order of the priority scale values
timemodified BIGINT 19 null

Identifies the last time this scale value was modified
usermodified BIGINT 19 null
user.id dpobjescalvalu_use2_fk R

Identifies the id of the user who last modified the scale value
achieved SMALLINT 5 0

Identifies if this scale value is an achieved value

Table contained -1 rows

dp_objective_scale_value table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpobjescalvalu_obj_ix Performance Asc objscaleid
dpobjescalvalu_use_ix Performance Asc usermodified

dp_objective_scale_value table relationships

Close relationships within degrees of separation