okayapi_openant_product - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_product：/tablelist/okayapi_openant_product.html


-- MySQL Table okayapi_openant_product
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_product` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(11) NOT NULL COMMENT '',
    `address_id` int(11) NOT NULL COMMENT '',
    `stock_status_id` int(11) NOT NULL COMMENT '',
    `freight_template_id` int(11) NOT NULL COMMENT '',
    `image` varchar(255) NOT NULL COMMENT '',
    `manufacturer_id` int(11) NOT NULL COMMENT '',
    `shipping` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `price` decimal(15,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `points` int(8) NOT NULL DEFAULT '0' COMMENT '',
    `user_points` int(11) NOT NULL COMMENT '',
    `tax_class_id` int(11) NOT NULL COMMENT '',
    `weight` decimal(15,8) NOT NULL DEFAULT '0.00000000' COMMENT '',
    `weight_class_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `length` decimal(15,8) NOT NULL DEFAULT '0.00000000' COMMENT '',
    `width` decimal(15,8) NOT NULL DEFAULT '0.00000000' COMMENT '',
    `height` decimal(15,8) NOT NULL DEFAULT '0.00000000' COMMENT '',
    `length_class_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `subtract` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `maximum` int(3) NOT NULL COMMENT '',
    `commission_rate` int(11) NOT NULL DEFAULT '1' COMMENT '',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `seo_order` float(11,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `okayapi_openant_product_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '上下架',
    `viewed` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `quantity` int(11) NOT NULL COMMENT '',
    `invalid` tinyint(1) NOT NULL DEFAULT '0' COMMENT '永久屏蔽',
    `date_added` datetime NOT NULL COMMENT '',
    `date_modified` datetime NOT NULL COMMENT '',
    `date_invalid` datetime NOT NULL COMMENT '',
    KEY `product_id` (`product_id`),
    KEY `address_id` (`address_id`),
    KEY `stock_status_id` (`stock_status_id`),
    KEY `freight_template_id` (`freight_template_id`),
    KEY `image` (`image`),
    KEY `manufacturer_id` (`manufacturer_id`),
    KEY `shipping` (`shipping`),
    KEY `price` (`price`),
    KEY `points` (`points`),
    KEY `user_points` (`user_points`),
    KEY `tax_class_id` (`tax_class_id`),
    KEY `weight` (`weight`),
    KEY `weight_class_id` (`weight_class_id`),
    KEY `length` (`length`),
    KEY `width` (`width`),
    KEY `height` (`height`),
    KEY `length_class_id` (`length_class_id`),
    KEY `subtract` (`subtract`),
    KEY `maximum` (`maximum`),
    KEY `commission_rate` (`commission_rate`),
    KEY `store_id` (`store_id`),
    KEY `sort_order` (`sort_order`),
    KEY `seo_order` (`seo_order`),
    KEY `okayapi_openant_product_status` (`okayapi_openant_product_status`),
    KEY `viewed` (`viewed`),
    KEY `quantity` (`quantity`),
    KEY `invalid` (`invalid`),
    KEY `date_added` (`date_added`),
    KEY `date_modified` (`date_modified`),
    KEY `date_invalid` (`date_invalid`),
    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-30 of 30 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
product_id	int(11)		否
address_id	int(11)		否
stock_status_id	int(11)		否
freight_template_id	int(11)		否
image	varchar(255)		否
manufacturer_id	int(11)		否
shipping	tinyint(1)	1	否		1
price	decimal(15,4)	0.0000	否		0.0000
points	int(8)	0	否		0
user_points	int(11)		否
tax_class_id	int(11)		否
weight	decimal(15,8)	0.00000000	否		0.00000000
weight_class_id	int(11)	0	否		0
length	decimal(15,8)	0.00000000	否		0.00000000
width	decimal(15,8)	0.00000000	否		0.00000000
height	decimal(15,8)	0.00000000	否		0.00000000
length_class_id	int(11)	0	否		0
subtract	tinyint(1)	1	否		1
maximum	int(3)		否
commission_rate	int(11)	1	否		1
store_id	int(11)	0	否		0
sort_order	int(11)	0	否		0
seo_order	float(11,4)	0.0000	否		0.0000
okayapi_openant_product_status	tinyint(1)	0	否	上下架	0
viewed	int(11)	0	否		0
quantity	int(11)		否
invalid	tinyint(1)	0	否	永久屏蔽	0
date_added	datetime		否
date_modified	datetime		否
date_invalid	datetime		否