0 rows


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


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


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