Search code examples
mysqlcakephpmysql-workbenchreverse-engineeringerd

Generate ER Diagram from existing MySQL database, created for CakePHP

For CakePHP application, I created MySQL database.

Which tool to be used to create ER Diagram of database? Fields and relations between tables are created in a way cakePHP likes.

thank you in advance!

Solution

  • 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.