Tables


SchemaSpy Analysis of moodle_401

Generated on Sun Jan 01 08:14 GMT 2023

Course tables: got to http://www.examulator.com/er for all Moodle tables

XML Representation
Insertion Order Deletion Order
TABLES 6
VIEWS 0
COLUMNS 125
Constraints 8
Anomalies 1
Routines 0

Database Properties

Database Type: MySQL - 8.0.31-0ubuntu0.22.04.1

Tables

Table / View Children Parents Columns Rows Type Comments
course_sections 0 4 10 0 Table

to define the sections for each course

enrol 0 4 35 0 Table

Instances of enrolment plugins used in courses, fields marke

course_categories 12 8 14 0 Table

Course categories

course_format_options 0 4 6 0 Table

Stores format-specific options for the course or course sect

course 20 8 36 0 Table

Central course table

course_modules 0 4 24 0 Table

course_modules table retrofitted from MySQL