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 Implied ConstraintR
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

Indexes

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

Relationships

Close relationships within degrees of separation