app_competency_usercompplan

0 rows


Description

User competencies plans

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_competency_usercompplan_id_seq'::regclass)
userid int8 19 null
competencyid int8 19 null
planid int8 19 null
proficiency int2 5 null
grade int8 19 null
sortorder int8 19 null
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_compuser_id3_pk Primary key Asc id
app_compuser_usecompla_uix Must be unique Asc/Asc/Asc userid + competencyid + planid

Relationships