Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| usingcontextid | BIGINT | 19 | 0 |
|
|
Context where question is used. |
||||
| component | VARCHAR | 100 | √ | null |
|
|
Component (e.g. mod_quiz) |
|||
| questionarea | VARCHAR | 50 | √ | null |
|
|
Depending on the component, which area the question is used in (e.g. slot for quiz). |
|||
| itemid | BIGINT | 19 | √ | null |
|
|
Plugin specific id (e.g. slotid for quiz) where its used. |
|||
| questionscontextid | BIGINT | 19 | 0 |
|
|
Context questions come from. |
||||
| filtercondition | LONGTEXT | 2147483647 | √ | null |
|
|
Filter expression in json format |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| quessetrefe_que_ix | Performance | Asc | questionscontextid |
| quessetrefe_usi_ix | Performance | Asc | usingcontextid |
| quessetrefe_usicomqueite_uix | Must be unique | Asc/Asc/Asc/Asc | usingcontextid + component + questionarea + itemid |