My structure is basically the following:

// 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.