TABLES
8
VIEWS
0
COLUMNS
72
Constraints
9
Anomalies
0
Routines
0
Database Properties
Database Type: MySQL - 5.7.25
Schema moodle3.8
The Moodle Question bank
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| question_usages | 1 | 0 | 4 | 0 | Table | This table’s main purpose it to assign a unique id to each a |
| question_attempt_steps | 1 | 1 | 7 | 0 | Table | Stores one step in in a question attempt. As well as the dat |
| question_attempts | 1 | 2 | 14 | 0 | Table | Each row here corresponds to an attempt at one question, as |
| question_attempt_step_data | 0 | 1 | 4 | 0 | Table | Each question_attempt_step has an associative array of the d |
| question_hints | 0 | 1 | 7 | 0 | Table | Stores the the part of the question definition that gives di |
| question_categories | 2 | 1 | 9 | 0 | Table | Categories are for grouping questions |
| question_answers | 0 | 1 | 7 | 0 | Table | Answers, with a fractional grade (0-1) and feedback |
| question | 4 | 2 | 20 | 0 | Table | The questions themselves |