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