Table: Interaction_Phone_Number
Links a Phone Call or Phone Message type Interaction to zero or one phone number. Even if other phone numbers change this phone number remains unchanged for historical information.
Columns
NameTypeConstraintsDescription
interaction_KEYintNOT NULLA reference to one of the Interaction rows.
contact_phone_type_KEYintNOT NULLKey to a Contact Phone Type record.
phone_numbernvarchar (30)NOT NULLPhone number.
extensionnvarchar (5)NOT NULLExtension.
Primary key
NameColumnsDescription
PK_Interaction_Phone_Number$interaction_KEYinteraction_KEYCLUSTERED
Only one phone number can be saved per Interaction.
Indexes
NameColumnsDescription
IX_Interaction_Phone_Number$contact_phone_type_KEYcontact_phone_type_KEYIndex supports foreign key FK_Interaction_Phone_Number__Contact_Phone_Type__contact_phone_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Interaction_Phone_Number__Interaction__interaction_KEYinteraction_KEYInteraction

Schema diagram