如何显示 Visio 数据库图表中视图之间的关系？
我正在为我们的主 Web 应用程序的数据访问层使用一组视图，并且需要记录这些视图。 从逻辑上讲，视图镜像基础表，这意味着它们与表具有相似的关系。 （这有点复杂，因为视图从 3 个数据库中提取数据...）
所以我打开 Visio 并将有问题的视图逆向工程到图表中，但现在的问题是 Visio 不允许我添加关系意见。
有没有办法绕过这个限制，以便我可以对这些视图进行建模，就好像它们实际上是表一样？
或者是否有一种简单的方法可以将每个视图“转换”为表格？ （我可以手动完成，但是对于所有属性来说，输入大量无聊的内容......）
I'm using a set of views for the data access layer of our primary web application, and need to document these views. Logically the views mirror the underlying tables, meaning they have similar relationships to the tables. (It's a bit more complex, since the views are pulling data from 3 databases...)
So I opened up Visio and reverse engineered the views in question into the diagram, but the problem now is that Visio won't let me add relationships to views.
Is there any way around that limitation so that I can model these views as if they were actually tables?
Or is there an easy way to "convert" each view to a table? (I could do it manually, but that's a lot of boring typing for all the properties...)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
你在这方面成功了吗？ 我需要根据相关视图来记录数据层，但除了与关系相关的问题之外，还有另一个问题：刷新模型时，图纸中的表格会很好地更新，但所有已处理的视图都会从图纸中消失。 模型已更新，即如果我将视图拖回到画布上，内容就会更新。 但我仍然不想在每次对数据库进行小更新时重建整个图片......
Have you succeeded in this? I need to document data layer based on related views, but in addition to the problem related to relations there is another one: when model is refreshed the tables in the drawings update nicely but all chenged views disappear from the drawing. The model is updated, i.e. if I drag the views back on canvas the content is updated. But still I don't want to rebuild the whole picture every time a small update is done on the DB...