Production.ProductListPriceHistory

Table: 'Production.ProductListPriceHistory'

5 fields. 73 bytes.

Changes in the list price of a product over time.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ProductID	int				Not null	Product identification number. Foreign key to Product.ProductID
StartDate	datetime				Not null	List price start date.
EndDate	datetime				Null	List price end date
ListPrice	money	19,4	decimal(19,4)		Not null	Product list price.	([ListPrice]>(0.00))
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductListPriceHistory'

Primary Key Name	Field Names
PK_ProductListPriceHistory_ProductID_StartDate	ProductID, StartDate

Foreign keys for table 'Production.ProductListPriceHistory', 1 item

Foreign	Primary	Key Name
ProductListPriceHistory.ProductID	Product.ProductID	FK_ProductListPriceHistory_Product_ProductID

Indexes for table 'Production.ProductListPriceHistory', 1 item

Index Name	Description	Clustered	Unique	Fields
PK_ProductListPriceHistory_ProductID_StartDate	Clustered index created by a primary key constraint.	Yes	Yes	ProductID, StartDate

Triggers for table 'Production.ProductListPriceHistory', 1 item

Name	Description	Type	Enabled
uProductListPriceHistory	AFTER UPDATE trigger setting the ModifiedDate column in the ProductListPriceHistory table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductListPriceHistory', 5 items

Object Name	Type	Field Name
dbo.ufnGetProductDealerPrice	scalar function	N/A
dbo.ufnGetProductListPrice	scalar function	N/A
Production.CK_ProductListPriceHistory_EndDate	check cns	N/A
Production.CK_ProductListPriceHistory_ListPrice	check cns	N/A
Production.uProductListPriceHistory	trigger	N/A