question_attempt_steps

0 rows


Description

Stores one step in in a question attempt. As well as the dat

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
sequencenumber BIGINT 19 null
state VARCHAR 13
fraction DECIMAL 12,7 √ null
timecreated BIGINT 19 null
userid BIGINT 19 √ null
user.id quesattestep_use2_fkR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesattestep_que4_ix Performance Asc questionattemptid
quesattestep_queseq2_uix Must be unique Asc/Asc questionattemptid + sequencenumber
quesattestep_use4_ix Performance Asc userid

Relationships

Close relationships within degrees of separation