Kind of a normal design problem I'm running into with my database...
For this project, I have a table of users who have access to the site. However, each user is broken down with an access level, a 'client','staff', or 'admin'...
Right now, I have one table with a field for that persons access level. However, things are slightly changing and there are some pieces of data that I might need for 'client's that I wouldn't have for staff or admin...
Should I be starting up a new table and separating out the different access levels? Is there a better to do this that I'm not thinking of? I'm pretty sure theres an accepted practice since this seems to be a pretty fundamental issue.
For this project, I have a table of users who have access to the site. However, each user is broken down with an access level, a 'client','staff', or 'admin'...
Right now, I have one table with a field for that persons access level. However, things are slightly changing and there are some pieces of data that I might need for 'client's that I wouldn't have for staff or admin...
Should I be starting up a new table and separating out the different access levels? Is there a better to do this that I'm not thinking of? I'm pretty sure theres an accepted practice since this seems to be a pretty fundamental issue.