competency_templatecomp

0 rows


Description

Link a competency to a learning plan template.

Columns

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

The template this competency is linked to.

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

The user who modified this link.

sortorder BIGINT 19 null

Relative sort order

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comptemp_com_ix Performance Asc competencyid
comptemp_tem_ix Performance Asc templateid
comptemp_use2_ix Performance Asc usermodified

Relationships