MySQL Create Table SQL
Table Structure: okayapi_dberp_sales_order_return:/tablelist/okayapi_dberp_sales_order_return.html
-- MySQL Table okayapi_dberp_sales_order_return
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_sales_order_return` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sales_order_id` int(11) NOT NULL COMMENT '',
`sales_order_sn` varchar(50) NOT NULL COMMENT '',
`sales_send_order_id` int(11) NOT NULL COMMENT '',
`sales_send_order_sn` varchar(50) NOT NULL COMMENT '',
`sales_order_goods_return_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`sales_order_return_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`sales_order_return_info` varchar(500) NOT NULL COMMENT '',
`return_time` int(10) NOT NULL COMMENT '',
`return_state` tinyint(2) NOT NULL COMMENT '',
`return_finish_time` int(10) NOT NULL COMMENT '',
`admin_id` int(11) NOT NULL COMMENT '',
KEY `sales_order_id` (`sales_order_id`),
KEY `sales_order_sn` (`sales_order_sn`),
KEY `sales_send_order_id` (`sales_send_order_id`),
KEY `sales_send_order_sn` (`sales_send_order_sn`),
KEY `sales_order_goods_return_amount` (`sales_order_goods_return_amount`),
KEY `sales_order_return_amount` (`sales_order_return_amount`),
KEY `sales_order_return_info` (`sales_order_return_info`),
KEY `return_time` (`return_time`),
KEY `return_state` (`return_state`),
KEY `return_finish_time` (`return_finish_time`),
KEY `admin_id` (`admin_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-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
sales_order_id | int(11) | 否 | ||||
sales_order_sn | varchar(50) | 否 | ||||
sales_send_order_id | int(11) | 否 | ||||
sales_send_order_sn | varchar(50) | 否 | ||||
sales_order_goods_return_amount | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
sales_order_return_amount | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
sales_order_return_info | varchar(500) | 是 | ||||
return_time | int(10) | 否 | ||||
return_state | tinyint(2) | 否 | ||||
return_finish_time | int(10) | 是 | ||||
admin_id | int(11) | 否 |