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__Interaction__interaction_KEY | interaction_KEY | Interaction |