ShoppingCartItem Table (AdventureWorks)
SQL Server 2008
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. |
