0 rows


Link a competency to a course.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
courseid BIGINT 19 null compcour_cou3_fkR

The course this competency is linked to.

competencyid BIGINT 19 null compcour_com2_fkR

The competency that is linked to this course.

ruleoutcome TINYINT 3 null

The rule that applies to the competency when the course is completed.

timecreated BIGINT 19 null

The time this link was created.

timemodified BIGINT 19 null

The time this link was modified.

usermodified BIGINT 19 null compcour_use5_fkR

The user who modified this link.

sortorder BIGINT 19 null

The display order for this link.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compcour_com_ix Performance Asc competencyid
compcour_cou_ix Performance Asc courseid
compcour_coucom_uix Must be unique Asc/Asc courseid + competencyid
compcour_courul_ix Performance Asc/Asc courseid + ruleoutcome
compcour_use2_ix Performance Asc usermodified