Purchasing.VendorContact

Table: 'Purchasing.VendorContact'

4 fields. 28 bytes.

Cross-reference table mapping vendors and their employees.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
VendorID	int				Not null	Primary key.
ContactID	int				Not null	Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.
ContactTypeID	int				Not null	Contact type such as sales manager, or sales agent.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Purchasing.VendorContact'

Primary Key Name	Field Names
PK_VendorContact_VendorID_ContactID	VendorID, ContactID

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

Foreign	Primary	Key Name
VendorContact.ContactID	Contact.ContactID	FK_VendorContact_Contact_ContactID
VendorContact.ContactTypeID	ContactType.ContactTypeID	FK_VendorContact_ContactType_ContactTypeID
VendorContact.VendorID	Vendor.VendorID	FK_VendorContact_Vendor_VendorID

Indexes for table 'Purchasing.VendorContact', 3 items

Index Name	Description	Clustered	Unique	Fields
PK_VendorContact_VendorID_ContactID	Clustered index created by a primary key constraint.	Yes	Yes	VendorID, ContactID
IX_VendorContact_ContactID	Nonclustered index.	No	No	ContactID
IX_VendorContact_ContactTypeID	Nonclustered index.	No	No	ContactTypeID

Triggers for table 'Purchasing.VendorContact', 1 item

Name	Description	Type	Enabled
uVendorContact	AFTER 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 Name	Type	Field Name
dbo.ufnGetContactInformation	table function	N/A
Purchasing.uVendorContact	trigger	N/A
Purchasing.vVendor	view	N/A