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_attempts.questionusageid quizoverregr_queslo2_fk R

Foreign key references question_usages.id, or equivalently quiz_attempt.uniqueid.
slot BIGINT 19 null
question_attempts.slot quizoverregr_queslo2_fk R

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_ix Performance Asc/Asc questionusageid + slot

quiz_overview_regrades table relationships

Close relationships within degrees of separation