app_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 bigserial 19 √ nextval('app_question_attempt_steps_id_seq'::regclass)
app_question_attempt_step_data.attemptstepid Defined in XMLR
questionattemptid int8 19 null
app_question_attempts.id Defined in XMLR
sequencenumber int8 19 null
state varchar 13 ''::character varying
fraction numeric 12,7 √ null
timecreated int8 19 null
userid int8 19 √ null
app_user.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_quesattestep_id_pk Primary key Asc id
app_quesattestep_que_ix Performance Asc questionattemptid
app_quesattestep_queseq_uix Must be unique Asc/Asc questionattemptid + sequencenumber
app_quesattestep_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation