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?