Question Attempt Steps Table Schema (question_attempt_steps)


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.

question_attempt_steps table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
question_attempt_step_data.attemptstepid quesattestepdata_att2_fk R
questionattemptid BIGINT 19 null
question_attempts.id quesattestep_que2_fk R

Foreign key, references question_attempt.id
sequencenumber BIGINT 19 null

Numbers the steps in a question attempt sequentially.
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.
userid BIGINT 19 √ null
user.id quesattestep_use2_fk R

The user whose action lead to this state being created.

Table contained -1 rows

question_attempt_steps table 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

question_attempt_steps table relationships

Close relationships within degrees of separation