Generate ER Diagram from existing MySQL database, created for CakePHP
For the CakePHP application, I created the MySQL database.
Which tool to be used to create an ER Diagram of a database? Fields and relations between tables are made in a way CakePHP likes.
Thank you in advance!
Deepak Maurya
Try MySQL Workbench. It packs in very nice data modeling tools. Check out their screenshots for EER diagrams (Enhanced Entity Relationships, which are a notch up ER diagrams).
This isn’t CakePHP specific, but you can modify the options so that the foreign keys and join tables follow the conventions that CakePHP uses. This would simplify your data modeling process once you’ve put the rules in place.