java中 两个表之间有2个外键约束_SQL Server：两个指向一个表的外键 . 错误：引入FOREIGN KEY约束可能会导致循环或多个级联路径...

我不确定一个可以解决你在那里的问题的答案，我不确定你的设计是如何一成不变的......但作为一种我不认为会有同样问题的替代设计你有没有被认为是一个单独的中间关系表

这种方法的一个好处是它允许您在每个位置拥有多个成员 .

CREATE TABLE [Members]

(

[MemberId] int NOT NULL IDENTITY

)

CREATE TABLE [Studios]

(

[StudioId] int NOT NULL IDENTITY,

CONSTRAINT [PK_Studios] PRIMARY KEY ([StudioId]),

)

--Contains Owner, Head, etc.

CREATE TABLE [Relationships]

(

[RelationshipId] int NOT NULL IDENTITY,

[RelationshipId] nvarchar(20) NOT NULL

)

CREATE TABLE [StudioMemberRelationships]

(

[StudioMemberRelationshipId] int NOT NULL IDENTITY,

[StudioId] int NOT NULL,

[MemberId] int NOT NULL,

[RelationshipTypeId] int NOT NULL,

CONSTRAINT [FK_StudioMemberRelationships_StudioId]

FOREIGN KEY ([StudioId]) REFERENCES [Studios] ([StudioId])

ON DELETE SET NULL,

CONSTRAINT [FK_StudioMemberRelationships_MemberId]

FOREIGN KEY ([MemberId]) REFERENCES [Members] ([MemberId])

ON DELETE SET NULL,

CONSTRAINT [FK_StudioMemberRelationships_RelationshipId]

FOREIGN KEY ([RelationshipId]) REFERENCES [Relationships] ([RelationshipId])

ON DELETE SET NULL

)