Sales.ShoppingCartItem (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:50Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:22Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:32Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:16Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:39Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:54Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:07Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:19Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:32Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.ShoppingCartItem |- |} {| border="1" cellpadding="5" cellspacing="0" s...

2009-01-03T12:35:08Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.ShoppingCartItem |- |} {| border="1" cellpadding="5" cellspacing="0" s...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Sales.ShoppingCartItem
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| ShoppingCartItemID
| int
| not null
|
| PK_ShoppingCartItem_ShoppingCartItemID
|
|-
| ShoppingCartID
| nvarchar(50)
| not null
|
|
| IX_ShoppingCartItem_ShoppingCartID_ProductID
|-
| Quantity
| int
| not null
| ((1))
|
|
|-
| ProductID
| int
| not null
|
|
| IX_ShoppingCartItem_ShoppingCartID_ProductID
|-
| DateCreated
| datetime
| not null
| (getdate())
|
|
|-
| ModifiedDate
| datetime
| not null
| (getdate())
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[Production.Product_(table)|Production.Product]]
| ProductID
| ProductID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.ShoppingCartItem
@@ Line 8: / Line 8: @@
 | '''Description
 | Contains online customer orders until the order is submitted or cancelled.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ShoppingCartItemID
@@ Line 64: / Line 62: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ShoppingCartItem_ShoppingCartItemID
 | ShoppingCartItemID
@@ Line 75: / Line 73: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_ShoppingCartItem_ShoppingCartID_ProductID
+|
@@ Line 88: / Line 86: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_ShoppingCartItem_Quantity
 | ([Quantity]>=(1))
@@ Line 101: / Line 99: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ProductID
@@ Line 115: / Line 113: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for ShoppingCartItem records.<br />PK_ShoppingCartItem_ShoppingCartItemID
+| Primary key for ShoppingCartItem records.
 |- valign="top"
 | ShoppingCartID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Shopping cart identification number.<br />IX_ShoppingCartItem_ShoppingCartID_ProductID
+| Shopping cart identification number.
 |- valign="top"
 | Quantity
@@ Line 37: / Line 38: @@
 | not null
 | ((1))
-| Product quantity ordered.<br />
+| Product quantity ordered.
 |- valign="top"
 | ProductID
@@ Line 43: / Line 44: @@
 | not null
+|
-| Product ordered. Foreign key to Product.ProductID.<br />IX_ShoppingCartItem_ShoppingCartID_ProductID
+| Product ordered. Foreign key to Product.ProductID.
 |- valign="top"
 | DateCreated
@@ Line 49: / Line 50: @@
 | not null
 | (getdate())
-| Date the time the record was created.<br />
+| Date the time the record was created.
 |- valign="top"
 | ModifiedDate
@@ Line 55: / Line 56: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 72: / Line 108: @@
 |}

@@ Line 82: / Line 82: @@
 | Sales.ShoppingCartItem
 |- valign="top"
 | '''Description
 | Contains online customer orders until the order is submitted or cancelled.
 |-
 |}

@@ Line 153: / Line 153: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}

@@ Line 81: / Line 81: @@
 | '''Table
 | Sales.ShoppingCartItem
-|-
+|- valign="top"
 | '''Description
@@ Line 103: / Line 103: @@
 | not null
+|
-| Primary key for ShoppingCartItem records.PK_ShoppingCartItem_ShoppingCartItemID
+| Primary key for ShoppingCartItem records.<br />PK_ShoppingCartItem_ShoppingCartItemID
 |- valign="top"
 | ShoppingCartID
@@ Line 109: / Line 109: @@
 | not null
+|
-| Shopping cart identification number.IX_ShoppingCartItem_ShoppingCartID_ProductID
+| Shopping cart identification number.<br />IX_ShoppingCartItem_ShoppingCartID_ProductID
 |- valign="top"
 | Quantity
@@ Line 115: / Line 115: @@
 | not null
 | (1)
-| Product quantity ordered.
+| Product quantity ordered.<br />
 |- valign="top"
 | ProductID
@@ Line 121: / Line 121: @@
 | not null
+|
-| Product ordered. Foreign key to Product.ProductID.IX_ShoppingCartItem_ShoppingCartID_ProductID
+| Product ordered. Foreign key to Product.ProductID.<br />IX_ShoppingCartItem_ShoppingCartID_ProductID
 |- valign="top"
 | DateCreated
@@ Line 127: / Line 127: @@
 | not null
 | (GETDATE())
-| Date the time the record was created.
+| Date the time the record was created.<br />
 |- valign="top"
 | ModifiedDate
@@ Line 133: / Line 133: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}