Purchasing.ProductVendor Table

Information

Name	ProductVendor
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:54

Extended Properties

Name	Type	Property Name	Value
ProductVendor	TABLE	MS_Description	Cross-reference table mapping vendors with the products they supply.

Columns

Name	Data Type	Collation	References	Default
ProductID	int		Production.Product.ProductID
VendorID	int		Purchasing.Vendor.VendorID
AverageLeadTime	int
StandardPrice	money
LastReceiptCost	money
LastReceiptDate	datetime
MinOrderQty	int
MaxOrderQty	int
OnOrderQty	int
UnitMeasureCode	nchar(3)	SQL_Latin1_General_CP1_CI_AS	Production.UnitMeasure.UnitMeasureCode
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Columns
PK_ProductVendor_ProductID_VendorID	Clustered	ProductID, VendorID
IX_ProductVendor_UnitMeasureCode	NonClustered	UnitMeasureCode
IX_ProductVendor_VendorID	NonClustered	VendorID

Check Constraints

Name	Column	Expression
CK_ProductVendor_AverageLeadTime	AverageLeadTime	([AverageLeadTime]>=(1))
CK_ProductVendor_StandardPrice	StandardPrice	([StandardPrice]>(0.00))
CK_ProductVendor_LastReceiptCost	LastReceiptCost	([LastReceiptCost]>(0.00))
CK_ProductVendor_MinOrderQty	MinOrderQty	([MinOrderQty]>=(1))
CK_ProductVendor_MaxOrderQty	MaxOrderQty	([MaxOrderQty]>=(1))
CK_ProductVendor_OnOrderQty	OnOrderQty	([OnOrderQty]>=(0))

Foreign Key Constraints

Name	Type	Referenced Table
FK_ProductVendor_Product_ProductID	Foreign key	Production.Product
FK_ProductVendor_UnitMeasure_UnitMeasureCode	Foreign key	Production.UnitMeasure
FK_ProductVendor_Vendor_VendorID	Foreign key	Purchasing.Vendor

SQL Script

CREATE TABLE [Purchasing].[ProductVendor] (
    [ProductID] int NOT NULL,
    [VendorID] int NOT NULL,
    [AverageLeadTime] int NOT NULL,
    [StandardPrice] money NOT NULL,
    [LastReceiptCost] money NULL,
    [LastReceiptDate] datetime NULL,
    [MinOrderQty] int NOT NULL,
    [MaxOrderQty] int NOT NULL,
    [OnOrderQty] int NULL,
    [UnitMeasureCode] nchar(3) NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_ProductVendor_UnitMeasureCode] on [Purchasing].[ProductVendor]([UnitMeasureCode]);
CREATE INDEX [IX_ProductVendor_VendorID] on [Purchasing].[ProductVendor]([VendorID]);