This article outlines the database structure for the MMv4 review database table.
- id
The review's System ID (SID) number.
int(10) | unsigned | auto increment | primary key | indexed
- active
Whether the review is active or not.
int(10) | unsigned | indexed
- create_date
The date in which this review was created.
int(10) | unsigned | indexed
- pid
Referenced with the product.id in which this review is associated with.
int(10) | unsigned | indexed
- user_type
The type of user that created the review.
char(1) | indexed | values: C/A
- user_id
The system ID number of the customer or administrator who created the review.
int(10) | unsigned | indexed
- message
The text of the review.
longtext
|
