从现有数据库创建EER模型，但关系已完成-Workbench [英] Create EER Model from an existing DB but with the relations done - Workbench

问题描述

我正在尝试将现有数据库导入mysqlq Workbench.我可以做这个.完美的作品.但是，该过程只是导入表而没有它们之间的关系.

I'm trying to import an existing DB to mysqlq Workbench. I can do this. It's works perfectly. However the process just import the tables without relations between them.

如何导入db并创建具有它们之间关系的eer模型?

How can I import the the db and create the eer model with relations between them?

推荐答案

关系是外键的直观表达.如果您的数据库表使用外键(实际上:支持外键的存储引擎)，则它们将自动显示在图中.应该清楚的是，这种情况仅适用于InnoDB存储引擎.

Relationships are the visual expression of foreign keys. If your DB tables use foreign keys (actually: a storage engine supporting foreign keys) then they are automatically shown in the diagram. It should be clear that this condition is only true for the InnoDB storage engine.

这篇关于从现有数据库创建EER模型，但关系已完成-Workbench的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！