Competency Evidence Table Schema (competency_evidence)


Description

The evidence linked to a user competency

competency_evidence table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
usercompetencyid bigint 10 null
user.id Implied Constraint R
contextid bigint 10 null
context.id Implied Constraint R
action tinyint 2 null
actionuserid bigint 10 null
descidentifier varchar 255
desccomponent varchar 255
desca longtext 2147483647 null
url varchar 255 null
grade bigint 10 null
note longtext 2147483647 null

A non-localised text to attach to the evidence.

timecreated bigint 10 null
timemodified bigint 10 null
usermodified bigint 10 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