app_dp_plan_competency_assign

0 rows


Description

Stores competencies assigned to a particular plan

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_dp_plan_competency_assign_id_seq'::regclass)
planid int8 19 null
app_dp_plan.id Defined in XMLR
competencyid int8 19 null
app_comp.id Defined in XMLR
priority int8 19 √ null
app_dp_priority_scale_value.id Defined in XMLR
duedate int8 19 √ null
approved int2 5 0
reasonfordecision text 2147483647 √ null
scalevalueid int8 19 0
app_comp_scale_values.id Defined in XMLR
manual int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_dpplancompassi_id_pk Primary key Asc id
app_dpplancompassi_com_ix Performance Asc competencyid
app_dpplancompassi_pla_ix Performance Asc planid
app_dpplancompassi_placom_uix Must be unique Asc/Asc planid + competencyid
app_dpplancompassi_pri_ix Performance Asc priority
app_dpplancompassi_sca_ix Performance Asc scalevalueid

Relationships

Close relationships within degrees of separation