MySQL Create Table SQL
Table Structure: okayapi_dberp_sales_oper_log：/tablelist/okayapi_dberp_sales_oper_log.html
-- MySQL Table okayapi_dberp_sales_oper_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_dberp_sales_oper_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sales_order_id` int(11) NOT NULL COMMENT '',
`order_state` tinyint(2) NOT NULL COMMENT '',
`oper_user_id` int(11) NOT NULL COMMENT '',
`oper_user` varchar(100) NOT NULL COMMENT '',
`oper_time` int(10) NOT NULL COMMENT '',
KEY `sales_order_id` (`sales_order_id`),
KEY `order_state` (`order_state`),
KEY `oper_user_id` (`oper_user_id`),
KEY `oper_user` (`oper_user`),
KEY `oper_time` (`oper_time`),
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-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| sales_order_id | int(11) | 否 | ||||
| order_state | tinyint(2) | 否 | ||||
| oper_user_id | int(11) | 否 | ||||
| oper_user | varchar(100) | 否 | ||||
| oper_time | int(10) | 否 |
