RELATIONSHIP BETWEEN A QUIZ AND A COURSE
The relationship between a quiz and a course are all defined on the course side within the page_metadata table. Quiz records in qz_quiz are indepenant of courses and the fields 'term' and 'crn' are unused - i.e., every record has nulls in these two fields.
RELATIONSHIPS BETWEEN QUIZZES, CATEGORIES, SECTIONS AND THE QUESTION CATALOG
...