Table: dbo.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 (4) | NOT NULL | A unique value assigned to this e-mail address so that linking to this e-mail address uses only 4 bytes.
email_address | nvarchar (160) | 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 |
Unique constraints
Name | Columns | Description
UK_Email_Address$email_address | email_address |