0 rows


Tracks historical progress towards a competency for each user


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_comp_evidence_items_evidence_id_seq'::regclass)
userid int8 19 null
competencyid int8 19 null
itemid int8 19 null
status int2 5 null
proficiencymeasured int8 19 null
timecreated int8 19 null
timemodified int8 19 null


Constraint Name Type Sort Column(s)
app_compeviditemevid_id_pk Primary key Asc id
app_compeviditemevid_ite_ix Performance Asc itemid
app_compeviditemevid_pro_ix Performance Asc proficiencymeasured
app_compeviditemevid_tim_ix Performance Asc timemodified
app_compeviditemevid_use_ix Performance Asc userid
app_compeviditemevid_useco_uix Must be unique Asc/Asc/Asc userid + competencyid + itemid
app_compeviditemevid_useite_ix Performance Asc/Asc userid + itemid

Diagram producer might be missing

No diagrams were produced please see application output for any errors