TABLES
11
VIEWS
0
COLUMNS
129
Constraints
10
Anomalies
2
Routines
0
Database Properties
Database Type: MySQL - 8.0.31-0ubuntu0.22.04.1
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| quiz_grades | 0 | 4 | 5 | 0 | Table | Stores the overall grade for each user on the quiz, based on |
| question_usages | 8 | 0 | 4 | 0 | Table | This table’s main purpose it to assign a unique id to each a |
| quiz | 24 | 0 | 41 | 0 | Table | The settings for each quiz. |
| quiz_slots | 0 | 4 | 6 | 0 | Table | Stores the question used in a quiz, with the order, and for |
| quiz_feedback | 0 | 4 | 6 | 0 | Table | Feedback given to students based on which grade band their o |
| question_attempts | 0 | 8 | 14 | 0 | Table | Each row here corresponds to an attempt at one question, as |
| quiz_sections | 0 | 4 | 5 | 0 | Table | Stores sections of a quiz with section name (heading), from |
| question | 9 | 4 | 16 | 0 | Table | This table stores the definition of one version of a questio |
| quiz_attempts | 0 | 8 | 16 | 0 | Table | Stores users attempts at quizzes. |
| quiz_overrides | 0 | 4 | 9 | 0 | Table | The overrides to quiz settings on a per-user and per-group b |
| question_references | 0 | 1 | 7 | 0 | Table | Records where a specific question is used. |