quiz_attempts

0 rows


Description

Stores users attempts at quizzes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
quiz BIGINT 19 0
quiz.id quizatte_qui2_fkR
userid BIGINT 19 0
user.id quizatte_use2_fkR
attempt MEDIUMINT 7 0
uniqueid BIGINT 19 0
question_usages.id quizatte_uni_fkR
layout LONGTEXT 2147483647 null
currentpage BIGINT 19 0
preview SMALLINT 5 0
state VARCHAR 16 inprogress
timestart BIGINT 19 0
timefinish BIGINT 19 0
timemodified BIGINT 19 0
timemodifiedoffline BIGINT 19 0
timecheckstate BIGINT 19 0
sumgrades DECIMAL 10,5 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizatte_qui4_ix Performance Asc quiz
quizatte_quiuseatt2_uix Must be unique Asc/Asc/Asc quiz + userid + attempt
quizatte_statim2_ix Performance Asc/Asc state + timecheckstate
quizatte_uni2_uix Must be unique Asc uniqueid
quizatte_use4_ix Performance Asc userid

Relationships