# question_attempts

0 rows

### Description

Each row here corresponds to an attempt at one question, as part of a question_usage. A question_attempt will have some question_attempt_steps For documentation https://docs.moodle.org/dev/Overview_of_the_Moodle_question_engine

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
question_attempt_steps.questionattemptid | quesattestep_que2_fkR
questionusageid | BIGINT | 19 |  |  | null |
quiz_overview_regrades.questionusageid | quizoverregr_queslo2_fkR
question_usages.id | quesatte_que4_fkR
| Foreign key, references question_usages.id
slot | BIGINT | 19 |  |  | null |
quiz_overview_regrades.slot | quizoverregr_queslo2_fkR
|  | Used to number the questions in one attempt sequentially.
behaviour | VARCHAR | 32 |  |  |  |  |  | The name of the question behaviour that is managing this question attempt.
questionid | BIGINT | 19 |  |  | null |  |
question.id | quesatte_que3_fkR
| The id of the question being attempted. Foreign key references question.id.
variant | BIGINT | 19 |  |  | 1 |  |  | The variant of the qusetion being used.
maxmark | DECIMAL | 12,7 |  |  | null |  |  | The grade this question is marked out of in this attempt.
minfraction | DECIMAL | 12,7 |  |  | null |  |  | Some questions can award negative marks. This indicates the most negative mark that can be awarded, on the faction scale where the maximum positive mark is 1.
maxfraction | DECIMAL | 12,7 |  |  | 1.0000000 |  |  | Some questions can give fractions greater than 1. This indicates the greatest fraction that can be awarded.
flagged | BIT | 1 |  |  | 0 |  |  | Whether this question has been flagged within the attempt.
questionsummary | LONGTEXT | 2147483647 | √ |  | null |  |  | If this question uses randomisation, it should set this field to summarise what random version the student actually saw. This is a human-readable textual summary of the student's response which might, for example, be used in a report.
rightanswer | LONGTEXT | 2147483647 | √ |  | null |  |  | This is a human-readable textual summary of the right answer to this question. Might be used, for example on the quiz preview, to help people who are testing the question. Or might be used in reports.
responsesummary | LONGTEXT | 2147483647 | √ |  | null |  |  | This is a textual summary of the student's response (basically what you would expect to in the Quiz responses report).
timemodified | BIGINT | 19 |  |  | null |  |  | The time this record was last changed.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
quesatte_beh_ix | Performance | Asc | behaviour
quesatte_que2_ix | Performance | Asc | questionusageid
quesatte_que_ix | Performance | Asc | questionid
quesatte_queslo_uix | Must be unique | Asc/Asc | questionusageid + slot

### Relationships