Sales.ShoppingCartItem

Table: 'Sales.ShoppingCartItem'

6 fields. 144 bytes.

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

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ShoppingCartItemID	int identity		int		Not null	Primary key for ShoppingCartItem records.
ShoppingCartID	nvarchar	50			Not null	Shopping cart identification number.
Quantity	int			(1)	Not null	Product quantity ordered.	([Quantity]>=(1))
ProductID	int				Not null	Product ordered. Foreign key to Product.ProductID.
DateCreated	datetime			getdate()	Not null	Date the time the record was created.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.ShoppingCartItem'

Primary Key Name	Field Name
PK_ShoppingCartItem_ShoppingCartItemID	ShoppingCartItemID

Foreign keys for table 'Sales.ShoppingCartItem', 1 item

Foreign	Primary	Key Name
ShoppingCartItem.ProductID	Product.ProductID	FK_ShoppingCartItem_Product_ProductID

Indexes for table 'Sales.ShoppingCartItem', 2 items

Index Name	Description	Clustered	Unique	Fields
PK_ShoppingCartItem_ShoppingCartItemID	Clustered index created by a primary key constraint.	Yes	Yes	ShoppingCartItemID
IX_ShoppingCartItem_ShoppingCartID_ProductID	Nonclustered index.	No	No	ShoppingCartID, ProductID

Triggers for table 'Sales.ShoppingCartItem', 1 item

Name	Description	Type	Enabled
uShoppingCartItem	AFTER UPDATE trigger setting the ModifiedDate column in the ShoppingCartItem table to the current date.	after Update	Yes

Dependencies for table 'Sales.ShoppingCartItem', 2 items

Object Name	Type	Field Name
Sales.CK_ShoppingCartItem_Quantity	check cns	N/A
Sales.uShoppingCartItem	trigger	N/A