0 rows


User competencies plans


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null Implied ConstraintR

User associated to the competency.

competencyid BIGINT 19 null competency_usercompplan_erd_competencyR

Competency associated to the user.

planid BIGINT 19 null

Plan associated to the user.

proficiency TINYINT 3 null

Indicate if the competency is proficient not.

grade BIGINT 19 null

Grade assigned to the competency.

sortorder BIGINT 19 null

Relative sort order

timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null


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