| 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 | dbo.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) | null | | Reviewer's comments
IX_ProductReview_ProductID_Name |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|