Export (0) Print
Expand All
Expand Minimize

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft