Purchasing.VendorContact Table

Information

Name	VendorContact
Schema	Purchasing
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:56

Extended Properties

Name	Type	Property Name	Value
VendorContact	TABLE	MS_Description	Cross-reference table mapping vendors and their employees.

Columns

Name	Data Type	References	Default
VendorID	int	Purchasing.Vendor.VendorID
ContactID	int	Person.Contact.ContactID
ContactTypeID	int	Person.ContactType.ContactTypeID
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Columns
PK_VendorContact_VendorID_ContactID	Clustered	VendorID, ContactID
IX_VendorContact_ContactID	NonClustered	ContactID
IX_VendorContact_ContactTypeID	NonClustered	ContactTypeID

Foreign Key Constraints

Name	Type	Referenced Table
FK_VendorContact_Contact_ContactID	Foreign key	Person.Contact
FK_VendorContact_ContactType_ContactTypeID	Foreign key	Person.ContactType
FK_VendorContact_Vendor_VendorID	Foreign key	Purchasing.Vendor

SQL Script

CREATE TABLE [Purchasing].[VendorContact] (
    [VendorID] int NOT NULL,
    [ContactID] int NOT NULL,
    [ContactTypeID] int NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_VendorContact_ContactID] on [Purchasing].[VendorContact]([ContactID]);
CREATE INDEX [IX_VendorContact_ContactTypeID] on [Purchasing].[VendorContact]([ContactTypeID]);