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