Quiz Feedback Table Schema (quiz_feedback)


Description

Feedback given to students based on which grade band their overall score lies.

quiz_feedback table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
quizid BIGINT 19 0
quiz.id quizfeed_qui2_fk R

Foreign key references quiz.id.

feedbacktext LONGTEXT 2147483647 null

The feedback to show for a attempt where mingrade <= attempt grade < maxgrade. See function quiz_feedback_for_grade in mod/quiz/locallib.php.

feedbacktextformat TINYINT 3 0
mingrade DECIMAL 10,5 0.00000

The lower limit of this grade band. Inclusive.

maxgrade DECIMAL 10,5 0.00000

The upper limit of this grade band. Exclusive.

Table contained -1 rows

quiz_feedback table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizfeed_qui_ix Performance Asc quizid

quiz_feedback table relationships