Do you have a general Contact Detail table?
It is common to have a Contact Detail table to store your contact information such as phone numbers. Below is an example of a Contact Detail table and its related tables. This is bad because the PartyPhone table is too specific for a phone number and you have to add a new table to save an email or other contact information if this is needed in the future.
❌ Figure: Bad Example - A too specific Contact Detail table
We normally have a general Contact Detail table that includes all the different categories of phone numbers, whether it is shared or primary plus emails all in the same table.
✅ Figure: Good Example - A general Contact Detail table
We use a Contact Detail Category table to store these categories.
✅ Figure: Good Example - Details of Contact Detail Category table