自动生成数据库图表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屋！