Mnetservice Enrol Enrolments Table Schema (mnetservice_enrol_enrolments)


Description

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 10 null

Unique enrollment ID

hostid bigint 10 null
mnet_host.id mnetenroenro_hos2_fk R

ID of the remote MNet host

userid bigint 10 null
user.id mnetenroenro_use2_fk R

ID of our local user on this server

remotecourseid bigint 10 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 10 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