0 rows


User competencies in a course


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

User associated to the competency.

courseid BIGINT 19 null Implied ConstraintR

The course this competency is linked to.

competencyid BIGINT 19 null competency_usercompcourse_erd_competencyR

Competency associated to the user.

proficiency TINYINT 3 null

Indicate if the competency is proficient not.

grade BIGINT 19 null

The course grade assigned for the competency.

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


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
competency_usercompcourse_erd_competency Performance Asc competencyid
compuser_use2_ix Performance Asc usermodified
compuser_usecoucom_uix Must be unique Asc/Asc/Asc userid + courseid + competencyid