这是一个缺陷吗？ [英] is this a flaw?

问题描述

在Visio中，我只能更改关系的一侧。

In Visio I can only alter one side of the relationship.

如果我想要 1-M关系，则必须选择标识，但是这会自动使FK变成PK，对我来说似乎不正确。

If I want a "1-M" relationship, I have to choose "Identifying", but this automatically makes the FK becomes PK, which doesn't seem right to me.

有相同问题的人说这是一个缺陷，因此在visio中无法解决？

Someone with the same problem said it was a flaw, so there is no way around it in visio?

推荐答案

确保在子表的列列表中选中 Required作为外键列。如果这样做，您应该看到关系描述为：-II--O<-，我想这就是您想要的。

Make sure "Required" is checked for the foreign key column(s) in the column list in the child table. If you do that you should see the relationship depicted as: -II--O<-, which I guess is what you want.

这篇关于这是一个缺陷吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！