competency_plancomp

0 rows


Description

Plan competencies

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
planid BIGINT 19 null
competencyid BIGINT 19 null
competency.id competency_plancomp_erd_competencyR
sortorder BIGINT 19 null

Relative sort order

timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
competency_plancomp_erd_competency Performance Asc competencyid
compplan_placom2_uix Must be unique Asc/Asc planid + competencyid

Relationships