I am trying to generate the E-R Diagram of WordPress using the 'Reverse Engineer' feature. There is a slight obstacle though.
The diagram does not show the relationships between the entities. Is this the way it's supposed to work or am I missing something?
MySQL Workbench – How to Generate E-R Diagram of WordPress
database-diagramsmysql-workbench
Related Question
- MySQL Workbench – Representing Superclass/Subclass Relationships in Diagrams
- Sql-server – Generate database diagram from SQL Server with no proper integrity
- MySQL Workbench – Change Color of Relationship Lines in Diagrams
- MySQL Workbench – Relationships Between Tables Not Shown in Reverse Engineering (Mac OS)
- Mysql – Incorrect relationships formed in EER diagram by reverse engineering the database script
Best Answer
The EER diagram is correct. There should be no relationships because WordPress does not have any constraints. The EER diagram shown in the codex is only for reference (it's a dummy EER diagram). You must rely on other logical operations to make sure you have no orphaned data.
Source: https://codex.wordpress.org/Database_Description