SQL Generator also adds in around 50 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 hereI 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 Links to diagrams for older versions of Moodle can be found here http://www.examulator.com/er/archive.html
For consultancy and custom development contact Moodle Partners Titus Learning