Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Quizzes exist independent of courses a course until the instructor or proxy user adds the quiz to a course via Website Builder. When the quiz is added to the course, a record is generated in page_metadata which generates a quiz link in the code based plus detail information like the order the quiz link appears on the page, release information, and whether the link is currently visible.
The sole association between the two tables is that the quizID of qz_quiz is entered in the file_name field of page_metatdata.

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.

...