app_mnetservice_enrol_courses

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_mnetservice_enrol_courses_id_seq'::regclass)
hostid int8 19 null
remoteid int8 19 null
categoryid int8 19 null
categoryname varchar 255 ''::character varying
sortorder int8 19 0
fullname varchar 254 ''::character varying
shortname varchar 100 ''::character varying
idnumber varchar 100 ''::character varying
summary text 2147483647 null
summaryformat int2 5 0
startdate int8 19 null
roleid int8 19 null
rolename varchar 255 ''::character varying

Indexes

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

Diagram producer might be missing

No diagrams were produced please see application output for any errors