Junction Table
noun
say it: “JUNGK-shun TAY-bul” /ˈdʒʌŋkʃən ˈteɪbəl/
A table that links two others in a many-to-many relationship, with a foreign key to each.
What is Junction Table in a relational database?
Junction Table — A table that represents a many-to-many relationship through foreign keys.
CREATE TABLE enrollment (
student_id INTEGER REFERENCES student (student_id),
course_id INTEGER REFERENCES course (course_id),
PRIMARY KEY (student_id, course_id)
);
In a sentence
- “Order Details is the junction table between Orders and Products.”
Level: Journeyman · More Database terms at this level
Updated