...
The sole association between the two tables is that the quizID of qz_quiz is entered in the file_name field of page_metatdata.
Note - relationships between quizzes a quiz taken, a the course, and a the student are defined in the qzt_top table.
...
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 independent of courses and the fields 'term' and 'crn' in qz_quiz are unused - i.e., every record has nulls in these two fields.
The primary keys in page_metatdata include term_code, crn, and pid, where pid refers to a page id which is defined by the order in which items are added to the course website beginning with '1'. The combination of these non-unique keys form a unique primary key.
RELATIONSHIPS BETWEEN QUIZZES, CATEGORIES, SECTIONS AND THE QUESTION CATALOG
...