...
Multiple organization membership
Initially we modeled this as an object relationship in the database. I’m struggling to figure out why this can’t just be modeled in the permissions table. The value of organizations is also decreased since it’s just a construct to limit who you can see working in an app (which we must to support studies as isolated tenants in a single app). However if we need to, we can introduce a Membership associative table between Accounts and OrganizationsIntroduce a Membership associative table between Accounts and Organizations, and migrate the existing orgMembership value to this table. The table should be a simple associative table as roles are managed separately. But when we need to retrieve the list of members, or the organizations a person belongs to, it’s the object model we will examine.