Competency Templatecomp Table Schema (competency_templatecomp)


Description

Link a competency to a learning plan template.

competency_templatecomp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
templateid bigint 10 null
competency_template.id comptemp_tem3_fk R

The template this competency is linked to.

competencyid bigint 10 null
competency.id comptemp_com2_fk R

The competency that is linked to this course.

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

Relative sort order

Table contained -1 rows

competency_templatecomp table indexes

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

competency_templatecomp table relationships