okayapi_openant_product_review - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_product_review：/tablelist/okayapi_openant_product_review.html


-- MySQL Table okayapi_openant_product_review
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_product_review` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `review_id` int(11) NOT NULL COMMENT '',
    `product_id` int(11) NOT NULL COMMENT '',
    `user_id` int(11) NOT NULL COMMENT '',
    `author` varchar(64) NOT NULL COMMENT '',
    `okayapi_openant_product_review_text` text NOT NULL COMMENT '',
    `rating` int(1) NOT NULL COMMENT '',
    `okayapi_openant_product_review_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    `date_modified` datetime NOT NULL COMMENT '',
    KEY `review_id` (`review_id`),
    KEY `product_id` (`product_id`),
    KEY `user_id` (`user_id`),
    KEY `author` (`author`),
    KEY `okayapi_openant_product_review_text` (`okayapi_openant_product_review_text`),
    KEY `rating` (`rating`),
    KEY `okayapi_openant_product_review_status` (`okayapi_openant_product_review_status`),
    KEY `date_added` (`date_added`),
    KEY `date_modified` (`date_modified`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-商品浏览';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Demo Data
review_id	int(11)		否
product_id	int(11)		否
user_id	int(11)		否
author	varchar(64)		否
okayapi_openant_product_review_text	text		否
rating	int(1)		否
okayapi_openant_product_review_status	tinyint(1)	0	否	0
date_added	datetime		否
date_modified	datetime		否