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 |