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
user.id compplan_use5_fkR

Indexes

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

Relationships