Relationships in mutating joins

The relationship describes how many rows in x each value of y$key is expected to match (one or many), and vice-versa, giving rise to 4 possible combinations:

• one-to-many
• many-to-one
• one-to-one
• many-to-many

Which relationship applies, follows from the keys being primary or foreign in x and y.