Competency Userevidencecomp Table Schema (competency_userevidencecomp)


Description

Relationship between user evidence and competencies

competency_userevidencecomp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
userevidenceid bigint 10 null
user.id Implied Constraint R
competencyid bigint 10 null
competency.id Implied Constraint R
timecreated bigint 10 null
timemodified bigint 10 null
usermodified bigint 10 null

Table contained -1 rows

competency_userevidencecomp table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compuser_use2_ix Performance Asc userevidenceid
compuser_usecom2_uix Must be unique Asc/Asc userevidenceid + competencyid

competency_userevidencecomp table relationships