Austin Paquette
07/17/2021, 2:44 PM// Person
- id
- fullName
- ...
// Play
- id
- type
// PersonPlayJunction
- person_id
- play_id
- type <--- I cannot access this
The person could be anyone involved in any play, say a goal is scored. That play would have the shooter, and the defender cataloged.
The relationship works as expected (and documented) BUT the nature of their involvement is where I cannot find a graceful solution that makes sense.
The PersonPlayJunction.type
could be – for example – either shooter
or defender
in this case, I fully realize that I could make additional queries for this but I'm asking here first before I start jumping at solutions like that.