Quiz Slot Tags Table Schema (quiz_slot_tags)


Description

Stores data about the tags that a question must have so that it can be selected for a quiz slot (when having a random question by tags on that slot).

quiz_slot_tags table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
slotid BIGINT 19 √ null
quiz_slots.id quizslottags_slo2_fk R

The quiz slot that this tag belong to
tagid BIGINT 19 √ null
tag.id quizslottags_tag2_fk R
tagname VARCHAR 255 √ null

The tag name is to be stored as well, so we won't lose data if the tag is removed from Moodle (A tag with the same name might be added in future).

Table contained -1 rows

quiz_slot_tags table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizslottags_slo_ix Performance Asc slotid
quizslottags_tag_ix Performance Asc tagid

quiz_slot_tags table relationships

Close relationships within degrees of separation