Purchasing.ProductVendor

Columns

• //

  ${escapify(column.description)}
  ProductID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  BusinessEntityID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  AverageLeadTime
  [int] NOT NULL

  //

  CONSTRAINT: Check constraint [AverageLeadTime] >= (1)

  ([AverageLeadTime]>=(1))
• //

  ${escapify(column.description)}
  StandardPrice
  [money] NOT NULL

  //

  CONSTRAINT: Check constraint [StandardPrice] > (0.00)

  ([StandardPrice]>(0.00))
• //

  ${escapify(column.description)}
  LastReceiptCost
  [money] NULL

  //

  CONSTRAINT: Check constraint [LastReceiptCost] > (0.00)

  ([LastReceiptCost]>(0.00))
• //

  ${escapify(column.description)}
  LastReceiptDate
  [datetime] NULL
• //

  ${escapify(column.description)}
  MinOrderQty
  [int] NOT NULL

  //

  CONSTRAINT: Check constraint [MinOrderQty] >= (1)

  ([MinOrderQty]>=(1))
• //

  ${escapify(column.description)}
  MaxOrderQty
  [int] NOT NULL

  //

  CONSTRAINT: Check constraint [MaxOrderQty] >= (1)

  ([MaxOrderQty]>=(1))
• //

  ${escapify(column.description)}
  OnOrderQty
  [int] NULL

  //

  CONSTRAINT: Check constraint [OnOrderQty] >= (0)

  ([OnOrderQty]>=(0))
• //

  ${escapify(column.description)}
  UnitMeasureCode
  [nchar](3) NOT NULL
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_ProductVendor_ProductID_BusinessEntityID
  UNIQUE CLUSTERED
  ProductID , BusinessEntityID
• //

  Nonclustered index.
  IX_ProductVendor_UnitMeasureCode
  NONCLUSTERED
  UnitMeasureCode
• //

  Nonclustered index.
  IX_ProductVendor_BusinessEntityID
  NONCLUSTERED
  BusinessEntityID

Foreign Keys

• //

  Foreign key constraint referencing Product.ProductID.
  FK_ProductVendor_Product_ProductID
  Production.Product
  ProductID ⥱ ProductID
• //

  Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
  FK_ProductVendor_UnitMeasure_UnitMeasureCode
  Production.UnitMeasure
  UnitMeasureCode ⥱ UnitMeasureCode
• //

  Foreign key constraint referencing Vendor.BusinessEntityID.
  FK_ProductVendor_Vendor_BusinessEntityID
  Purchasing.Vendor
  BusinessEntityID ⥱ BusinessEntityID

Sample Data