A modern programming language that makes developers happier.

kotlinlang

Hey, there's an issue on this already but no response (and nothing on the roadmap) about the ability to have a many-to-many reference setup where the junction table needs an additional attribute, I cannot find anyone else that has tried and succeeded. I'm not quite dangerous enough with Kotlin (yet?) to implement such a feature myself so I was hoping to get some guidance on some options. :thread:

My structure is basically the following:

```// Person
- id
- fullName
- ...

// Play
- id
- type

// PersonPlayJunction
- person_id
- play_id
- type &lt;--- 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.