Enrol Table Schema (enrol)


Description

Instances of enrolment plugins used in courses, fields marked as custom have a plugin defined meaning, core does not touch them. Create a new linked table if you need even more custom fields.

enrol table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
enrol_lti_tools.enrolid enroltitool_enr2_fk R
user_enrolments.enrolid userenro_enr2_fk R
enrol varchar 20
status bigint 10 0

0..9 are system constants, 0 means active enrolment, see ENROL_STATUS_* constants, plugins may define own status greater than 10

courseid bigint 10 null
course.id enro_cou2_fk R
sortorder bigint 10 0

order of enrol plugins in each course

name varchar 255 null

Optional instance name

enrolperiod bigint 10 0

Custom - enrolment duration

enrolstartdate bigint 10 0

Custom - start of self enrolment

enrolenddate bigint 10 0

Custom - end of enrolment

expirynotify BIT 1 0

Custom - notify users before expiration

expirythreshold bigint 10 0

Custom - when should be the participants notified

notifyall BIT 1 0

Custom - Notify both participant and person responsible for enrolments

password varchar 50 null

Custom - enrolment or access password

cost varchar 20 null

Custom - enrolment cost

currency varchar 3 null

Custom - cost currency

roleid bigint 10 0
role.id Implied Constraint R

Custom - the default role given to participants who self-enrol

customint1 bigint 10 null

Custom - general int

customint2 bigint 10 null

Custom - general int

customint3 bigint 10 null

Custom - general int

customint4 bigint 10 null

Custom - general int

customint5 bigint 10 null

Custom - general int

customint6 bigint 10 null

Custom - general int

customint7 bigint 10 null

Custom - general int

customint8 bigint 10 null

Custom - general int

customchar1 varchar 255 null

Custom - general short name

customchar2 varchar 255 null

Custom - general short name

customchar3 varchar 1333 null

Custom - general short name

customdec1 decimal 12 null

Custom - general decimal

customdec2 decimal 12 null

Custom - general decimal

customtext1 longtext 2147483647 null

Custom - general text

customtext2 longtext 2147483647 null

Custom - general text

customtext3 longtext 2147483647 null

Custom - general text

customtext4 longtext 2147483647 null

Custom - general text

timecreated bigint 10 0
timemodified bigint 10 0

Table contained -1 rows

enrol table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enro_cou_ix Performance Asc courseid
enro_enr_ix Performance Asc enrol

enrol table relationships