What is a Junction table ?

Junction table is a database table that contains common fields from two or more other database tables within the same database. It is the standard way of creating a many-to-many relationship between tables. A junction table maps two or more tables together by referencing the primary keys of each data table. Junction tables are known under many names, including : Mapping table Cross-reference table Bridge table Join table Intersection table / entity Linking table / Link table Many-to-many resolver Pairing table Transition table Crosswalk Associative table / entity