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?