StoreContact Table (AdventureWorks)
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

StoreContact Table (AdventureWorks)

Is a cross-reference table that maps stores and their employees with whom Adventure Works Cycles sales representatives do business.

The StoreContact table is contained in the Sales schema.

Column Data type Nullability Description

CustomerID

int

Not null

Primary key. Store identification number. Foreign key to Customer.CustomerID.

ContactID

int

Not null

Primary key. Contact, the store employee, identification number. Foreign key to Contact.ContactID.

ContactTypeID

tinyint

Not null

Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.

rowguid

uniqueidentifier

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.

Show:
© 2016 Microsoft