数据库关系建模-sqlite
我有一个数据库，其中有几个存储在 sqlite 中的表。 我正在寻找一个产品或一段代码，可以将其转换为我的关系图 - 它不必是特定的模型，例如 UML 等。只要任何有效的东西 - 有谁知道可用的产品可以直接插入 sqlite 数据库并为我填充图表上的表和字段吗？
谢谢
I have a database with several tables in it stored in sqlite.
I'm looking for a product or piece of code that will turn this into a relationship diagram for me - it doesn't have to be a specific model, such as UML etc. Just anything that works - Does anyone know of an available product that can plug directly into the sqlite database and populate the tables and fields on a graph for me?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以尝试在线建模工具SQLauncher。它使用简单，并允许离线模式。 sqllauncher 还允许创建每个模型实体的 ASCII 视图。
You can try on line modeling tool SQLauncher. It is simple to use and allows off line mode. Also sqlauncher allows to create ASCII view of each model entity.
Navicat for SQLite 可以做到这一点（企业版是唯一支持此功能的版本，通过 http://www.navicat.com/en/products/navicat_sqlite/sqlite_feature.html ）
它有一个模型工具，但为了使用它，我花了一点时间来理解UI：
连接到您的数据库。
双击连接。右键单击 main（通常是数据库），然后从菜单中单击“Reverse Database to Model...”。
直接打开模型工具并尝试这样做似乎是不可能的。
我不为他们工作。我在某个时候打折时以 25 美元左右的价格买了它。
Navicat for SQLite can do this ( the Enterprise version is the only version that supports this, via http://www.navicat.com/en/products/navicat_sqlite/sqlite_feature.html )
It has a model tool but in order to use it, it took me a little bit to understand the UI:
Make the connection to your database.
Double click on the connection. Right click on main(usually that is the database), and click "Reverse Database to Model..." from the menu.
Opening the Model tool directly and trying to do this seems to be impossible.
I don't work for them.. I bought it on sale at some point for around $25.