quiz_overview_regrades

0 rows


Description

This table records which question attempts need regrading an

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
questionusageid BIGINT 19 null
question_attempts.questionusageid quizoverregr_queslo2_fkR

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

slot BIGINT 19 null
question_attempts.slot quizoverregr_queslo2_fkR

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.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizoverregr_queslo_ix Performance Asc/Asc questionusageid + slot

Relationships