Many to many relation
Hi, I have two tables 'Users' and 'Skills'. According to my system there is a many to many relation between the these table and this can be achieved using a bridge table.
I want to save every user's skill's rating and this can be done by saving the rating attribute in bridge table, where the a rating is along every user's skill because a user can have many skills and skill has its own rating.
So far i have created the relation between the tables and it is working fine but there is problem. The problem is i don't know where to put the rating attribute to save every user's skill's rating. Kindly help.
i have attached a picture that shows the relationship.