1 单击Mysql schema 到图表转换?
我有太多的表和 FK 关系,很难跟踪和可视化它们。跨多个 Excel 文档。我已经将其输入到 mysql 中,但我想输出一个将表与所有 FK 链接在一起的数据模型图。
除了必须手动执行之外,如何执行?我对第三部分工具持开放态度,只要它们是免费的。
I have so many tables and FK relationships it is hard to keep track and visualze it all. Speard across multiple excel documents. I have it already entered in mysql but I want to output a data model diagram that links tables together along with all the FKs.
How to do it apart from manually having to do it? I am open to 3rd part tools as long as they are free.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
好吧,我在本地服务器上使用 phpMyAdmin。
phpMyAdmin 3 具有此设计器功能,可向您显示各种表及其列之间的链接。
Well I am using phpMyAdmin on my local server.
phpMyAdmin 3 has this Designer feature that shows you the linkages between various tables and its columns.
查看 MySQL 工作台。
它是一个免费工具,并提供一些不错的功能,例如前向和后向工程以及数据库同步。我有一些错误,但它是迄今为止我所知道的最好的 MySQL 工具。
Take a look at the MySQL Workbench.
It's a free tool and offers a few nice features like forward and backward engineering and database synchronisation. I has a few bugs, but its the best tool for MySQL I know so far.