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.