Competency Usercompcourse Table Schema (competency_usercompcourse)


Description

User competencies in a course

competency_usercompcourse table columns

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

User associated to the competency.

courseid bigint 10 null
course.id Implied Constraint R

The course this competency is linked to.

competencyid bigint 10 null
competency.id Implied Constraint R

Competency associated to the user.

proficiency tinyint 2 null

Indicate if the competency is proficient not.

grade bigint 10 null

The course grade assigned for the competency.

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

Table contained -1 rows

competency_usercompcourse table indexes

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

competency_usercompcourse table relationships