@H_403_1@说你在艺术家和粉丝之间有许多表.在设计桌面时,您是否设计桌面:
ArtistFans ArtistFanID (PK) ArtistID (FK) UserID (FK) (ArtistID and UserID will then be contrained with a Unique Constraint to prevent duplicate data)
或者您是否为两个相关字段构建复合PK:
ArtistFans ArtistID (PK) UserID (PK) (The need for the separate unique constraint is removed because of the compound PK)
使用以前的架构有什么优势(可能是索引?)?