I am creating a website with two different roles. They will have profiles that have completely different information.
Option A: Use the prepackaged “User” table in the database. Add Role field, and then add all of the fields for BOTH profiles.
Option B: Use the prepackaged “User” table to get basic user info, Add Role field, then create a new table for each type of role.
It seems like Option B would be a better way to go, but I don’t want to start down a rabbit hole and have something broken later on down the road. Are there other options?