MySQL 用于mysql的开源ER图表工具
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/285828/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Open source ER diagramming tool for mysql
提问by Zak
I want to reverse engineer (import into diagram form) the database definition dump of a database I have, then since no foreign keys are defined in this particular database, I want to be able to manually create the table to table key mappings (using crow feet notation if possible).
我想对我拥有的数据库的数据库定义转储进行逆向工程（导入到图表形式），然后由于在此特定数据库中没有定义外键，我希望能够手动创建表到表的键映射（使用 crow如果可能，英尺符号）。
I've taken a look at MySQL Workbench, and it gets me 85% of the way there. The nice little relationship lines won't show up though, and the auto arrange is horrible. A quick search of google turns up several other options, so I canevaluate these on my own, but:
我查看了 MySQL Workbench，它让我完成了 85% 的工作。不过，漂亮的小关系线不会出现，而且自动排列很糟糕。快速搜索谷歌会发现其他几个选项，所以我可以自己评估这些，但是：
Can I get some feedback from you guys for which are your favorite tools to use for this scenario? Why do you like that(your) particular tool?
我可以从你们那里得到一些反馈，你最喜欢在这个场景中使用哪些工具？你为什么喜欢那个（你的）特定工具？
My intended purpose is to take a legacy database, and train jr. engineers on the organization of the DB. Visual aids are nifty. My fallback option is to recreate an ER diagram by hand. Not fun for 250+ tables.
我的预期目的是采用遗留数据库，并训练 jr。DB 组织的工程师。视觉辅助工具很漂亮。我的后备选项是手动重新创建 ER 图。250 多张桌子不好玩。
回答by dkretz
You might check out DBDesigner ...
您可以查看 DBDesigner ...
Now known as MySQL Workbench
现在称为 MySQL 工作台
回答by Sualeh Fatehi
SchemaCrawleris a free, open source tool that can generate E-R diagrams, with the help of GraphViz. You can use regular expressions to select the tables and columns you want to display. Relationships are inferred from commonly used naming conventions.
SchemaCrawler是一个免费的开源工具，可以在 GraphViz 的帮助下生成 ER 图。您可以使用正则表达式来选择要显示的表和列。从常用的命名约定中推断出关系。
回答by Tim Howland
I've had some success using two commercial (but relatively cheap!) tools- but I still haven't found any really solid open source ones after months of looking.
我已经使用两种商业（但相对便宜！）工具取得了一些成功 - 但经过几个月的寻找，我仍然没有找到任何真正可靠的开源工具。
- MyEclipseIDEis a subscription product, I think it's around $60 a year. It's a set of bundled plugins for Eclipse, one of them is an ERD analyzer that works OK. If you're programming in Java (or another eclipse-supported language), it may be worth it.
- SQLMaestro for MySQL: This one is a bit more expensive, with a $99 noncommercial / $179 single seat license. The ERD it generates is much better, and it provides other tools that make it easier to administer and maintain a more complex schema.
- MyEclipseIDE是一种订阅产品，我认为每年大约需要 60 美元。它是 Eclipse 的一组捆绑插件，其中一个是运行正常的 ERD 分析器。如果您使用 Java（或其他 eclipse 支持的语言）进行编程，那么这可能是值得的。
- SQLMaestro for MySQL：这个有点贵，非商业版 99 美元/单座许可证 179 美元。它生成的 ERD 要好得多，并且它提供了其他工具，可以更轻松地管理和维护更复杂的模式。
My understanding is that MySQL Workbench is still under active development, but they've been banging on it for a long time without really wrapping it up. Maybe now that Sun owns them, they'll get it together.
我的理解是 MySQL Workbench 仍在积极开发中，但他们已经在很长一段时间内没有真正结束它。也许现在 Sun 拥有它们，他们就会把它整合起来。
回答by Bartek
Check out Vertabelo.
查看Vertabelo。
It's an online database modeler that works under Chrome browser.
这是一个在 Chrome 浏览器下工作的在线数据库建模器。
It provides you with:
它为您提供：
- DB model versioning and validation,
- generating SQL scripts for particular database,
- supports collaboration - allows sharing DB model with other members of your team,
- supports reverse enginnering.
- 数据库模型版本控制和验证，
- 为特定数据库生成 SQL 脚本，
- 支持协作 - 允许与团队的其他成员共享数据库模型，
- 支持逆向工程。
Moreover it's free of charge.
而且它是免费的。
回答by Suresh Kamrushi
Generate ERD with PHPMyAdmin is also a better option. PHPMyadmin added this functionality from version 3.4
使用 PHPMyAdmin 生成 ERD 也是一个更好的选择。PHPMyadmin 从 3.4 版添加了此功能
detail step to generate ERD : http://goo.gl/0z3vFE
生成 ERD 的详细步骤：http: //goo.gl/0z3vFE
You can refer to PHPMyAdmin documentation for more info: http://www.phpmyadmin.net/documentation/#pmadb
您可以参考 PHPMyAdmin 文档了解更多信息：http://www.phpmyadmin.net/documentation/#pmadb
回答by Sairam Krish
I am using Mysql Workbench 6.1. By default the diagram will look crunched for large number of tables, making it difficult to figure out relationship between tables. Many tables will overlay on other tables. This is because, the default layout size is small.
我正在使用 Mysql Workbench 6.1。默认情况下，对于大量表，图表看起来很紧缩，从而难以找出表之间的关系。许多表将覆盖在其他表上。这是因为，默认布局尺寸较小。
In the menu, Go to Model >> "Diagram properties and size".
在菜单中，转到模型>>“图表属性和大小”。
Change width and size to some thing big (for example width 23 and height 5) - 
将宽度和大小更改为一些大的东西（例如宽度 23 和高度 5）-
Then in the menu, Go to Arrange >> Autolayout.
然后在菜单中，转到排列 >> 自动布局。
Now we should see a clean diagram with all the relations. Now we can re-adjust width and height, more meaningfully
现在我们应该看到一个包含所有关系的干净图表。现在我们可以重新调整宽度和高度，更有意义
