Very simple question, hopefully I won't overcomplicate it:
There's many to many relationship between users and accounts and there's a field called "commissions".
When John is assigned to account (A) his commission is 5% when John is assigned to account (B) his commission is 14% and when Bill is also assigned to account (B) his commission is 10%.
So where would this "commission" info be stored?
It can't be in "users" or "accounts" module, so would I make a column in the relationship table that links the 2? Or is there another way of doing this?
Hope this makes sense