阅读背景:

SQL中带子表的连接表

来源:互联网 

I have two sql tables Players and Teams joined by a PlayerTeam junction table. A player can be on a team for various years. What's the best way to handle this relationship? I started with a PlayerTeamYear table, but the foreign key reference to both columns in PlayerTeam seems unwieldy, especially as I want to convert this to Entity Framework. This has got to be a common scenario.I have two sql tables Players and Teams joined




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: