# question_usages

0 rows

### Description

This table’s main purpose it to assign a unique id to each attempt at a set of questions by some part of Moodle. A question usage is made up of a number of question_attempts.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
question_attempts.questionusageid | quesatte_que4_fkR
quiz_attempts.uniqueid | quizatte_uni_fkR
contextid | BIGINT | 19 |  |  | null |  |
context.id | quesusag_con2_fkR
| Every question usage must be associated with some context.
component | VARCHAR | 255 |  |  |  |  |  | The plugin this attempt belongs to, e.g. 'mod_quiz', 'block_questionoftheday', 'filter_embedquestion'.
preferredbehaviour | VARCHAR | 32 |  |  |  |  |  | The archetypal behaviour that should be used for question attempts in this usage.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
quesusag_con_ix | Performance | Asc | contextid

### Relationships