Junction (Bridge) Tables
Learn Junction (Bridge) Tables (Relationships & Database Design, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A junction table (bridge, link or associative table) resolves a many-to-many relationship. It holds one row per pair, with a foreign key to each side, usually a composite primary key made of both, and optionally extra columns that describe the pair itself.