Question Attempt Step Data Table Schema (question_attempt_step_data)


Description

Each question_attempt_step has an associative array of the data that was submitted by the user in the POST request. It can also contain extra data from the question type or behaviour to avoid re-computation. The convention is that names belonging to the behaviour start with -, and cached values added to the submitted data start with _, or _-

question_attempt_step_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
attemptstepid BIGINT 19 null
question_attempt_steps.id quesattestepdata_att2_fk R

Foreign key, references question_attempt_steps.id
name VARCHAR 32

The name of this bit of data.
value LONGTEXT 2147483647 √ null

The corresponding value

Table contained -1 rows

question_attempt_step_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesattestepdata_att_ix Performance Asc attemptstepid

question_attempt_step_data table relationships

Close relationships within degrees of separation