mnetservice_enrol_courses

0 rows


Description

Caches the information fetched via XML-RPC about courses on

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
hostid BIGINT 19 null
remoteid BIGINT 19 null
categoryid BIGINT 19 null
categoryname VARCHAR 255
sortorder BIGINT 19 0
fullname VARCHAR 254
shortname VARCHAR 100
idnumber VARCHAR 100
summary LONGTEXT 2147483647 null
summaryformat SMALLINT 5 √ 0
startdate BIGINT 19 null
roleid BIGINT 19 null
role.id Implied ConstraintR
rolename VARCHAR 255

Indexes

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

Relationships