.png)
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.
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. |
Reference
Contact Table (AdventureWorks)ContactType Table (AdventureWorks)
Vendor Table (AdventureWorks)
