competency_plan

0 rows


Description

Learning plans

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
name VARCHAR 100
description LONGTEXT 2147483647 null
descriptionformat SMALLINT 5 0
userid BIGINT 19 null
templateid BIGINT 19 null
competency_template.id competency_plan_erd_competency_templateR
origtemplateid BIGINT 19 null

The template ID this plan was based on originally

status BIT 1 null
duedate BIGINT 19 0
reviewerid BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 0
usermodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compplan_stadue2_ix Performance Asc/Asc status + duedate
compplan_tem2_ix Performance Asc templateid
compplan_usesta2_ix Performance Asc/Asc userid + status

Relationships