Purchasing VendorContact (table)

wikibot

TablePurchasing.VendorContact
DescriptionCross-reference table mapping vendors and their employees.

Columns

ColumnData TypeNullableDefaultDescription
VendorIDintnot null Primary key.
ContactIDintnot null Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.
ContactTypeIDintnot null Contact type such as sales manager, or sales agent.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_VendorContact_VendorID_ContactIDVendorID, ContactID

Indexes

IndexTypeColumns
IX_VendorContact_ContactID ContactID
IX_VendorContact_ContactTypeID ContactTypeID

Foreign Keys

RelationColumnReferenced Column
Person.ContactContactIDContactID
Person.ContactTypeContactTypeIDContactTypeID
Purchasing.VendorVendorIDVendorID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaPurchasing

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewPurchasing.vVendor
SelectSQL table-valued-functiondbo.ufnGetContactInformation