Append data in many-to-many relationship
I have two tables:
Team members can have varying privileges in their teams. They can have no privileges (received an invite), read-only (invited as a user) and read-write-delete (team manager).
I can solve this by having three different join tables:
I'd like to be able to define their role directly in the join table, and be able to use this when writing RLS policies. Is this possible? - and if so, how do I go about it?
Thanks (:
teamsmembersIDteam_idmember_idTeam members can have varying privileges in their teams. They can have no privileges (received an invite), read-only (invited as a user) and read-write-delete (team manager).
I can solve this by having three different join tables:
project_invitesproject_membersproject_adminsI'd like to be able to define their role directly in the join table, and be able to use this when writing RLS policies. Is this possible? - and if so, how do I go about it?
Thanks (:
