Comp Criteria Record Table Schema (comp_criteria_record)


Description

Tracks historical progress towards a competency for each user

comp_criteria_record table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 null
user.id compcritreco_use2_fk R
competencyid BIGINT 19 null
comp.id compcritreco_com2_fk R
itemid BIGINT 19 null
comp_criteria.id compcritreco_ite2_fk R
status TINYINT 3 √ null
proficiencymeasured BIGINT 19 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

comp_criteria_record table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compcritreco_com_ix Performance Asc competencyid
compcritreco_ite_ix Performance Asc itemid
compcritreco_pro_ix Performance Asc proficiencymeasured
compcritreco_tim_ix Performance Asc timemodified
compcritreco_use_ix Performance Asc userid
compcritreco_usecomite_uix Must be unique Asc/Asc/Asc userid + competencyid + itemid
compcritreco_useite_ix Performance Asc/Asc userid + itemid

comp_criteria_record table relationships

Close relationships within degrees of separation