| Field | Type | Defaults | Nulls? | Comments | | ContactID | int - Identity | None | No | Primary key for Contact records. |
| NameStyle | bit | ((0)) | No | 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) | None | Yes | A courtesy title. For example, Mr. or Ms. |
| FirstName | nvarchar (50) | None | No | First name of the person. |
| MiddleName | nvarchar (50) | None | Yes | Middle name or middle initial of the person. |
| LastName | nvarchar (50) | None | No | Last name of the person. |
| Suffix | nvarchar (10) | None | Yes | Surname suffix. For example, Sr. or Jr. |
| EmailAddress | nvarchar (50) | None | Yes | E-mail address for the person. |
| EmailPromotion | int | ((0)) | No | 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 | nvarchar (25) | None | Yes | Phone number associated with the person. |
| PasswordHash | varchar (128) | None | No | Password for the e-mail account. |
| PasswordSalt | varchar (10) | None | No | Random value concatenated with the password string before the password is hashed. |
| AdditionalContactInfo | xml | None | Yes | Additional contact information about the person stored in xml format. |
| rowguid | uniqueidentifier | (newid()) | No | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |