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
Name | Type | Constraints | Description
email_address_KEY | int | NOT NULL | Assigned 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_address | nvarchar (320) | NOT NULL | Each 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
Name | Columns | Description
PK_Email_Address$email_address_KEY | email_address_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Email_Address__email_address | email_address | Each e-mail address must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Interaction_Email_Address__Email_Address__email_address_KEY | email_address_KEY | Interaction_Email_Address |