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
NameTypeConstraintsDescription
email_address_KEYint (4)NOT NULLA unique value assigned to this e-mail address so that linking to this e-mail address uses only 4 bytes.
email_addressnvarchar (160)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_Addressemail_address_KEY
Unique constraints
NameColumnsDescription
UK_Email_Address$email_addressemail_address

Schema diagram