Austin Paquette07/17/2021, 2:44 PM
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
// Person - id - fullName - ... // Play - id - type // PersonPlayJunction - person_id - play_id - type <--- I cannot access this
could be – for example – either
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.