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.