The Schema Visualized The Entity Relationship Diagram (ERD) above was constructed using the data found in the information_schema.columns table. (Thank you to ashleedawg for paring the table down to its bare essentials).
All the table, column and key information waswere compiled into a SQL script using python3. The results were cross validated with the accepted answer above, and the few idiosyncratic foreign key formations left over were hardcoded in at the end.)
The ERD was then reverse engineered using dbschema.
Please find the script that wrote the SQL and other related files in my GitHub repository.
The interactive HTML version of the ERD is posted up here: https://sedeschema.github.io/