sql – normalize user table with it groups but both can login

Hi currently i have 3 tables:

users
|id|name|email|password|last_login|created_at|

user_groups
|user_id|group_id

groups
|group_id|name|email|password|last_login|created_at|

Group can login so it when i can view statistics for specific all it users, that’s why i put email and password too.

the problem is users and groups got almost everything same. 1 group can contain many users.
Is there anyway to make this more normalize and user still have their specific groups?


Source: mysql

Leave a Reply