Production.ProductReview (table) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:55Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:49Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:04Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:48Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:10Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:06Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:16Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:39Z

Bot at 22:57, 26 November 2009

2009-11-26T22:57:53Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:04Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.ProductReview
@@ Line 8: / Line 8: @@
 | '''Description
 | Customer reviews of products they have purchased.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ProductReviewID
@@ Line 76: / Line 74: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ProductReview_ProductReviewID
 | ProductReviewID
@@ Line 87: / Line 85: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_ProductReview_ProductID_Name
+|
@@ Line 100: / Line 98: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_ProductReview_Rating
 | ([Rating]>=(1) AND [Rating]<=(5))
@@ Line 113: / Line 111: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ProductID
@@ Line 127: / Line 125: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Data Type
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
-|-
+|- 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 ProductReview records.<br />PK_ProductReview_ProductReviewID
+| Primary key for ProductReview records.
 |- valign="top"
 | ProductID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Product identification number. Foreign key to Product.ProductID.<br />IX_ProductReview_ProductID_Name
+| Product identification number. Foreign key to Product.ProductID.
 |- valign="top"
 | ReviewerName
@@ Line 37: / Line 38: @@
 | not null
+|
-| Name of the reviewer.<br />IX_ProductReview_ProductID_Name
+| Name of the reviewer.
 |- valign="top"
 | ReviewDate
@@ Line 43: / Line 44: @@
 | not null
 | (getdate())
-| Date review was submitted.<br />
+| Date review was submitted.
 |- valign="top"
 | EmailAddress
@@ Line 49: / Line 50: @@
 | not null
+|
-| Reviewer's e-mail address.<br />
+| Reviewer's e-mail address.
 |- valign="top"
 | Rating
@@ Line 55: / Line 56: @@
 | not null
+|
-| Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.<br />
+| Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
 |- valign="top"
 | Comments
@@ Line 61: / Line 62: @@
 | null
+|
-| Reviewer's comments<br />IX_ProductReview_ProductID_Name
+| Reviewer's comments
 |- valign="top"
 | ModifiedDate
@@ Line 67: / Line 68: @@
 | 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 84: / Line 120: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 95: / Line 131: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.ProductReview
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | ProductReviewID
 | int
 | not null
+|
-| PK_ProductReview_ProductReviewID
+| Primary key for ProductReview records.<br />PK_ProductReview_ProductReviewID
+|- valign="top"
 | ProductID
 | int
 | not null
+|
+| Product identification number. Foreign key to Product.ProductID.<br />IX_ProductReview_ProductID_Name
-| IX_ProductReview_ProductID_Name
+|- valign="top"
 | ReviewerName
 | dbo.Name
 | not null
+|
+| Name of the reviewer.<br />IX_ProductReview_ProductID_Name
-| IX_ProductReview_ProductID_Name
+|- valign="top"
 | ReviewDate
 | datetime
 | not null
 | (getdate())
+| Date review was submitted.<br />
+|- valign="top"
 | EmailAddress
 | nvarchar(50)
 | not null
+|
+| Reviewer's e-mail address.<br />
+|- valign="top"
 | Rating
 | int
 | not null
+|
+| Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.<br />
+|- valign="top"
 | Comments
 | nvarchar(3850)
 | null
+|
+| Reviewer's comments<br />IX_ProductReview_ProductID_Name
-| IX_ProductReview_ProductID_Name
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 89: / Line 83: @@
 | ProductID
 |}
 == automatically generated ==

@@ Line 96: / Line 96: @@
 | Production.ProductReview
 |- valign="top"
 | '''Description
 | Customer reviews of products they have purchased.
 |-
 |}

@@ Line 179: / Line 179: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[dbo.Name_(type)|dbo.Name]]
-| Type
 |-
 | Schema
 | Schema
 |}

@@ Line 182: / Line 182: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[dbo.Name_(type)|dbo.Name]]
 | Type
 | Data Type
 |}