ProductReviews

Returns reviews registered for products.

Table Specific Information

SELECT * FROM ProductReviews

To insert a new ProductReviews, you need to specify at least the following columns: Title,Status, Id,ProductId,DateReviewed.

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

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

DELETE FROM ProductReviews WHERE Id = 16


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	False		The Id of the review.
ProductId [KEY]	Integer	True	Products.Id	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.