app_comp_criteria_record

0 rows


Description

Tracks historical progress towards a competency for each user

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_comp_criteria_record_id_seq'::regclass)
userid int8 19 null
app_user.id Defined in XMLR
competencyid int8 19 null
app_comp.id Defined in XMLR
itemid int8 19 null
app_comp_criteria.id Defined in XMLR
status int2 5 null
proficiencymeasured int8 19 null
timecreated int8 19 null
timemodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_compcritreco_id_pk Primary key Asc id
app_compcritreco_com_ix Performance Asc competencyid
app_compcritreco_ite_ix Performance Asc itemid
app_compcritreco_pro_ix Performance Asc proficiencymeasured
app_compcritreco_tim_ix Performance Asc timemodified
app_compcritreco_use_ix Performance Asc userid
app_compcritreco_usecomite_uix Must be unique Asc/Asc/Asc userid + competencyid + itemid
app_compcritreco_useite_ix Performance Asc/Asc userid + itemid

Relationships