|
this article last updated: June 2, 2010 Due to inevitable changes that will be made to the shopping cart software over time, the cart's variable and database structure may change from time to time without advanced notice. We will attempt to keep the information in this article up-to-date, but Modular Merchant makes no guarantee as to the accuracy of the information provided in this article. Use this information at your own risk.
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
|
