blocks|key|860812|text|试试MySQL+Workbench。它包含了非常好的数据建模工具。查看他们的EER图的screenshots+(增强的实体关系，这是ER图的一个升级)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|860813|这不是特定于CakePHP的，但是您可以修改选项，使外键和连接表遵循CakePHP使用的约定。一旦您将规则设置到位，这将简化您的数据建模过程。|860814|entityMap|0|LINK|mutability|MUTABLE|url|http://wb.mysql.com/|1|http://wb.mysql.com/?page_id=35^0|2|F|0|17|B|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Try <a href="http://wb.mysql.com/" rel="noreferrer">MySQL Workbench</a>. It packs in very nice data modeling tools. Check out their <a href="http://wb.mysql.com/?page_id=35" rel="noreferrer">screenshots</a> 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.

blocks|key|860846|text|如果您不想安装MySQL工作台，并且正在寻找在线工具，这可能会有所帮助：http://ondras.zarovi.cz/sql/demo/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|860847|我经常使用它为我构建的各种应用程序创建简单的DB模式。|860848|entityMap|0|LINK|mutability|MUTABLE|url|http://ondras.zarovi.cz/sql/demo/^0|10|X|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

If you don't want to install MySQL workbench, and are looking for an online tool, this might help: <a href="http://ondras.zarovi.cz/sql/demo/" rel="noreferrer">http://ondras.zarovi.cz/sql/demo/</a>

I use it quite often to create simple DB schemas for various apps I build.

blocks|key|860877|text|CakePHP的目的是作为Ruby+on+Rails框架的克隆，在PHP中完成，所以对底层数据库的任何反向工程都是没有意义的。应该从模型层对EER图进行逆向工程。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|860878|Ruby确实存在这样的工具，你可以在这里看到Redmine数据库EER图是从模型逆向工程出来的。不是来自数据库。http://redminecookbook.com/Redmine-erd-diagrams.html|offset|length|860879|使用以下工具：http://rails-erd.rubyforge.org/+http://railroady.prestonlee.com/|860880|entityMap|0|LINK|mutability|MUTABLE|url|http://redminecookbook.com/Redmine-erd-diagrams.html|1|http://rails-erd.rubyforge.org/|2|http://railroady.prestonlee.com/^0|0|1K|1G|0|0|7|V|1|13|W|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@$D|Z|E|10|1|11]|$D|12|E|13|1|14]]|A|$]]|$1|H|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]|R|$5|K|L|M|A|$N|S]]]]

CakePHP was intended to be used as Ruby on Rails framework clone, done in PHP, so any reverse-engineering of underlying database is pointless. EER diagrams should be reverse-engineered from Model layer.

Such tools do exist for Ruby
Here you can see Redmine database EER diagrams reverse-engineered from Models. Not from database.
<a href="http://redminecookbook.com/Redmine-erd-diagrams.html" rel="nofollow">http://redminecookbook.com/Redmine-erd-diagrams.html</a>

With following tools:
<a href="http://rails-erd.rubyforge.org/" rel="nofollow">http://rails-erd.rubyforge.org/</a>
<a href="http://railroady.prestonlee.com/" rel="nofollow">http://railroady.prestonlee.com/</a>

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!

Generate ER Diagram from existing MySQL database, created for CakePHP

数据建模

SQL数据库

数据库

MySQL

对于CakePHP应用，我创建了MySQL数据库。使用哪个工具来创建数据库的ER图？表之间的字段和关系是以cakePHP喜欢的方式创建的。提前谢谢你！

问从为CakePHP创建的现有MySQL数据库生成ER图
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从为CakePHP创建的现有MySQL数据库生成ER图EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从为CakePHP创建的现有MySQL数据库生成ER图
EN