Concept · Technical basics

Join table

Also called: join tables, junction table, linking table, many-to-many table

A database table whose only job is to connect two other tables when items on each side can link to many on the other.

For example: Students can take many classes and classes have many students, so an enrollments join table records each student-class pair.

Connects to 3

Page last changed · Suggest a correction