competency_evidence

0 rows


Description

The evidence linked to a user competency

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
usercompetencyid BIGINT 19 null
competency_usercomp.id competency_evidence_erd_competency_usercompR
contextid BIGINT 19 null
context.id compevid_con2_fkR
action TINYINT 3 null
actionuserid BIGINT 19 √ null
user.id compevid_act2_fkR
descidentifier VARCHAR 255
desccomponent VARCHAR 255
desca LONGTEXT 2147483647 √ null
url VARCHAR 255 √ null
grade BIGINT 19 √ null
note LONGTEXT 2147483647 √ null

A non-localised text to attach to the evidence.
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
user.id compevid_use2_fkR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compevid_act_ix Performance Asc actionuserid
compevid_con_ix Performance Asc contextid
compevid_use2_ix Performance Asc usermodified
compevid_use_ix Performance Asc usercompetencyid

Relationships

Close relationships within degrees of separation