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.