Is it good database design to have admin users in the same table as front-end users?

Asked 2010-11-12T23:18:24.437

I have users who can login on a front-end page, and admins who can login on an admin page.

Should both users and admins be "Users" with different roles, or should they be split in different tables?

Edit Report

1 Answer

I'd personally keep "Users" in one table. How you decide to represent roles (e.g. as a static bit on the User table itself, or through advanced RBAC rights) depends on how complex your system is. But a user is a user.

answered 2010-11-12T23:22:09.660

Is it good database design to have admin users in the same table as front-end users?

1 Answer

Your Answer