You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Our existing system restricts users to single organization affiliations, overlooking the possibility of users ebing members of multiple orgs at the same time. To address this, the proposed solution is to establish a many-to-many join table between users and organizations.
Update: Let's just move the organisation_id from users to students table instead. This would mean that individuals are restricted to one student profile per course per org, but that seems like an acceptable restriction, and it would also mean that org admins can view progress of only the courses that concern them of a particular individual.
The text was updated successfully, but these errors were encountered:
harigopal
changed the title
Implement a Many-to-Many Relationship between Users and Organizations Tables
Move the organisation_id from users to students table
Jan 3, 2024
Our existing system restricts users to single organization affiliations, overlooking the possibility of users ebing members of multiple orgs at the same time. To address this, the proposed solution is to
establish a many-to-many join table between users and organizations.Update: Let's just move the
organisation_id
fromusers
tostudents
table instead. This would mean that individuals are restricted to one student profile per course per org, but that seems like an acceptable restriction, and it would also mean that org admins can view progress of only the courses that concern them of a particular individual.The text was updated successfully, but these errors were encountered: