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. |