troubleshooting Question

What is this type of table called?

Avatar of Stephen Forlance
Stephen Forlance asked on
DatabasesMySQL ServerSQL
8 Comments1 Solution73 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Mark Wills
Topic Advisor
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros