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
NameTypeConstraintsDescription
interaction_KEYintNOT NULLA reference to one of the Interaction rows.
email_address_KEYintNOT NULLA reference to one of the e-mail addresses stored in the Email_Address table.
email_address_fieldvarchar (4)NOT NULLThe e-mail address field this link came from (Bcc, Cc, From or To.)
Primary key
NameColumnsDescription
PK_Interaction_Email_Address$interaction_KEY$email_address_KEY$email_address_fieldinteraction_KEY, email_address_KEY, email_address_fieldCLUSTERED
Indexes
NameColumnsDescription
IX_Interaction_Email_Address$email_address_KEYemail_address_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Interaction_Email_Address__Email_Address__email_address_KEYemail_address_KEYEmail_Address
FK_Interaction_Email_Address__Interaction__interaction_KEYinteraction_KEYInteractionon delete cascade;

Schema diagram