In my web application I will have three types of accounts.
- User: for using the web application for free
- Customer: for advertising and getting a Company Logo
- Admin: for editing and deleting stuff
Should all these three be in separate tables or in one with a column named "account_type" where i can mark it as User, Customer or Admin?
What are the pros and cons for both? Is there a best practice for this?
Thanks