I’m working on a site that has two distinct types of users (user A), and (user B), ie. Chefs and Fans of Chefs. They each have their own profiles, and will have different functionality on the site. But both can refer each other, both can follow each other, both can comment on each others posts. Should I create a single USERS table and then have child tables to provide the attributes, or just have all the fields on the users table and a “type” field to differentiated between the two.
Thanks for any comments or suggestions.