I’m working on a new project and it will have several different user types. However, each different user type will require different information to be stored about each record in the database.
Do I make individual tables for each user type or store them all in the same table anyway?
It depends on how much data being stored differs based on their user type. I coded a social network that allows the choosing of a “account type” like facebook. So the profiles for the users is totally different based on their account type, so i created a table for each type. profile_bands, profile_personal, profile_business etc.
The purpose is to keep the table as lite as possible and make it easy to setup INDEXes for faster queries.