Table relationships overview
Table relationships define the ways that table rows can be associated with rows from other tables or the same table. There are two types of table relationships.
- One-to-many relationships. In a one-to-many table relationship, many referencing (related) table rows can be associated with a single referenced (primary) table row. The referenced table row is sometimes referred to as the ”parent” and rows of the referencing table are referred to as ”children.” A many-to-one relationship is just the child perspective of a one-to-many relationship.
- Many-to-many relationships. In a many-to-many table relationship many table rows can be associated with many other table rows. Rows related using a many-to-many relationship can be considered peers and the relationship is reciprocal.