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 |