生成带有连接的mysql erd [英] Generate mysql erd with connections

问题描述

我需要从mysql数据库转储生成er图.我尝试了很多工具，例如MySQL WorkBench，它们仅生成表，但不生成它们之间的连接.我需要类似 http://www.cacti.net/downloads/docs/sql/database_schema.pdf (最后一页).哪个软件可以做到?谢谢.

I need to generate er diagram from dump of mysql database. I tryed a lot of tools like MySQL WorkBench and they generate only tables, but not connections between them. I need something like this http://www.cacti.net/downloads/docs/sql/database_schema.pdf (last page). Which software could make it? Thanks.

推荐答案

适用于MySQL的SchemaCrawler 是免费的生成图表的工具. SchemaCrawler可以基于常用的命名约定来推断表之间的关系，并用虚线显示它们之间的关系.这是一个示例图:

SchemaCrawler for MySQL is a free tool that generates diagrams. SchemaCrawler can infer relationships between tables, based on commonly used naming conventions, and display these with dotted lines. Here is an example diagram:

Sualeh Fatehi， SchemaCrawler

Sualeh Fate SchemaCrawler

这篇关于生成带有连接的mysql erd的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！