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.
Primary key. Store identification number. Foreign key to Customer.CustomerID.
Primary key. Contact, the store employee, identification number. Foreign key to Contact.ContactID.
Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
Date and time the row was last updated.