| Field | Type | Defaults | Nulls? | Comments | | ProductReviewID | int - Identity | None | No | Primary key for ProductReview records. |
| ProductID | int | None | No | Product identification number. Foreign key to Product.ProductID. |
| ReviewerName | nvarchar (50) | None | No | Name of the reviewer. |
| ReviewDate | datetime | (getdate()) | No | Date review was submitted. |
| EmailAddress | nvarchar (50) | None | No | Reviewer's e-mail address. |
| Rating | int | None | No | Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating. |
| Comments | nvarchar (3850) | None | Yes | Reviewer's comments |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |