Sales.ShoppingCartItem

Generated using SQL Data Dictionary demo version.

Table Sales.ShoppingCartItem (3 rows)

Contains online customer orders until the order is submitted or cancelled.

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

Indexes:

PK_ShoppingCartItem_ShoppingCartItemID
- (Primary Key)
- (Clustered)
Primary key (clustered) constraint
- ShoppingCartItemID

IX_ShoppingCartItem_ShoppingCartID_ProductID
Nonclustered index.
- ShoppingCartID
- ProductID

References:

Production.Product
- ProductID