app_dp_objective_scale_value

3 rows


Description

Objective Scale values for development plan priority scales

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_dp_objective_scale_value_id_seq'::regclass)
app_dp_objective_scale.defaultid Defined in XMLR
app_dp_plan_objective.scalevalueid Defined in XMLR
objscaleid int8 19 null
app_dp_objective_scale.id Defined in XMLR
name varchar 255 √ null
idnumber varchar 100 √ null
description text 2147483647 √ null
numericscore numeric 10,5 √ null
sortorder int8 19 null
timemodified int8 19 null
usermodified int8 19 null
app_user.id Defined in XMLR
achieved int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_dpobjescalvalu_id_pk Primary key Asc id
app_dpobjescalvalu_obj_ix Performance Asc objscaleid
app_dpobjescalvalu_use_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation