app_dp_plan_history

0 rows


Description

A table for tracking and recording modifications to a related dp_plan

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_dp_plan_history_id_seq'::regclass)
planid int8 19 null
app_dp_plan.id Defined in XMLR
status int2 5 null
reason int2 5 null
reasonfordecision text 2147483647 null
timemodified int8 19 null
usermodified int8 19 null
app_user.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_dpplanhist_id_pk Primary key Asc id
app_dpplanhist_pla_ix Performance Asc planid
app_dpplanhist_use_ix Performance Asc usermodified

Relationships