Competency Usercomp Table Schema (competency_usercomp)


Description

User competencies

competency_usercomp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
competency_evidence.usercompetencyid compevid_use2_fk R
userid BIGINT 19 null
user.id Implied Constraint R

User associated to the competency.
competencyid BIGINT 19 null
competency.id compuser_com_fk R

Competency associated to the user.
status TINYINT 3 0

Competency status.
reviewerid BIGINT 19 √ null

User that reviewed the competency.
proficiency TINYINT 3 √ null

Indicate if the competency is proficient not.
grade BIGINT 19 √ null

Grade assigned to the competency.
timecreated BIGINT 19 null
timemodified BIGINT 19 √ null
usermodified BIGINT 19 null

Table contained -1 rows

competency_usercomp table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compuser_com_fk Performance Asc competencyid
compuser_usecom_uix Must be unique Asc/Asc userid + competencyid

competency_usercomp table relationships

Close relationships within degrees of separation