Competency Plan Table Schema (competency_plan)


Description

Learning plans

competency_plan table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
name varchar 100
description longtext 2147483647 null
descriptionformat smallint 4 0
userid bigint 10 null
user.id Implied Constraint R
templateid bigint 10 null
origtemplateid bigint 10 null

The template ID this plan was based on originally

status BIT 1 null
duedate bigint 10 0
reviewerid bigint 10 null
timecreated bigint 10 null
timemodified bigint 10 0
usermodified bigint 10 null

Table contained -1 rows

competency_plan table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compplan_stadue_ix Performance Asc/Asc status + duedate
compplan_tem_ix Performance Asc templateid
compplan_usesta_ix Performance Asc/Asc userid + status

competency_plan table relationships