| Column | Data Type | Nullable | Default | Description |
| ContactID | int | not null | | Primary key for Contact records. |
| 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. |
| 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. |
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |