User Enrolments Table Schema (user_enrolments)


Description

Users participating in courses (aka enrolled users) - everybody who is participating/visible in course, that means both teachers and students

user_enrolments table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
status BIGINT 19 0

0..9 are system constants, 0 means active participation, see ENROL_PARTICIPATION_* constants, plugins may define own status greater than 10
enrolid BIGINT 19 null
enrol.id userenro_enr2_fk R
userid BIGINT 19 null
user.id userenro_use2_fk R
timestart BIGINT 19 0
timeend BIGINT 19 2147483647
modifierid BIGINT 19 0
user.id userenro_mod2_fk R
timecreated BIGINT 19 0
timemodified BIGINT 19 0

Table contained -1 rows

user_enrolments table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userenro_enr_ix Performance Asc enrolid
userenro_enruse_uix Must be unique Asc/Asc enrolid + userid
userenro_mod_ix Performance Asc modifierid
userenro_use_ix Performance Asc userid

user_enrolments table relationships

Close relationships within degrees of separation