quiz_grade_items

0 rows


Description

Where a quiz supports mulitple grades, this table stores what those grade items are.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
quiz_slots.quizgradeitemid quizslot_qui4_fkR
quizid BIGINT 19 null
quiz.id quizgraditem_qui2_fkR

Foreign key references quiz.id.

sortorder BIGINT 19 null

Used to control the order of the grade items when they are displayed

name VARCHAR 255 ''

The name of this grade-item. PARAM_TEXT.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizgraditem_qui_ix Performance Asc quizid
quizgraditem_quisor_uix Must be unique Asc/Asc quizid + sortorder

Relationships