# question_attempt_steps

0 rows

### Description

Stores one step in in a question attempt. As well as the data here, the step will have some data in the question_attempt_step_data table.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
question_attempt_step_data.attemptstepid | quesattestepdata_att2_fkR
questionattemptid | BIGINT | 19 |  |  | null |  |
question_attempts.id | quesattestep_que2_fkR
| Foreign key, references question_attempt.id
sequencenumber | BIGINT | 19 |  |  | null |  |  | Numbers the steps in a question attempt sequentially from 0.
state | VARCHAR | 13 |  |  |  |  |  | One of the constants defined by the question_state class, giving the state of the question at the end of this step.
fraction | DECIMAL | 12,7 | √ |  | null |  |  | The grade for this question, when graded out of 1. Needs to be multiplied by question_attempt.maxmark to get the actual mark for the question.
timecreated | BIGINT | 19 |  |  | null |  |  | Time-stamp of the action that lead to this state being created. If this is -1 (quiz_attempt_step::TIMECREATED_ON_FIRST_RENDER), it will be set the first time the question attempt is rendered.
userid | BIGINT | 19 | √ |  | null |  |
user.id | quesattestep_use2_fkR
| The user whose action lead to this state being created.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
quesattestep_que_ix | Performance | Asc | questionattemptid
quesattestep_queseq_uix | Must be unique | Asc/Asc | questionattemptid + sequencenumber
quesattestep_use_ix | Performance | Asc | userid

### Relationships