app_comp_criteria_record

0 rows


Description

Deprecated since Totara 13, please do not use

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 XML R
competencyid int8 19 null
app_comp.id Defined in XML R
itemid int8 19 null
app_comp_criteria.id Defined in XML R
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