| Tables | SQL 2005 Adventure Works OLTP |
Contains online customer orders until the order is submitted or cancelled.
Columns
Name Data type Nullable Description ShoppingCartItemID int No Column has identity seed value of 1 with a step value of 1.
Primary key for ShoppingCartItem records.ShoppingCartID nvarchar(50) No Shopping cart identification number. Quantity int No Default value: 1
Product quantity ordered.ProductID int No Product ordered. Foreign key to Product.ProductID. DateCreated datetime No Default value: GETDATE()
Date the time the record was created.ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_ShoppingCartItem_Quantity DEFAULT Quantity Value: 1
Default constraint value of 1DF_ShoppingCartItem_DateCreated DEFAULT DateCreated Value: GETDATE()
Default constraint value of GETDATE()DF_ShoppingCartItem_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()CK_ShoppingCartItem_Quantity CHECK N/A Value: ([Quantity] >= 1)
Check constraint [Quantity]>=(1)PK_ShoppingCartItem_ShoppingCartItemID PRIMARY KEY ShoppingCartItemID Clustered index created by a primary key constraint. FK_ShoppingCartItem_Product_ProductID FOREIGN KEY ProductID Reference table: Production.Product
Foreign key constraint referencing Product.ProductID.
Indices
Name Description IX_ShoppingCartItem_ShoppingCartID_ProductID Nonclustered index.
Triggers
Name Description Sales.uShoppingCartItem AFTER UPDATE trigger setting the ModifiedDate column in the ShoppingCartItem table to the current date.
Modified by
Name Description Sales.uShoppingCartItem AFTER UPDATE trigger setting the ModifiedDate column in the ShoppingCartItem table to the current date.
Applies to
Tables | User