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

Short name for the learning plan template.

contextid BIGINT 19 null
context.id comptemp_con2_fkR
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
user.id comptemp_use4_fkR

The user who last modified this learning plan template

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comptemp_con_ix Performance Asc contextid
comptemp_use_ix Performance Asc usermodified

Relationships