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
Name | Type | Constraints | Description
interaction_KEY | int | NOT NULL | A reference to one of the Interaction rows.
contact_phone_type_KEY | int | NOT NULL | Key to a Contact Phone Type record.
phone_number | nvarchar (30) | NOT NULL | Phone number.
extension | nvarchar (5) | NOT NULL | Extension.

Primary key
Name | Columns | Description
PK_Interaction_Phone_Number$interaction_KEY | interaction_KEY | CLUSTERED Only one phone number can be saved per Interaction.
Indexes
Name | Columns | Description
IX_Interaction_Phone_Number$contact_phone_type_KEY | contact_phone_type_KEY | Index supports foreign key FK_Interaction_Phone_Number__Contact_Phone_Type__contact_phone_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Interaction_Phone_Number__Contact_Phone_Type__contact_phone_type_KEY | contact_phone_type_KEY | Contact_Phone_Type |
FK_Interaction_Phone_Number__Interaction__interaction_KEY | interaction_KEY | Interaction |