Good day folks,
maybe I am missing something here but do foreign keys really not get installed in the database when Moodle is installed?
I see some keys defined in the install.xml files but they aren't present in the DB. Maybe this is just an installation thing and a script needs to be run afterwards?
Cheers
You are not missing anything. The Foreign Key information in the xml is discarded during installation along with field level comments.
You can read more about it here
https://github.com/marcusgreen/moodle_local-sqlgenerator/wiki
And the results of my work on table relationships can be seen in this set of er diagrams
https://www.examulator.com/er/output/relationships.html
and table descriptions.
https://www.examulator.com/er/output/index.html
The introduction page.
