Table: Email_Address
Holds e-mail addresses to save space and aid in indexing. Each e-mail address must be unique and stored as lower case. It is expected that the e-mail address is a SMTP address and looks similar to "user.name@place.net"
Columns
NameTypeConstraintsDescription
email_address_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this e-mail address so that linking to this e-mail address uses only 4 bytes.
email_addressnvarchar (320)NOT NULLEach e-mail address must be unique and stored as lower case. It is expected that the e-mail address look like "user.name@place.net"
Primary key
NameColumnsDescription
PK_Email_Address$email_address_KEYemail_address_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Email_Address$email_addressemail_addressEach e-mail address must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Interaction_Email_Address__Email_Address__email_address_KEYemail_address_KEYInteraction_Email_Address

Schema diagram