ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Sales.ShoppingCartItem_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Sales.ShoppingCartItem |- valign="top" | '''Description''' | Contains online customer orders until the order is submitted or cancelled. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | ShoppingCartItemID | int | not null | | Primary key for ShoppingCartItem records. |- valign="top" | ShoppingCartID | nvarchar(50) | not null | | Shopping cart identification number. |- valign="top" | Quantity | int | not null | ((1)) | Product quantity ordered. |- valign="top" | ProductID | int | not null | | Product ordered. Foreign key to Product.ProductID. |- valign="top" | DateCreated | datetime | not null | (getdate()) | Date the time the record was created. |- valign="top" | ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_ShoppingCartItem_ShoppingCartItemID | ShoppingCartItemID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | IX_ShoppingCartItem_ShoppingCartID_ProductID | | ShoppingCartID, ProductID |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | CK_ShoppingCartItem_Quantity | ([Quantity]>=(1)) | Check constraint [Quantity] >= (1) |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[Production.Product_(table)|Production.Product]] | ProductID | ProductID |} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Schema | Schema | [[Sales_(schema)|Sales]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Sales.ShoppingCartItem |- valign="top" | '''Description''' | Contains online customer orders until the order is submitted or cancelled. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | ShoppingCartItemID | int | not null | | Primary key for ShoppingCartItem records.<br />PK_ShoppingCartItem_ShoppingCartItemID |- | ShoppingCartID | nvarchar(50) | not null | | Shopping cart identification number.<br />IX_ShoppingCartItem_ShoppingCartID_ProductID |- | Quantity | int | not null | (1) | Product quantity ordered.<br /> |- | ProductID | int | not null | | Product ordered. Foreign key to Product.ProductID.<br />IX_ShoppingCartItem_ShoppingCartID_ProductID |- | DateCreated | datetime | not null | (GETDATE()) | Date the time the record was created.<br /> |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- | [[Production.Product_(table)|Production.Product]] | ProductID | ProductID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Schema | Schema | [[Sales_(schema)|Sales]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.