Edit Question - KnowledgeHub

Title Body

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?

Tags (comma-separated) Cancel