Competency Usercomp Table Schema (competency_usercomp)


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 Implied Constraint R

User associated to the competency.

competencyid BIGINT 19 null 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