Competency Plancomp Table Schema (competency_plancomp)


Description

Plan competencies

competency_plancomp table columns

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

Relative sort order

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

Table contained -1 rows

competency_plancomp table indexes

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

competency_plancomp table relationships