competency_usercompcourse

0 rows


Description

User competencies in a course

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null
courseid BIGINT 19 null
course.id Implied ConstraintR
competencyid BIGINT 19 null
competency.id competency_usercompcourse_erd_competencyR
proficiency TINYINT 3 null
grade BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Indexes

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

Relationships