Share via


ShoppingCartItem Table (AdventureWorks)

Contains the orders for online customers until the orders are submitted or canceled.

ShoppingCartItem Table Definition

The ShoppingCartItem table is contained in the Sales schema.

Column Data type Nullability Description

ShoppingCartItemID

smallint

Not null

Primary key.

ShoppingCartID

nvarchar(50)

Not null

Shopping cart identification number.

Quantity

int

Not null

Product quantity ordered.

ProductID

int

Not null

Product ordered. Foreign key to Product.ProductID.

DateCreated

datetime

Not null

Date the time the row was created.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Customer Table (AdventureWorks)
Individual Table (AdventureWorks)
Product Table (AdventureWorks)
SalesOrderDetail Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance