user_enrolments

0 rows


Description

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

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_fkR
userid BIGINT 19 null
user.id userenro_use2_fkR
timestart BIGINT 19 0
timeend BIGINT 19 2147483647
modifierid BIGINT 19 0
user.id userenro_mod2_fkR
timecreated BIGINT 19 0
timemodified BIGINT 19 0

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

Relationships