Dp Objective Scale Value Table Schema (dp_objective_scale_value)


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