Sales.ShoppingCartItem - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	ShoppingCartItem
Module	Sales

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

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ShoppingCartItemID	int		Identity		Primary key for ShoppingCartItem records.
Primary key for ShoppingCartItem records. Identity
	2		ShoppingCartID	nvarchar(50)				Shopping cart identification number.
Shopping cart identification number.
	3		Quantity	int		Default: 1		Product quantity ordered.
Product quantity ordered. Default: 1
	4		ProductID	int			Production.Product	Product ordered. Foreign key to Product.ProductID.
Product ordered. Foreign key to Product.ProductID. References: Production.Product
	5		DateCreated	datetime		Default: getdate()		Date the time the record was created.
Date the time the record was created. Default: getdate()
	6		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Sales.ShoppingCartItem		Production.Product	Sales.ShoppingCartItem.ProductID = Production.Product.ProductID	FK_ShoppingCartItem_Product_ProductID Foreign key constraint referencing Product.ProductID.
Sales.ShoppingCartItem.ProductID = Production.Product.ProductID Name: FK_ShoppingCartItem_Product_ProductID Foreign key constraint referencing Product.ProductID.

Unique keys

	Key name	Columns	Description
	PK_ShoppingCartItem_ShoppingCartItemID	ShoppingCartItemID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Sales.ShoppingCartItem
Production.Product

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56