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 or core_question) |
|||
| 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. |
|||
| questionbankentryid | BIGINT | 19 | 0 |
|
|
ID of the question bank entry this question is part of. |
||||
| version | BIGINT | 19 | √ | null |
|
|
Version number for the question where NULL means use the latest ready version. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| quesrefe_que_ix | Performance | Asc | questionbankentryid |
| quesrefe_usi_ix | Performance | Asc | usingcontextid |
| quesrefe_usicomqueite_uix | Must be unique | Asc/Asc/Asc/Asc | usingcontextid + component + questionarea + itemid |