competency_template

0 rows


Description

Learning plan templates.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
competency_plan.templateid competency_plan_erd_competency_templateR
competency_templatecohort.templateid competency_templatecohort_erd_competency_templateR
competency_templatecomp.templateid comptemp_tem2_fkR
shortname VARCHAR 100 √ null
contextid BIGINT 19 null
context.id Implied ConstraintR
description LONGTEXT 2147483647 √ null
descriptionformat SMALLINT 5 0
visible TINYINT 3 1
duedate BIGINT 19 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation