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.
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
- foreign keyA foreign key is a column or set of columns whose values reference a key in the same or another relational table, linking records and supporting referential integrity.
- userA user is a person or other principal that interacts with a system or is represented by it.
- many-to-many relationshipA many-to-many relationship is an association in which multiple instances of each participating entity can relate to multiple instances of the other.
- one-to-many relationshipA one-to-many relationship associates one instance of an entity with multiple instances of another entity, each of which is associated with at most one instance of the first.
Related concepts
- many-to-many relationshipimplements · A many-to-many relationship is an association in which multiple instances of each participating entity can relate to multiple instances of the other.
- Entity Framework Coreproduced by · Entity Framework Core is a cross-platform object-relational mapper for .NET that enables applications to work with databases through .NET objects and queries.
- dependent entitykind of · A dependent entity is an entity whose identification or existence depends on a related owner entity and cannot be fully determined independently.
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.




