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;