Production ProductListPriceHistory (table)

wikibot

TableProduction.ProductListPriceHistory
DescriptionChanges in the list price of a product over time.

Columns

ColumnData TypeNullableDefaultDescription
ProductIDintnot null Product identification number. Foreign key to Product.ProductID
StartDatedatetimenot null List price start date.
EndDatedatetimenull List price end date
ListPricemoneynot null Product list price.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_ProductListPriceHistory_ProductID_StartDateProductID, StartDate

Check Constraints

Check ConstraintExpressionDescription
CK_ProductListPriceHistory_EndDate(EndDate>=StartDate OR EndDate IS NULL)Check constraint EndDate >= StartDate OR EndDate IS NULL
CK_ProductListPriceHistory_ListPrice(ListPrice>(0.00))Check constraint ListPrice > (0.00)

Foreign Keys

RelationColumnReferenced Column
Production.ProductProductIDProductID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Dependencies

Reference TypeObject TypeReferencing Object
SelectFunctiondbo.ufnGetProductDealerPrice
SelectFunctiondbo.ufnGetProductListPrice