MySQL Create Table SQL
Table Structure: okayapi_zheng_pay_out_order:/tablelist/okayapi_zheng_pay_out_order.html
-- MySQL Table okayapi_zheng_pay_out_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_pay_out_order` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`pay_mch_id` int(10) NOT NULL COMMENT '',
`pay_vendor_id` int(10) NOT NULL COMMENT '',
`amount` decimal(10,0) NOT NULL COMMENT '',
`okayapi_zheng_pay_out_order_status` tinyint(4) NOT NULL COMMENT '',
`ctime` bigint(20) NOT NULL COMMENT '',
KEY `pay_mch_id` (`pay_mch_id`),
KEY `pay_vendor_id` (`pay_vendor_id`),
KEY `amount` (`amount`),
KEY `okayapi_zheng_pay_out_order_status` (`okayapi_zheng_pay_out_order_status`),
KEY `ctime` (`ctime`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-支出订单表';
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 |
---|---|---|---|---|---|---|
pay_mch_id | int(10) | 是 | ||||
pay_vendor_id | int(10) | 是 | ||||
amount | decimal(10,0) | 否 | ||||
okayapi_zheng_pay_out_order_status | tinyint(4) | 否 | ||||
ctime | bigint(20) | 否 |