...
- 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 where 'q' indicates a quiz, 'a' indicates and answer key, and null exists for all other types of (non-quiz) records.
Additional fields designate to whom and when course information, in this case, quizzes, are released.
- secure: if secure is 'Y', only enrolled students, instructor and proxies may view
- hidden: if hidden is 'Y', quiz does not appear in course for anyone
- release_flag: if release_flag is 'Y', this indicates a record in the selective_release table is set for this quiz. Selective releases are set by date, by person (e.g., to a particular student), by course (if using joined sections - specify particular sections for release), or by page (i.e., uses users stats to see if the person has viewed a particular page first.)
RELATIONSHIPS BETWEEN QUIZZES, CATEGORIES, SECTIONS AND THE QUESTION CATALOG
...