liveBook · Manning

Join table

Also called association table, junction table

A join table is a relational database table whose rows store key-based associations between records in two other tables, commonly representing a many-to-many relationship.

How 5 Manning books explain it

Grokking Relational Database Design

A junction table is a relational table that represents a many-to-many relationship by storing references to the participating entities.

How it is used
Represents many-to-many relationships by placing a junction table between two entity tables.
How deep it goes
Works through cardinalities, foreign-key placement, and composite primary keys; it does not show SQL table creation.
Examples
Uses author_book for authors and books, purchase_product for purchases and products, and customer_dealer for customers and dealers.
What you can do after
Build it from scratch by converting a many-to-many relationship into two one-to-many relationships with a composite key.

Read how Grokking Relational Database Design explains join table →

Java Persistence with Spring Data and Hibernate epub

A join table is a relational table that stores key-based links between rows of associated entity tables, commonly for a many-to-many association.

How it is used
Uses join tables to represent many-to-many links and optional entity associations without nullable foreign keys in entity tables.
How deep it goes
Works through key constraints, JPA mappings, association ownership, cascading, and ternary map tradeoffs.
Examples
Uses billing details, auction shipments, item buyers, categorized items, and a map recording who added each item.
What you can do after
Apply join tables via JPA annotations for optional and many-to-many associations, choosing constraints and an owning side.

Read how Java Persistence with Spring Data and Hibernate epub explains join table →

Building Web APIs with ASP.NET Core

A junction table is a database table that associates rows from two other tables to represent a many-to-many relationship.

How it is used
Represents many-to-many relationships in a table-oriented SQL schema.
How deep it goes
Defines the schema role and retrieval cost, but does not provide join-table SQL or CRUD implementation.
Examples
Uses BoardGames_Domains and BoardGames_Mechanics in a board-game database schema.
What you can do after
Evaluate relational and document-oriented schema choices involving many-to-many data.

Read how Building Web APIs with ASP.NET Core explains join table →

The Well-Grounded Python Developer: How the pros use Python and Flask

An association table is a relational table that records associations between entities from two other tables, typically through foreign keys.

How it is used
Models many-to-many relationships such as orders with products or users with followed posts.
How deep it goes
Explains foreign-key structure and ORM navigation, then stops short of broader schema constraints or indexing.
Examples
Uses Order-Product items and User-Post following records as concrete association-table examples.
What you can do after
Apply it via SQLAlchemy to connect two models and navigate their associated objects.

Read how The Well-Grounded Python Developer: How the pros use Python and Flask explains join table →

.NET in Action, Second Edition

A join table is an intermediary database table that stores associations between entities in a many-to-many relationship.

How it is used
Maps many-to-many associations between entities in an EF Core relational schema.
How deep it goes
Explains automatic table creation, the compound primary key, and foreign keys.
Examples
Uses Books and Tags as the entities in a many-to-many relationship.
What you can do after
Understand how EF Core represents a many-to-many association in the database.

Read how .NET in Action, Second Edition explains join table →

Also covered in

What to know first

Related concepts

Questions about join table

What is join table?

A join table is a relational database table whose rows store key-based associations between records in two other tables, commonly representing a many-to-many relationship.

Which Manning books explain join table?

Grokking Relational Database Design, Java Persistence with Spring Data and Hibernate epub, Building Web APIs with ASP.NET Core, The Well-Grounded Python Developer: How the pros use Python and Flask and .NET in Action, Second Edition.

What should I know before learning join table?

Manning books that teach join table usually introduce foreign key, user, many-to-many relationship and one-to-many relationship first.

What is join table a kind of?

Join table is a kind of dependent entity. A dependent entity is an entity whose identification or existence depends on a related owner entity and cannot be fully determined independently.

What is join table also called?

Join table is also called association table or junction table.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.