.png)
ShoppingCartItem Table (AdventureWorks)
Contains the orders for online customers until the orders are submitted or canceled.
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. |
