So I have 3 models -
Users, Roles, Records.
For each record X user, can have 1 of 3 roles, and those roles will
give different permissions on each record.
So for example, user 1 - has a role of follower on record 5, also user
1 - is a manager(role) of record 4, etc.
So what I am trying to do, is figure out how to create that
situation.
Would something like this work?
User
has_and_belongs_to roles
has_many records through => role_record
user_status -- table
user_id
status_id
roles
has_and_Belongs_to Users
has_and_belongs_to records
role_record -- table
role_id
record_id
(user_id)
records
has_and_belongs_to roles
The final goal is I want to call - user(1).role(1) - and have it spit
out all the associated records that I have.
I have n amount of users and records, but currently only 3 roles.
Thanks for the help!