Sales.ShoppingCartItem Table

Information

Name	ShoppingCartItem
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:55

Extended Properties

Name	Type	Property Name	Value
ShoppingCartItem	TABLE	MS_Description	Contains online customer orders until the order is submitted or cancelled.

Columns

Name	Data Type	Collation	References	Default
ShoppingCartItemID	int
ShoppingCartID	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
Quantity	int			((1))
ProductID	int		Production.Product.ProductID
DateCreated	datetime			(getdate())
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ShoppingCartItem_ShoppingCartItemID	Clustered			ShoppingCartItemID
IX_ShoppingCartItem_ShoppingCartID_ProductID	NonClustered			ShoppingCartID, ProductID

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_ShoppingCartItem_Quantity	Quantity			([Quantity]>=(1))

Foreign Key Constraints

Name	Type	Referenced Table
FK_ShoppingCartItem_Product_ProductID	Foreign key	Production.Product

SQL Script

CREATE TABLE [Sales].[ShoppingCartItem] (
    [ShoppingCartItemID] int NOT NULL IDENTITY,
    [ShoppingCartID] nvarchar(50) NOT NULL,
    [Quantity] int NOT NULL DEFAULT ((1)),
    [ProductID] int NOT NULL,
    [DateCreated] datetime NOT NULL DEFAULT (getdate()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_ShoppingCartItem_ShoppingCartID_ProductID] on [Sales].[ShoppingCartItem]([ShoppingCartID], [ProductID]);