数据库模式中的多对多关系表是否有正式名称? [英] Is there an official name for the many-to-many relationship table in a database schema?
问题描述
我工作过的大多数项目都需要在数据库模式中有多对多的关系。例如,您可能具有用户和组的概念,并且数据库可能包含表User,表Group和用于关联这两个表的表UserGroup。
我对该示例中UserGroup表的概念名称感兴趣。
我已经习惯于调用他们的swing tables,因为这是我学习它,但我还没有听说其他人在一段时间内使用这个词。
相反,我听说过以下所有(包括一些新的,谢谢所有
li>交叉参考表
这种表格有正式名称, ness?
我认为最常见的名字是Join Table,但我听说过你列出的其他几个。所以,我会说不,没有官方名称: - )
Most of the projects I've worked on have required many-to-many relationships in the database schema. For example, you might have the concept of Users and Groups, and the database might contain a table User, a table Group, and a table UserGroup to relate the two.
I'm interested in the conceptual name of the UserGroup table in that example.
I've grown accustomed to calling them "swing tables" because that's how I learned it, but I haven't heard other people use that term in a while.
Instead, I've heard all of the following (including some new ones, thanks to all of you!):
- Association table
- Bridge table
- Cross-reference table
- Gerund (E.F. Codd, creator of the relational model, may prefer this)
- Intersection tables
- Join table (most search results on Google...see answer below)
- Junction table (Wikipedia favors this one)
- Link table (Fowler likes this one)
- Many-to-many relationship tables
- Map table
- Reference table
- Relationship table
- Swing table
Is there an official name for this kind of table, with a source to back its official-ness?
The most common name is "Join Table" in my opinion, but I have heard several others you have listed. So, I would say "no", there is no "official" name :-)
这篇关于数据库模式中的多对多关系表是否有正式名称?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!