Table: Interaction_Email_Address | |||
Holds the list of e-mail address and which e-mail address fields they came from for a particular interaction. | |||
Columns | |||
Name | Type | Constraints | Description |
interaction_KEY | int | NOT NULL | A reference to one of the Interaction rows. |
email_address_KEY | int | NOT NULL | A reference to one of the e-mail addresses stored in the Email_Address table. |
email_address_field | varchar (4) | NOT NULL | The e-mail address field this link came from (Bcc, Cc, From or To.) |
Primary key | |||
Name | Columns | Description | |
PK_Interaction_Email_Address$interaction_KEY$email_address_KEY$email_address_field | interaction_KEY, email_address_KEY, email_address_field | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Interaction_Email_Address$email_address_KEY | email_address_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Interaction_Email_Address__Email_Address__email_address_KEY | email_address_KEY | Email_Address | |
FK_Interaction_Email_Address__Interaction__interaction_KEY | interaction_KEY | Interaction | on delete cascade; |