Join Table

Definitions

1. An associative table used to represent a many-to-many relationship between two other tables, typically by storing one foreign key to each side. Join tables may also carry extra attributes about the relationship itself, such as role, ordering, or timestamps.

   In plain English: It is a linking table that records which items from one table are connected to items in another.

   Example: "Users and teams need a join table because membership is many-to-many and we also track who invited whom."

Related Terms

• stored procedure
• trigger
• Active Record
• Ecto
• Eloquent
• Entity Framework
• N+1 Query Problem
• Master-Slave