What is a Bridging Table and synonyms for the term

 What is a Bridging Table and synonyms for the term

In databasemanagement systems following the relationalmodel,  a Bridging Table is a junction table is a SQL database table that contains common fields from two or more other database tables within the same database. It is on the many side of a one-to-many relationship with each of the other SQL tables.

Junction tables are known under many names:

·         cross-reference table

·         bridge table

·         join table

·         map table

·         intersection table

·         linking table

·         many-to-many resolver

·         link table

·         pairing table

·         transition table

·         crosswalk

·         associative entity

·         or association table.


Learn SQL  with us at PCWorkshops!


 

Comments

Popular posts from this blog

Delete vs Truncate in MySQL and MS SQL Server

What Is SQLite?

SQL Project Ideas