MySQL Create Table SQL
Table Structure: okayapi_pt_tab_receiveorders：/tablelist/okayapi_pt_tab_receiveorders.html
-- MySQL Table okayapi_pt_tab_receiveorders
-- From: OkayAPI.com
CREATE TABLE `okayapi_pt_tab_receiveorders` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`oid` int(11) NOT NULL COMMENT '订单编号',
`uid` int(11) NOT NULL COMMENT '接单人编号',
`okayapi_pt_tab_receiveorders_status` int(11) NOT NULL COMMENT '状态 0正在接单 1等待验收 2未完成 3已完成 ',
KEY `oid` (`oid`),
KEY `uid` (`uid`),
KEY `okayapi_pt_tab_receiveorders_status` (`okayapi_pt_tab_receiveorders_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'pt校园兼职-接单';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| oid | int(11) | 否 | 订单编号 | |||
| uid | int(11) | 否 | 接单人编号 | |||
| okayapi_pt_tab_receiveorders_status | int(11) | 否 | 状态 0正在接单 1等待验收 2未完成 3已完成 |
