| Column | Data Type | Nullable | Default | Description / PK / Index |
| ContactID | int | not null | | Primary key for Contact records.
PK_Contact_ContactID |
| NameStyle | dbo.NameStyle | not null | ((0)) | 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
|
| Title | nvarchar(8) | null | | A courtesy title. For example, Mr. or Ms.
|
| FirstName | dbo.Name | not null | | First name of the person.
|
| MiddleName | dbo.Name | null | | Middle name or middle initial of the person.
|
| LastName | dbo.Name | not null | | Last name of the person.
|
| Suffix | nvarchar(10) | null | | Surname suffix. For example, Sr. or Jr.
|
| EmailAddress | nvarchar(50) | null | | E-mail address for the person.
IX_Contact_EmailAddress |
| EmailPromotion | int | not null | ((0)) | 0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
|
| Phone | dbo.Phone | null | | Phone number associated with the person.
|
| PasswordHash | varchar(128) | not null | | Password for the e-mail account.
|
| PasswordSalt | varchar(10) | not null | | Random value concatenated with the password string before the password is hashed.
|
| AdditionalContactInfo | xml | null | | Additional contact information about the person stored in xml format.
PXML_Contact_AddContact |
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Contact_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|