Competency Plancomp Table Schema (competency_plancomp)


Description

Plan competencies

competency_plancomp table columns

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

Relative sort order

timecreated bigint 10 null
timemodified bigint 10 null
usermodified bigint 10 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