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

What are the synonyms of Junction table ?

Junction tables are known under many names, including : 

• Mapping table
• Bridge table
• Linking table / Link table
• Cross-reference table
• Join table
• Pairing table
• Intersection table / entity
• Many-to-many resolver
• Transition table
• Crosswalk
• Associative table / entity

See also : What is junction table ?

What is Mapping or Cross-reference or Bridge or Join or Link table ?

Junction tables are known under many names, including : 

• Mapping table
• Bridge table
• Linking table / Link table
• Cross-reference table
• Join table
• Pairing table
• Intersection table / entity
• Many-to-many resolver
• Transition table
• Crosswalk
• Associative table / entity

See also : What is junction table ?

What is Many-to-many resolver ?

Junction tables are known under many names, including : 

• Mapping table
• Bridge table
• Linking table / Link table
• Cross-reference table
• Join table
• Pairing table
• Intersection table / entity
• Many-to-many resolver
• Transition table
• Crosswalk
• Associative table / entity

See also : What is junction table ?

What is Pairing or Transition or Crosswalk or Associative table ?

Junction tables are known under many names, including : 

• Mapping table
• Bridge table
• Linking table / Link table
• Cross-reference table
• Join table
• Pairing table
• Intersection table / entity
• Many-to-many resolver
• Transition table
• Crosswalk
• Associative table / entity

See also : What is junction table ?

How to describes a Junction table ?

What would best describe the ORDER_PRODUCT table ?
 

• ORDER_PRODUCT table is Junction table.
• It allows a many-to-many relationship between PURCHASE_ORDER and PRODUCT.
• The table may contain multiple different "order_id" for a given "product_id"