Mnetservice Enrol Courses Table Schema (mnetservice_enrol_courses)


Description

Caches the information fetched via XML-RPC about courses on remote hosts that are offered for our users

mnetservice_enrol_courses table columns

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

Unique remote-course ID

hostid BIGINT 19 null

The id of the remote MNet host

remoteid BIGINT 19 null

ID of course on its home server

categoryid BIGINT 19 null

The id of the category on the remote server

categoryname VARCHAR 255
sortorder BIGINT 19 0
fullname VARCHAR 254
shortname VARCHAR 100
idnumber VARCHAR 100
summary LONGTEXT 2147483647 null
summaryformat SMALLINT 5 0

Format of the summary field

startdate BIGINT 19 null
roleid BIGINT 19 null
role.id Implied Constraint R

The ID of the role at the remote server that our users will get when we enrol them there

rolename VARCHAR 255

The name of the role at the remote server that our users will get when we enrol them there

Table contained -1 rows

mnetservice_enrol_courses table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mnetenrocour_hosrem_uix Must be unique Asc/Asc hostid + remoteid

mnetservice_enrol_courses table relationships