.png)
StoreContact Table (AdventureWorks)
SQL Server 2008
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. |
