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.