Quiz Overview Regrades Table Schema (quiz_overview_regrades)


Description

This table records which question attempts need regrading and the grade they will be regraded to.

quiz_overview_regrades table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
questionusageid BIGINT 19 null
question.id Implied Constraint R

Foreign key references question_usages.id, or equivalently quiz_attempt.uniqueid.

slot BIGINT 19 null

Foreign key, references question_attempts.slot

newfraction DECIMAL 12,7 null

The new fraction for this question_attempt after regrading.

oldfraction DECIMAL 12,7 null

The previous fraction for this question_attempt.

regraded SMALLINT 5 null

set to 0 if element has just been regraded. Set to 1 if element has been marked as needing regrading.

timemodified BIGINT 19 null

Timestamp of when this row was last modified.

Table contained -1 rows

quiz_overview_regrades table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizoverregr_queslo_uix Must be unique Asc/Asc questionusageid + slot

quiz_overview_regrades table relationships