Purchasing.VendorContact

Table: 'Purchasing.VendorContact'

4 fields. 28 bytes.

Cross-reference table mapping vendors and their employees.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
VendorIDint   Not nullPrimary key. 
ContactIDint   Not nullContact (Vendor employee) identification number. Foreign key to Contact.ContactID. 
ContactTypeIDint   Not nullContact type such as sales manager, or sales agent. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Purchasing.VendorContact'

Primary Key NameField Names
PK_VendorContact_VendorID_ContactIDVendorID, ContactID

Foreign keys for table 'Purchasing.VendorContact', 3 items

ForeignPrimaryKey Name
VendorContact.ContactIDContact.ContactIDFK_VendorContact_Contact_ContactID
VendorContact.ContactTypeIDContactType.ContactTypeIDFK_VendorContact_ContactType_ContactTypeID
VendorContact.VendorIDVendor.VendorIDFK_VendorContact_Vendor_VendorID

Indexes for table 'Purchasing.VendorContact', 3 items

Index NameDescriptionClusteredUniqueFields
PK_VendorContact_VendorID_ContactIDClustered index created by a primary key constraint.YesYesVendorID, ContactID
IX_VendorContact_ContactIDNonclustered index.NoNoContactID
IX_VendorContact_ContactTypeIDNonclustered index.NoNoContactTypeID

Triggers for table 'Purchasing.VendorContact', 1 item

NameDescriptionTypeEnabled
uVendorContactAFTER UPDATE trigger setting the ModifiedDate column in the VendorContact table to the current date.after Update Yes

Dependencies for table 'Purchasing.VendorContact', 3 items

Object NameTypeField Name
dbo.ufnGetContactInformationtable functionN/A
Purchasing.uVendorContacttriggerN/A
Purchasing.vVendorviewN/A