Competency Evidence Table Schema (competency_evidence)


The evidence linked to a user competency

competency_evidence table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
usercompetencyid BIGINT 19 null compevid_use2_fk R
contextid BIGINT 19 null Implied Constraint R
action TINYINT 3 null
actionuserid BIGINT 19 null
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

Table contained -1 rows

competency_evidence table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compevid_use_ix Performance Asc usercompetencyid

competency_evidence table relationships