MySQL Create Table SQL
Table Structure: okayapi_dberp_shop_order:/tablelist/okayapi_dberp_shop_order.html
-- MySQL Table okayapi_dberp_shop_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_shop_order` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`shop_order_sn` varchar(50) NOT NULL COMMENT '',
`shop_buy_name` varchar(100) NOT NULL COMMENT '',
`shop_payment_code` varchar(20) NOT NULL COMMENT '',
`shop_payment_name` varchar(30) NOT NULL COMMENT '',
`shop_payment_cost` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`shop_payment_certification` varchar(500) NOT NULL COMMENT '',
`shop_express_code` varchar(30) NOT NULL COMMENT '',
`shop_express_name` varchar(50) NOT NULL COMMENT '',
`shop_express_cost` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`shop_order_other_cost` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`shop_order_other_info` varchar(500) NOT NULL COMMENT '',
`shop_order_state` tinyint(2) NOT NULL DEFAULT '10' COMMENT '',
`shop_order_discount_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`shop_order_discount_info` varchar(500) NOT NULL COMMENT '',
`shop_order_goods_amount` decimal(19,4) NOT NULL COMMENT '',
`shop_order_amount` decimal(19,4) NOT NULL COMMENT '',
`shop_order_add_time` int(10) NOT NULL COMMENT '',
`shop_order_pay_time` int(10) NOT NULL COMMENT '',
`shop_order_express_time` int(10) NOT NULL COMMENT '',
`shop_order_finish_time` int(10) NOT NULL COMMENT '',
`shop_order_message` varchar(500) NOT NULL COMMENT '',
`app_id` int(11) NOT NULL COMMENT '',
KEY `shop_order_sn` (`shop_order_sn`),
KEY `shop_buy_name` (`shop_buy_name`),
KEY `shop_payment_code` (`shop_payment_code`),
KEY `shop_payment_name` (`shop_payment_name`),
KEY `shop_payment_cost` (`shop_payment_cost`),
KEY `shop_payment_certification` (`shop_payment_certification`),
KEY `shop_express_code` (`shop_express_code`),
KEY `shop_express_name` (`shop_express_name`),
KEY `shop_express_cost` (`shop_express_cost`),
KEY `shop_order_other_cost` (`shop_order_other_cost`),
KEY `shop_order_other_info` (`shop_order_other_info`),
KEY `shop_order_state` (`shop_order_state`),
KEY `shop_order_discount_amount` (`shop_order_discount_amount`),
KEY `shop_order_discount_info` (`shop_order_discount_info`),
KEY `shop_order_goods_amount` (`shop_order_goods_amount`),
KEY `shop_order_amount` (`shop_order_amount`),
KEY `shop_order_add_time` (`shop_order_add_time`),
KEY `shop_order_pay_time` (`shop_order_pay_time`),
KEY `shop_order_express_time` (`shop_order_express_time`),
KEY `shop_order_finish_time` (`shop_order_finish_time`),
KEY `shop_order_message` (`shop_order_message`),
KEY `app_id` (`app_id`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'DBErp进销存-商城订单';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-22 of 22 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
shop_order_sn | varchar(50) | 否 | ||||
shop_buy_name | varchar(100) | 否 | ||||
shop_payment_code | varchar(20) | 否 | ||||
shop_payment_name | varchar(30) | 否 | ||||
shop_payment_cost | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
shop_payment_certification | varchar(500) | 是 | ||||
shop_express_code | varchar(30) | 否 | ||||
shop_express_name | varchar(50) | 否 | ||||
shop_express_cost | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
shop_order_other_cost | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
shop_order_other_info | varchar(500) | 是 | ||||
shop_order_state | tinyint(2) | 10 | 否 | 10 | ||
shop_order_discount_amount | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
shop_order_discount_info | varchar(500) | 是 | ||||
shop_order_goods_amount | decimal(19,4) | 否 | ||||
shop_order_amount | decimal(19,4) | 否 | ||||
shop_order_add_time | int(10) | 否 | ||||
shop_order_pay_time | int(10) | 是 | ||||
shop_order_express_time | int(10) | 是 | ||||
shop_order_finish_time | int(10) | 是 | ||||
shop_order_message | varchar(500) | 是 | ||||
app_id | int(11) | 否 |