Competency Coursecomp Table Schema (competency_coursecomp)


Description

Link a competency to a course.

competency_coursecomp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
courseid bigint 10 null
course.id compcour_cou3_fk R

The course this competency is linked to.

competencyid bigint 10 null
competency.id compcour_com2_fk R

The competency that is linked to this course.

ruleoutcome tinyint 2 null

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

timecreated bigint 10 null

The time this link was created.

timemodified bigint 10 null

The time this link was modified.

usermodified bigint 10 null

The user who modified this link.

sortorder bigint 10 null

The display order for this link.

Table contained -1 rows

competency_coursecomp table indexes

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

competency_coursecomp table relationships