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

Help and Information

Getting SQL Server 2005 Assistance