Home
Do you have a general Contact Detail table?
  v3.0 Posted at 9/01/2020 9:50 AM by Tiago Araujo

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.​

ContactDetailTable_bad.png
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.

ContactDetailTable_good.png
Figure: Good Example - A general Contact Detail table

We use a Contact Detail Category table to store these categories.

ContactDetailCategoryTable.png
Figure: Good Example - Details of Contact Detail Category table

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: