okayapi_openant_product_option_value - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_product_option_value：/tablelist/okayapi_openant_product_option_value.html


-- MySQL Table okayapi_openant_product_option_value
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_product_option_value` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_option_value_id` int(11) NOT NULL COMMENT '',
    `product_id` int(11) NOT NULL COMMENT '',
    `option_group_id` text NOT NULL COMMENT '',
    `option_id` text NOT NULL COMMENT '',
    `quantity` int(3) NOT NULL COMMENT '',
    `price` decimal(15,4) NOT NULL COMMENT '',
    `points` int(8) NOT NULL COMMENT '',
    KEY `product_option_value_id` (`product_option_value_id`),
    KEY `product_id` (`product_id`),
    KEY `option_group_id` (`option_group_id`),
    KEY `option_id` (`option_id`),
    KEY `quantity` (`quantity`),
    KEY `price` (`price`),
    KEY `points` (`points`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-商品选项值';

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