Competency Template Table Schema (competency_template)


Description

Learning plan templates.

competency_template table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
competency_plan.templateid compplan_tem2_fk R
competency_templatecohort.templateid comptemp_tem4_fk R
competency_templatecomp.templateid comptemp_tem3_fk R
shortname VARCHAR 100 √ null

Short name for the learning plan template.
contextid BIGINT 19 null
context.id Implied Constraint R
description LONGTEXT 2147483647 √ null

Description of this learning plan template
descriptionformat SMALLINT 5 0

The format of the description field
visible TINYINT 3 1

Used to show/hide this learning plan template.
duedate BIGINT 19 √ null

The default due date for instances of this plan.
timecreated BIGINT 19 null

The time this learning plan template was created.
timemodified BIGINT 19 null

The time this learning plan template was last modified.
usermodified BIGINT 19 √ null

The user who last modified this learning plan template

Table contained -1 rows

competency_template table indexes

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

competency_template table relationships

Close relationships within degrees of separation