Avatar of Stephen Forlance
Stephen Forlance asked on

What is this type of table called?

Hi all,
Having a lockdown brain moment, whats the type of table called that defines the relationship between records in two other tables?

For example:

if I have two tables:
projects
users

its a many to main relationship, so I would have a table called project_users, which would be:

id
project_id
user_id

which would define which users belonged to which projects

Also, is there a standard way to denote these types of tables, since they are defining relationships, not actually data?
DatabasesMySQL ServerSQL

Avatar of undefined
Last Comment
Alex [***Alex140181***]

8/22/2022 - Mon
slightwv (䄆 Netminder)

Not sure there is "one" name.  Every DBA/Designer tends to call it what they learned.

https://en.wikipedia.org/wiki/Many-to-many_(data_model)

In a relational database management system, such relationships are usually implemented by means of an associative table (also known as join table, junction table or cross-reference table)
Alex [***Alex140181***]

Chris Stanyon

Juntion Table
Join Table
etc.

Different names for the same thing :)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Jim Dettman (EE MVE)

As it stands, linking, junction, join, etc as has been said.

But if you start to add attributes (fields) that describe something about the relationship itself, then it's no longer a linking table per say.

But don't get hung up on the naming....important thing is to get the design right<g>

Jim.   
ASKER CERTIFIED SOLUTION
Mark Wills

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Brian Crowe

Just a couple of notes on "joining" tables.

I wouldn't bother including an id column, instead using the combined foreign key references as the primary key.  I would also recommend adding a defaulted CreatedDate column; it will come in handy later for trouble-shooting.
arnold

though a relationship table does not need an id column as it conveys no information.
it, this tables row id, will not be used as a reference anywhere else..
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Alex [***Alex140181***]


Me viewing the accepted solution...
Btw, where are those face-palm emojis here?!?