Production.ProductReview (table)
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 |
