I'm using confluence to store visio and graphics files to document flow and relationships in MyUCDavis cms.
RELATIONSHIPS BETWEEN QUIZZES, CATEGORIES, SECTIONS AND THE QUESTION CATALOG
A top down review of the existing tables and data shows the following hierarchical structure for quizzes in the MyUCDavis cms.
The key table is qz_quiz which contains the primary key identifying the quiz (quizID), the kerberos_name of the owner, quiz type information