+ 3

Need ideas

I have a user table and an organization table in mysql. User can belong to multiple organizations. What is the best way to save the relationship between the user and the organizations? I've thought of saving the row ids using the text field in both organization and the user table. For example Users: id: 1 username: Toni email: h@hotmail.com password: xxxxx organizations: "1, 2, 3, 4" organizations: id: 1 name: sololearn bio: asd users: "1, 2, 3, 4" Do anyone have a better idea?

14th Oct 2021, 6:40 PM
Toni Isotalo
Toni Isotalo - avatar
2 ответов
+ 3
You probably need a connector table with `user_id` and `organization_id` columns. Each these column should reference the respective `id` column in table 'users' and 'organizations' user_id | organization_id 1 1 1 2 1 3 1 4 This may seem like a waste, but I guess it might help to enforce data integrity.
14th Oct 2021, 11:19 PM
Ipang
+ 2
What about assigning different organization specific permissions to each user?
14th Oct 2021, 6:44 PM
Toni Isotalo
Toni Isotalo - avatar