Partnertabelle
Partnertabelle is a term used in database design to describe a table that models a many-to-many relationship between two other tables. In practice it is often called a junction or association table. The Partnertabelle stores pairs of related entities and may include additional attributes that describe the nature of the relationship.
Typically a Partnertabelle contains two foreign keys, each pointing to one of the related tables. For example,
A core purpose of the Partnertabelle is data normalization: it eliminates repetition by storing only the association
Common use cases include customer–project associations, supplier–product relationships, student–course enrollments, and many other scenarios where two