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 |