Sales.ShoppingCartItem (table)

From dbscript Online Help
Revision as of 22:55, 28 December 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table Sales.ShoppingCartItem
Description Contains online customer orders until the order is submitted or cancelled.


Column Data Type Nullable Default Description / PK / Index
ShoppingCartItemID int not null Primary key for ShoppingCartItem records.
PK_ShoppingCartItem_ShoppingCartItemID
ShoppingCartID nvarchar(50) not null Shopping cart identification number.
IX_ShoppingCartItem_ShoppingCartID_ProductID
Quantity int not null ((1)) Product quantity ordered.
ProductID int not null Product ordered. Foreign key to Product.ProductID.
IX_ShoppingCartItem_ShoppingCartID_ProductID
DateCreated datetime not null (getdate()) Date the time the record was created.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Product ProductID ProductID


automatically generated

Table Sales.ShoppingCartItem
Description Contains online customer orders until the order is submitted or cancelled.


Column Data Type Nullable Default Description / PK / Index
ShoppingCartItemID int not null Primary key for ShoppingCartItem records.
PK_ShoppingCartItem_ShoppingCartItemID
ShoppingCartID nvarchar(50) not null Shopping cart identification number.
IX_ShoppingCartItem_ShoppingCartID_ProductID
Quantity int not null (1) Product quantity ordered.
ProductID int not null Product ordered. Foreign key to Product.ProductID.
IX_ShoppingCartItem_ShoppingCartID_ProductID
DateCreated datetime not null (GETDATE()) Date the time the record was created.
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 Sales