Contact Table (AdventureWorks)
Contains a list of names and related information for each customer, employee, or vendor. For example, a customer (store) may provide a sales agent name as a primary contact for their company and a sales manager as a secondary contact.
Contact Table Definition
The Contact table is contained in the Person schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
ContactID |
int |
Not null |
Primary key for Contact rows. |
NameStyle |
NameStyle (user-defined type) bit |
Not null |
Indicates the column in which the family name is stored. 0 = Family name is stored in LastName and the first name is stored in FirstName. 1 = .Family name is stored in FirstName and the first name is stored in LastName. |
Title |
nvarchar(8) |
Null |
A courtesy title. For example, Mr. or Ms. |
FirstName |
Name (user-defined type) nvarchar(50) |
Not null |
First name of the person. |
MiddleName |
Name (user-defined type) nvarchar(50) |
Null |
Middle name or middle initial of the person. |
LastName |
Name (user-defined type) nvarchar(50) |
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 |
Null |
0 = Contact does not wish to receive e-mail promotions. 1 = Contact does wish to receive e-mail promotions. |
Phone |
Phone (user-defined type) nvarchar(25) |
Null |
Phone number associated with the person. |
PasswordHash |
varchar(40) |
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, such as additional phone numbers and addresses or special instructions and notes. Data is stored in XML format. For more information, see About the Contact.AdditionalContactInfo xml Column. |
rowguid |
uniqueidentifier ROWGUIDCOL |
Not null |
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
ContactType Table (AdventureWorks)
Customer Table (AdventureWorks)
Employee Table (AdventureWorks)
Individual Table (AdventureWorks)
Store Table (AdventureWorks)
Concepts
Sales and Marketing Scenario
Purchasing and Vendor Scenario
Other Resources
AdventureWorks Data Dictionary