mnetservice_enrol_enrolments

0 rows


Description

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

Columns

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

Unique enrollment ID

hostid BIGINT 19 null
mnet_host.id mnetenroenro_hos2_fkR

ID of the remote MNet host

userid BIGINT 19 null
user.id mnetenroenro_use2_fkR

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

Indexes

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

Relationships