competency_coursecomp

0 rows


Description

Link a competency to a course.

Columns

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

The course this competency is linked to.

competencyid BIGINT 19 null
competency.id 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
user.id compcour_use5_fkR

The user who modified this link.

sortorder BIGINT 19 null

The display order for this link.

Indexes

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

Relationships