VendorContact Table (AdventureWorks)
Is a cross-reference table that maps vendors and their employees with whom employees of Adventure Works Cycles do business. For example, a buyer from Adventure Works Cycles would contact a sales representative at the vendor in order to purchase parts or products.
VendorContact Table Definition
The VendorContact table is contained in the Purchasing schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
VendorID |
int |
Not null |
Primary key. |
ContactID |
int |
Not null |
Identification number of the contact, the vendor employee. Foreign key to Contact.ContactID. |
ContactTypeID |
int |
Not null |
Contact type such as sales manager, or sales agent. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Contact Table (AdventureWorks)
ContactType Table (AdventureWorks)
Vendor Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary