app_competency_plan

0 rows


Description

Learning plans

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_competency_plan_id_seq'::regclass)
name varchar 100 ''::character varying
description text 2147483647 null
descriptionformat int2 5 0
userid int8 19 null
templateid int8 19 null
origtemplateid int8 19 null
status int2 5 null
duedate int8 19 0
reviewerid int8 19 null
timecreated int8 19 null
timemodified int8 19 0
usermodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_compplan_id_pk Primary key Asc id
app_compplan_stadue_ix Performance Asc/Asc status + duedate
app_compplan_tem_ix Performance Asc templateid
app_compplan_usesta_ix Performance Asc/Asc userid + status

Relationships