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" |
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" |