Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| contextlevel | BIGINT | 19 | 50 |
|
|
The context level for this item. Defaults to CONTEXT_COURSE. |
||||
| instanceid | BIGINT | 19 | null |
|
|
The id of the specific context instance. Course id for courses. |
||||
| contextid | BIGINT | 19 | √ | null |
|
|
Id of the specific context record. |
|||
| status | TINYINT | 3 | 0 |
|
|
The schedule status for this item. 0 = not requested; 1 = requested; 2 = analyzed. |
||||
| timeanalyzed | BIGINT | 19 | √ | 0 |
|
|
The most recent time the item was analyzed by scheduler. |
|||
| timemodified | BIGINT | 19 | √ | 0 |
|
|
Time stamp of the last record update. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| toolbricsche_conins_uix | Must be unique | Asc/Asc | contextlevel + instanceid |
| toolbricsche_sta_ix | Performance | Asc | status |