Difference between revisions of "Production.ProductReview (table)"
| Line 117: | Line 117: | ||
| 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 123: | ||
| 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 129: | ||
| 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 135: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
| − | | Date review was submitted. | + | | Date review was submitted.<br /> |
|- valign="top" | |- valign="top" | ||
| EmailAddress | | EmailAddress | ||
| Line 141: | Line 141: | ||
| not null | | not null | ||
| | | | ||
| − | | Reviewer's e-mail address. | + | | Reviewer's e-mail address.<br /> |
|- valign="top" | |- valign="top" | ||
| Rating | | Rating | ||
| Line 147: | Line 147: | ||
| 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 153: | ||
| not null | | not null | ||
| | | | ||
| − | | Reviewer's | + | | Reviewer's comments<br />IX_ProductReview_ProductID_Name |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
| Line 159: | Line 159: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
| − | | Date and time the record was last updated. | + | | Date and time the record was last updated.<br /> |
|} | |} | ||
Revision as of 00:10, 27 November 2009
wikibot
| Table | Production.ProductReview |
| Column | Data Type | Nullable | Default | PK | Index |
| ProductReviewID | int | not null | PK_ProductReview_ProductReviewID | ||
| ProductID | int | not null | IX_ProductReview_ProductID_Name | ||
| ReviewerName | dbo.Name | not null | IX_ProductReview_ProductID_Name | ||
| ReviewDate | datetime | not null | (getdate()) | ||
| EmailAddress | nvarchar(50) | not null | |||
| Rating | int | not null | |||
| Comments | nvarchar(3850) | null | IX_ProductReview_ProductID_Name | ||
| ModifiedDate | datetime | not null | (getdate()) |
| Relation | Column | Referenced Column |
| Production.Product | ProductID | ProductID |
automatically generated
| 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 |
| Referenced Object | Object Type | Dependency Type |
| dbo.Name | Type | Data Type |
