Entity relationship diagram - MariaDB or MySQL. Moodle.

Moodle – online ER diagram

Entity relationship diagram - MariaDB or MySQL. Moodle.

From moodle.org:

  • Moodle is the world’s most popular learning management system.
  • Moodle is a learning platform designed to provide educators, administrators and learners with a single robust, secure and integrated system to create personalised learning environments.
  • With over 10 years of development guided by social constructionist pedagogy, Moodle delivers a powerful set of learner-centric tools and collaborative learning environments that empower both teaching and learning.
  • Powering hundreds of thousands of learning environments globally.

For more information visit https://www.moodle.org
See https://en.wikipedia.org/wiki/Learning_management_system for details about learning management systems (LMS)

Online ER Diagram / database design

The database design was created by loading the database structure from a remotely hosted Moodle version 4-0-2. The target database was MariaDB. The diagram contains 468 tables. The amount of tables and metadata might affect the performance of the diagram/report, that’s why it is recommended to use Luna Modeler for better user experience.

How to use the ER diagram: click on a db table in the online ER Diagram. A new window opens – and in the window you can view the details of the table, including how indexes are defined and other details of the selected MariaDB table.

The database structure doesn’t include relationships and like in many other open source systems, database functions, table triggers and other database objects are not specified.

Details

Target database:
MariaDB

Diagram URL:
https://www.dbdiagrams.com/online-diagrams/moodle-4-0-2/

Luna Modeler project file:
https://www.dbdiagrams.com/online-diagrams/moodle.dmm

How to open a data model file in Luna Modeler

About Luna Modeler
Luna Modeler is an intuitive data modeling tool for relational databases.
With this powerful tool, you can create ER diagrams, design and visualize database structures, generate SQL scripts, and document your data models with ease. A feature-limited trial version is available for Windows, macOS and Linux.
For more information visit https://www.datensen.com

If you have suggestions or comments, send us a message to dbdiagrams(at)dbdiagrams.com.