From many to one to many to many with data on the join table


I am transitioning a many to one relation to a many to many. We have a users and a teams schema at the moment. And we want to allow users to join multiple teams, instead of the currently allowed one.

I am thinking to add a users_teams table that could hold the ids of the respective tables and some additional info like role, status, default(marks default team of user).

Now this will require me to do I know I could do a :join_through to have user.teams but with this I would miss the other info.

What would be cool is if when I load this relation in, I could have the role, status, etc info on the team level.

Is there a way to achieve that?

Thank you

1 Like