ProductReview Table (AdventureWorks)
Contains customer reviews of the products they have purchased.
ProductReview Table Definition
The ProductReview table is contained in the Production schema.
Column |
Data type |
Nullability |
Description |
|---|---|---|---|
ProductReviewID |
int |
Not null |
Primary key for ProductReview rows. |
ProductID |
int |
Not null |
Product identification number. Foreign key to Product.ProductID. |
ReviewerName |
Name (user-defined type) nvarchar(50) |
Not null |
Name of the reviewer. |
ReviewDate |
datetime |
Not null |
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 |
Date and time the row was last updated. |