Database—Multiple User Types: Different Data

Question

I'm having a bit of trouble figuring out how to structure my database for an application I'm building.

There will be three different types of users:

Admin
Applicants
Reviewers

I'm planning on having a general users table to store shared information between each user type. However, I'll need to store quite a bit of information for Applicants that I won't for Reviewers, or Admins, and I'll need to store some permissions information for Reviewers that I won't for Applicants.

I know I'll need to set up some additional tables to accommodate this information but I'm not sure how to do so. Should my users table have an admin_data, reviewer_data, applic_data fields as FKs? How would I detect what type of a user a person is when they login?

Each user will only need to be one type.

Thank you for your help.

ethrbunny · Accepted Answer · 2012-12-17 17:34:13Z

2

Have an accounts table with login info, account id and account type. Then join to the appropriate related table (admin, reviewer, etc) to get relevant info.

There's no reason to mix the data since it sounds like it varies quite a bit.

answered Dec 17, 2012 at 17:34

ethrbunny

10.5k9 gold badges77 silver badges145 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database—Multiple User Types: Different Data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related