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:

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


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?
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