| Column | Data Type | Nullable | Default | Description / PK / Index |
| ShoppingCartItemID | int | not null | | Primary key for ShoppingCartItem records.
PK_ShoppingCartItem_ShoppingCartItemID |
| ShoppingCartID | nvarchar(50) | not null | | Shopping cart identification number.
IX_ShoppingCartItem_ShoppingCartID_ProductID |
| Quantity | int | not null | ((1)) | Product quantity ordered.
|
| ProductID | int | not null | | Product ordered. Foreign key to Product.ProductID.
IX_ShoppingCartItem_ShoppingCartID_ProductID |
| DateCreated | datetime | not null | (getdate()) | Date the time the record was created.
|
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|