Categories
Database Development

What are the pros/cons of between these 2 database design options where the through table can have 2 or 3 foreign keys?

I am trying to model the following scenario, but I have come up with 2 options and I cannot figure out how to decide between the 2 options. Both options seem to work, but I worry that I am missing some edge case that suggests one over the other. Any recommendations or suggestions on where […]