...
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 independent of courses and the fields 'term' and 'crn' in qz_quiz are unused irrelevent - 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.
Other important fields include:
- page_name which is generated by wrapping the following text around the quiz name: "Take the " + qz_quiz.quizname + " Quiz"
- file_name which is a varchar field that stores the numeric quiz id
- user_account which stores the course instructor's kerberos name - NOT the name of the quiz owner or person who added the quiz (which could be the instructor or someone with proxy access to the course"
- activity_date which is either the add and last edit date
- is_quiz which is a single varchar field
RELATIONSHIPS BETWEEN QUIZZES, CATEGORIES, SECTIONS AND THE QUESTION CATALOG
...