Moodle Database by Marcus Green

Table and relationship documentation generated from Moodle source code

This information is generated from the Moodle database schema as contained in the Moodle install.xml files.  A standard Moodle install discards all field comments and foreign key relationships. The SQL for this install was generated using the local_sqlgenerator plugin I created (https://github.com/marcusgreen/moodle_local-sqlgenerator) which preserves that information. The data from that installation was extracted using  schemaspy ( http://schemaspy.org/).

SQL Generator also adds in around 70 additional foreign key relationships that are implied but not included in the xml install files. I plan to take the orphaned table information from schemaspy to create additional foreign keys.

The grid below is to help identify sections of Moodle functionality. You can go directly to the index of all tables here

I started work on the first versions of this docmentation in early 2004, see this discussion https://moodle.org/mod/forum/discuss.php?d=3935#p28845

Archive of old versions

http://www.examulator.com/er/archive.html

For consultancy and custom development contact Moodle Partners Titus Learning