Returns reviews registered for products.

Table Specific Information

Select

SELECT * FROM ProductReviews 

Insert

To insert a product review, specify at least the following columns: Title, Status, ProductId, and DateReviewed.

INSERT INTO ProductReviews (Title, Status, ProductId, DateReviewed) VALUES ('Car Interior121', 'approved', '103', '2019-08-24T14:15:22Z')

Update

You can update the following fields: Title, Status, DateReviewed, Text, Rating, Email, and Name

UPDATE ProductReviews SET Title = 'Testing123' WHERE Id = 7

Delete

DELETE FROM ProductReviews WHERE Id = 16

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The Id of the review.
ProductId [KEY]	Integer	False	The Id of the corresponding product.
Title	String	False	Title of the review.
Text	String	False	Text content of the review.
Status	String	False	The status of the product review. Must be one of approved, disapproved, or pending.
Rating	Integer	False	The rating of the product review. Must be one of 0, 1, 2, 3, 4, or 5.
Email	String	False	The email of the reviewer. Must be a valid email, or an empty string.
Name	String	False	The name of the reviewer.
DateCreated	Datetime	True	The date of creation for the review.
DateModified	Datetime	True	The last modification date of the review.
DateReviewed	Datetime	False	Date the product was reviewed.