Production.ProductListPriceHistory Table

Information

Name	ProductListPriceHistory
Schema	Production
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
ProductListPriceHistory	TABLE	MS_Description	Changes in the list price of a product over time.

Columns

Name	Data Type	References	Default
ProductID	int	Production.Product.ProductID
StartDate	datetime
EndDate	datetime
ListPrice	money
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ProductListPriceHistory_ProductID_StartDate	Clustered			ProductID, StartDate

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_ProductListPriceHistory_EndDate				([EndDate]>=[StartDate] OR [EndDate] IS NULL)
CK_ProductListPriceHistory_ListPrice	ListPrice			([ListPrice]>(0.00))

Foreign Key Constraints

Name	Type	Referenced Table
FK_ProductListPriceHistory_Product_ProductID	Foreign key	Production.Product

SQL Script

CREATE TABLE [Production].[ProductListPriceHistory] (
    [ProductID] int NOT NULL,
    [StartDate] datetime NOT NULL,
    [EndDate] datetime NULL,
    [ListPrice] money NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);