Export (0) Print
Expand All
Expand Minimize

ProductReview Table (AdventureWorks)

Contains customer reviews of the products they have purchased.

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.

Community Additions

ADD
Show:
© 2014 Microsoft