Anyone have an idea on how to solve this issue.
Im modeling my membership and user profile DB and run into one issue I have to solve. I have this layout of tables.
- Membership (where all basic info is stored, like password etc.)
- UserProfile (where all extra info is stored, like name etc.)
In my application I will have two user groups (Parent/Kid), and both of them have the need of registering different types of profile data. Some are the same, but some is different.
How should I solve this? Should I just add all fields to the UserProfile table, and settle with the fact that some fields will be redundant.
Or should I create a new table for each user group and link them to the UserProfile?