Production.ProductListPriceHistory

Columns

• //

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

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

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

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

  //

  CONSTRAINT: Check constraint [ListPrice] > (0.00)

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

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

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_ProductListPriceHistory_ProductID_StartDate
  UNIQUE CLUSTERED
  ProductID , StartDate

Foreign Keys

• //

  Foreign key constraint referencing Product.ProductID.
  FK_ProductListPriceHistory_Product_ProductID
  Production.Product
  ProductID ⥱ ProductID

Check Constraints

• //

  Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL
  CK_ProductListPriceHistory_EndDate
  ([EndDate]>=[StartDate] OR [EndDate] IS NULL)

Sample Data