0 rows


Stores data about the tags that a question must have so that


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

The quiz slot that this tag belong to

tagid BIGINT 19 null
tag.id quizslottags_tag2_fkR
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).


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