Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||||||
enrol | VARCHAR | 20 |
|
|
||||||||||
status | BIGINT | 19 | 0 |
|
|
0..9 are system constants, 0 means active enrolment, see ENROL_STATUS_* constants, plugins may define own status greater than 10 |
||||||||
courseid | BIGINT | 19 | null |
|
|
|||||||||
sortorder | BIGINT | 19 | 0 |
|
|
order of enrol plugins in each course |
||||||||
name | VARCHAR | 255 | √ | null |
|
|
Optional instance name |
|||||||
enrolperiod | BIGINT | 19 | √ | 0 |
|
|
Custom - enrolment duration |
|||||||
enrolstartdate | BIGINT | 19 | √ | 0 |
|
|
Custom - start of self enrolment |
|||||||
enrolenddate | BIGINT | 19 | √ | 0 |
|
|
Custom - end of enrolment |
|||||||
expirynotify | BIT | 1 | √ | 0 |
|
|
Custom - notify users before expiration |
|||||||
expirythreshold | BIGINT | 19 | √ | 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 | 19 | √ | 0 |
|
|
Custom - the default role given to participants who self-enrol |
|||||||
customint1 | BIGINT | 19 | √ | null |
|
|
Custom - general int |
|||||||
customint2 | BIGINT | 19 | √ | null |
|
|
Custom - general int |
|||||||
customint3 | BIGINT | 19 | √ | null |
|
|
Custom - general int |
|||||||
customint4 | BIGINT | 19 | √ | null |
|
|
Custom - general int |
|||||||
customint5 | BIGINT | 19 | √ | null |
|
|
Custom - general int |
|||||||
customint6 | BIGINT | 19 | √ | null |
|
|
Custom - general int |
|||||||
customint7 | BIGINT | 19 | √ | null |
|
|
Custom - general int |
|||||||
customint8 | BIGINT | 19 | √ | 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,7 | √ | null |
|
|
Custom - general decimal |
|||||||
customdec2 | DECIMAL | 12,7 | √ | 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 | 19 | 0 |
|
|
|||||||||
timemodified | BIGINT | 19 | 0 |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
enro_cou_ix | Performance | Asc | courseid |
enro_enr_ix | Performance | Asc | enrol |
enro_rol_ix | Performance | Asc | roleid |