自动生成数据库图表MySQL [英] Auto Generate Database Diagram MySQL
问题描述
我厌倦了在每个项目开始时打开Dia并创建一个数据库图表。有没有一个工具,让我选择特定的表,然后基于MySQL数据库为我创建一个数据库图表?最好这将使我编辑之后,因为没有外键的设定图...
I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific tables and then create a database diagram for me based on a MySQL database? Preferably it would allow me to edit the diagram afterward since none of the foreign keys are set...
下面就是我想象图,明智的(请原谅可怕让我们专注于图的概念,而不是它在这个例子中代表的实际数据;)):
Here is what I am picturing diagram-wise (please excuse the horrible data design, I didn't design it. Let's focus on the diagram concept and not on the actual data it represents for this example ;) ):
的看原图图
推荐答案
尝试MySQL的工作台,原名DBDesigner 4:
Try MySQL Workbench, formerly DBDesigner 4:
http://dev.mysql.com/workbench/
我记得有一个逆向工程师数据库模式:
This has a "Reverse Engineer Database" mode as far as I remember:
这篇关于自动生成数据库图表MySQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!