okayapi_openant_product_discount - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_product_discount：/tablelist/okayapi_openant_product_discount.html


-- MySQL Table okayapi_openant_product_discount
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_product_discount` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_discount_id` int(11) NOT NULL COMMENT '',
    `product_id` int(11) NOT NULL COMMENT '',
    `user_class_id` int(11) NOT NULL COMMENT '',
    `quantity` int(4) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_openant_product_discount_value` decimal(15,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `date_start` datetime NOT NULL COMMENT '',
    `date_end` datetime NOT NULL COMMENT '',
    KEY `product_discount_id` (`product_discount_id`),
    KEY `product_id` (`product_id`),
    KEY `user_class_id` (`user_class_id`),
    KEY `quantity` (`quantity`),
    KEY `okayapi_openant_product_discount_value` (`okayapi_openant_product_discount_value`),
    KEY `date_start` (`date_start`),
    KEY `date_end` (`date_end`),
    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-7 of 7 results.

Field Name	Field Type	Default	IS NULL	Demo Data
product_discount_id	int(11)		否
product_id	int(11)		否
user_class_id	int(11)		否
quantity	int(4)	0	否	0
okayapi_openant_product_discount_value	decimal(15,4)	0.0000	否	0.0000
date_start	datetime		否
date_end	datetime		否