MySQL Create Table SQL
Table Structure: okayapi_dberp_purchase_order_return：/tablelist/okayapi_dberp_purchase_order_return.html
-- MySQL Table okayapi_dberp_purchase_order_return
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_purchase_order_return` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`p_order_id` int(11) NOT NULL COMMENT '采购订单id',
`p_order_sn` varchar(50) NOT NULL COMMENT '采购单编号',
`p_order_goods_return_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '',
`p_order_return_amount` decimal(19,4) NOT NULL DEFAULT '0.0000' COMMENT '退货单金额',
`p_order_return_info` varchar(500) NOT NULL COMMENT '退货原因',
`return_time` int(10) NOT NULL COMMENT '退货单添加时间',
`return_state` tinyint(2) NOT NULL DEFAULT '-1' COMMENT '',
`return_finish_time` int(10) NOT NULL COMMENT '',
`admin_id` int(11) NOT NULL COMMENT '操作者id',
KEY `p_order_id` (`p_order_id`),
KEY `p_order_sn` (`p_order_sn`),
KEY `p_order_goods_return_amount` (`p_order_goods_return_amount`),
KEY `p_order_return_amount` (`p_order_return_amount`),
KEY `p_order_return_info` (`p_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-9 of 9 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| p_order_id | int(11) | 否 | 采购订单id | |||
| p_order_sn | varchar(50) | 否 | 采购单编号 | |||
| p_order_goods_return_amount | decimal(19,4) | 0.0000 | 否 | 0.0000 | ||
| p_order_return_amount | decimal(19,4) | 0.0000 | 否 | 退货单金额 | 0.0000 | |
| p_order_return_info | varchar(500) | 是 | 退货原因 | |||
| return_time | int(10) | 否 | 退货单添加时间 | |||
| return_state | tinyint(2) | -1 | 否 | -1 | ||
| return_finish_time | int(10) | 是 | ||||
| admin_id | int(11) | 否 | 操作者id |
