ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
Production.ProductListPriceHistory_(table)
Print
RSS
Modified: 2011/08/27 10:14 by
wikibot
-
Uncategorized
»
public.setsnmpinterfacekeysonupdate_(trigger function)
»
Production.ProductListPriceHistory_(table)
[X]
»
public.setsnmpinterfacekeysonupdate_(trigger function)
»
Production.ProductListPriceHistory_(table)
Edit
wikibot
Table
Production.ProductListPriceHistory
Description
Changes in the list price of a product over time.
Edit
Columns
Column
Data Type
Nullable
Default
Description
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
not null
Product list price.
ModifiedDate
datetime
not null
(getdate())
Date and time the record was last updated.
Edit
Primary Key
Primary Key
Columns
PK_ProductListPriceHistory_ProductID_StartDate
ProductID, StartDate
Edit
Check Constraints
Check Constraint
Expression
Description
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)
Edit
Foreign Keys
Relation
Column
Referenced Column
Production.Product
ProductID
ProductID
Edit
References
Dependency Type
Object Type
Referenced Object
Schema
Schema
Production
Edit
Dependencies
Reference Type
Object Type
Referencing Object
Select
Function
dbo.ufnGetProductDealerPrice
Select
Function
dbo.ufnGetProductListPrice
Edit
automatically generated
Table
Production.ProductListPriceHistory
Description
Changes in the list price of a product over time.
Column
Data Type
Nullable
Default
Description / PK / Index
ProductID
int
not null
Product identification number. Foreign key to Product.ProductID
PK_ProductListPriceHistory_ProductID_StartDate
StartDate
datetime
not null
List price start date.
PK_ProductListPriceHistory_ProductID_StartDate
EndDate
datetime
null
List price end date
ListPrice
money
not null
Product list price.
ModifiedDate
datetime
not null
(GETDATE())
Date and time the record was last updated.
Relation
Column
Referenced Column
Production.Product
ProductID
ProductID
Dependency Type
Object Type
Referenced Object
Schema
Schema
Production
Reference Type
Object Type
Referencing Object
Select
Function
dbo.ufnGetProductDealerPrice
Select
Function
dbo.ufnGetProductListPrice
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.