Competency Usercompplan Table Schema (competency_usercompplan)


User competencies plans

competency_usercompplan table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
userid bigint 10 null Implied Constraint R

User associated to the competency.

competencyid bigint 10 null Implied Constraint R

Competency associated to the user.

planid bigint 10 null

Plan associated to the user.

proficiency tinyint 2 null

Indicate if the competency is proficient not.

grade bigint 10 null

Grade assigned to the competency.

sortorder bigint 10 null

Relative sort order

timecreated bigint 10 null
timemodified bigint 10 null
usermodified bigint 10 null

Table contained -1 rows

competency_usercompplan table indexes

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

competency_usercompplan table relationships