StoreContact Table (AdventureWorks)
Is a cross-reference table that maps stores and their employees with whom Adventure Works Cycles sales representatives do business.
StoreContact Table Definition
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. |
See Also