I want to create one website, It have.
users : They manage every thing like categories, content, members, approve contents etc.members : They create contents, But creator must be en approve by admin first.members : Comment or support content that creator created.Creator and Member can register or login by socialite, But Admin can't.
The question is, Should I split users and members table or use in the same table users with flag?
What is the best way to go?
I'd say one user table, but multiple roles.
Admin is a role. Creator is a role. Member is default user role. Then you could have a roles table that lists the different types of roles (look-up table?), and reference the role_id in the user table per user.
Please or to participate in this conversation.