Dp Plan Objective Table Schema (dp_plan_objective)


Description

One row for each objective in a plan

dp_plan_objective table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
planid BIGINT 19 null
dp_plan.id dpplanobje_pla2_fk R
fullname VARCHAR 255 √ null
shortname VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
priority BIGINT 19 √ null
dp_priority_scale_value.id dpplanobje_pri2_fk R
duedate BIGINT 19 √ null
scalevalueid SMALLINT 5 null
approved SMALLINT 5 0
reasonfordecision LONGTEXT 2147483647 √ null

The reason for approving/declining the request
manual BIT 1 0

Was this assignment made manually
timecreated BIGINT 19 √ null
timemodified BIGINT 19 √ null

Table contained -1 rows

dp_plan_objective table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpplanobje_pla_ix Performance Asc planid
dpplanobje_pri_ix Performance Asc priority
dpplanobje_sca_ix Performance Asc scalevalueid

dp_plan_objective table relationships

Close relationships within degrees of separation