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.

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_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