Difference between revisions of "Production.ProductReview (table)"

From dbscript Online Help
Jump to: navigation, search
 
(7 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.ProductReview
 
| Production.ProductReview
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Customer reviews of products they have purchased.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| ProductReviewID
 
| ProductReviewID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductReview_ProductReviewID
+
| Primary key for ProductReview records.
−
|
+
|- valign="top"
−
|-
 
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Product identification number. Foreign key to Product.ProductID.
−
| IX_ProductReview_ProductID_Name
+
|- valign="top"
−
|-
 
 
| ReviewerName
 
| ReviewerName
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Name of the reviewer.
−
| IX_ProductReview_ProductID_Name
+
|- valign="top"
−
|-
 
 
| ReviewDate
 
| ReviewDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date review was submitted.
−
|
+
|- valign="top"
−
|-
 
 
| EmailAddress
 
| EmailAddress
 
| nvarchar(50)
 
| nvarchar(50)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Reviewer's e-mail address.
−
|
+
|- valign="top"
−
|-
 
 
| Rating
 
| Rating
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
−
|
+
|- valign="top"
−
|-
 
 
| Comments
 
| Comments
 
| nvarchar(3850)
 
| nvarchar(3850)
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Reviewer's comments
−
| IX_ProductReview_ProductID_Name
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (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_ProductReview_ProductReviewID
 +
| ProductReviewID
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| IX_ProductReview_ProductID_Name
 
|  
 
|  
−
|  
+
| ProductID, ReviewerName, Comments
 
|}
 
|}
  
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
  
 +
|- valign="top"
 +
| CK_ProductReview_Rating
 +
| ([Rating]>=(1) AND [Rating]<=(5))
 +
| Check constraint [Rating] BETWEEN (1) AND (5)
 +
|}
  
 +
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 83: Line 111:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.Product_(table)|Production.Product]]
 
| [[Production.Product_(table)|Production.Product]]
 
| ProductID
 
| ProductID
 
| ProductID
 
| ProductID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  
Line 95: Line 144:
 
| '''Table
 
| '''Table
 
| Production.ProductReview
 
| Production.ProductReview
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Customer reviews of products they have purchased.
 
| Customer reviews of products they have purchased.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 117: Line 164:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for ProductReview records.PK_ProductReview_ProductReviewID
+
| Primary key for ProductReview records.<br />PK_ProductReview_ProductReviewID
 
|- valign="top"
 
|- valign="top"
 
| ProductID
 
| ProductID
Line 123: Line 170:
 
| not null
 
| not null
 
|  
 
|  
−
| Product identification number. Foreign key to Product.ProductID.IX_ProductReview_ProductID_Name
+
| Product identification number. Foreign key to Product.ProductID.<br />IX_ProductReview_ProductID_Name
 
|- valign="top"
 
|- valign="top"
 
| ReviewerName
 
| ReviewerName
Line 129: Line 176:
 
| not null
 
| not null
 
|  
 
|  
−
| Name of the reviewer.IX_ProductReview_ProductID_Name
+
| Name of the reviewer.<br />IX_ProductReview_ProductID_Name
 
|- valign="top"
 
|- valign="top"
 
| ReviewDate
 
| ReviewDate
Line 135: Line 182:
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date review was submitted.
+
| Date review was submitted.<br />
 
|- valign="top"
 
|- valign="top"
 
| EmailAddress
 
| EmailAddress
Line 141: Line 188:
 
| not null
 
| not null
 
|  
 
|  
−
| Reviewer's e-mail address.
+
| Reviewer's e-mail address.<br />
 
|- valign="top"
 
|- valign="top"
 
| Rating
 
| Rating
Line 147: Line 194:
 
| not null
 
| not null
 
|  
 
|  
−
| Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
+
| Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.<br />
 
|- valign="top"
 
|- valign="top"
 
| Comments
 
| Comments
Line 153: Line 200:
 
| not null
 
| not null
 
|  
 
|  
−
| Reviewer's commentsIX_ProductReview_ProductID_Name
+
| Reviewer's comments<br />IX_ProductReview_ProductID_Name
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 159: Line 206:
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 179: Line 226:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 
| '''Referenced Object
 
| '''Referenced Object
−
| '''Object Type
+
 
−
| '''Dependency Type
 
−
 
 
|-
 
|-
 +
| Data Type
 +
| Type
 
| [[dbo.Name_(type)|dbo.Name]]
 
| [[dbo.Name_(type)|dbo.Name]]
−
| Type
+
 
−
| Data Type
+
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 
 
|}
 
|}

Latest revision as of 00:16, 24 June 2010

wikibot[edit]

Table Production.ProductReview
Description Customer reviews of products they have purchased.

Columns[edit]

Column Data Type Nullable Default Description
ProductReviewID int not null Primary key for ProductReview records.
ProductID int not null Product identification number. Foreign key to Product.ProductID.
ReviewerName dbo.Name not null Name of the reviewer.
ReviewDate datetime not null (getdate()) Date review was submitted.
EmailAddress nvarchar(50) not null Reviewer's e-mail address.
Rating int not null Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
Comments nvarchar(3850) null Reviewer's comments
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_ProductReview_ProductReviewID ProductReviewID

Indexes[edit]

Index Type Columns
IX_ProductReview_ProductID_Name ProductID, ReviewerName, Comments

Check Constraints[edit]

Check Constraint Expression Description
CK_ProductReview_Rating ([Rating]>=(1) AND [Rating]<=(5)) Check constraint [Rating] BETWEEN (1) AND (5)

Foreign Keys[edit]

Relation Column Referenced Column
Production.Product ProductID ProductID

References[edit]

Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production


automatically generated[edit]

Table Production.ProductReview
Description Customer reviews of products they have purchased.


Column Data Type Nullable Default Description / PK / Index
ProductReviewID int not null Primary key for ProductReview records.
PK_ProductReview_ProductReviewID
ProductID int not null Product identification number. Foreign key to Product.ProductID.
IX_ProductReview_ProductID_Name
ReviewerName Name not null Name of the reviewer.
IX_ProductReview_ProductID_Name
ReviewDate datetime not null (GETDATE()) Date review was submitted.
EmailAddress nvarchar(50) not null Reviewer's e-mail address.
Rating int not null Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
Comments nvarchar(3850) not null Reviewer's comments
IX_ProductReview_ProductID_Name
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Product ProductID ProductID


Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductReview_(table)&oldid=2640"