0 rows


Link a competency to a learning plan template.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
templateid BIGINT 19 null comptemp_tem2_fkR

The template this competency is linked to.

competencyid BIGINT 19 null competency_templatecomp_erd_competencyR

The competency that is linked to this course.

timecreated BIGINT 19 null

The time this link was created.

timemodified BIGINT 19 null

The time this link was modified.

usermodified BIGINT 19 null

The user who modified this link.

sortorder BIGINT 19 null

Relative sort order


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comptemp_com2_ix Performance Asc competencyid
comptemp_tem2_ix Performance Asc templateid