Mnetservice Enrol Enrolments Table Schema (mnetservice_enrol_enrolments)


Caches the information about enrolments of our local users in courses on remote hosts

mnetservice_enrol_enrolments table columns

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

Unique enrollment ID

hostid BIGINT 19 null mnetenroenro_hos2_fk R

ID of the remote MNet host

userid BIGINT 19 null mnetenroenro_use2_fk R

ID of our local user on this server

remotecourseid BIGINT 19 null

ID of the course at the remote server. Note that this may and may not be cached in our mnetservice_enrol_courses table, depends of whether the course is opened for remote enrolments or our student is the enrolled there via other plugin

rolename VARCHAR 255
enroltime BIGINT 19 0
enroltype VARCHAR 20

The name of the enrol plugin at the remote server that was used to enrol our student into their course

Table contained -1 rows

mnetservice_enrol_enrolments table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mnetenroenro_hos_ix Performance Asc hostid
mnetenroenro_use_ix Performance Asc userid

mnetservice_enrol_enrolments table relationships