I think this has been discussed before, but I can’t find it.
I will have various types of people to track. Some of those people are not users of the system. Among users, there aren’t just regular and special, but complete different categories of people who will use the system in very different ways and have completely different sets of fields.
Question: Should I save all people as Users? Should I save all users as users?
The idea of a user type is new to me, relative to my work with other database apps. In my mind, everything is cleaner if each type is unique and has a descriptive name. (E.g. Doctors and Patients. They both are logged-in users, but they do very different things and have very different fields.) I’d prefer not to use the Users type at all, or just to use it for admin. However, I just read some of the documentation, and it seems there are certain behaviours associated with the user type uniquely, having to do with signup/login and tracking.
Can anybody comment on this? Should I just make all users into Users, and use a field to designate their type? If I do that, which is faster/more efficient: putting every User field in the User type, although many will be unused for each user? Or should I have minimal fields there (name, email, etc.) and then have related tables (types) for each of doctors and patients to store their unique fields?
Many thanks