MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_payment_bill:/tablelist/okayapi_lvyou_jee_payment_bill.html
-- MySQL Table okayapi_lvyou_jee_payment_bill
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_payment_bill` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`OrderId` varchar(50) NULL COMMENT '',
`POrderId` varchar(50) NULL COMMENT '',
`MerchantID` varchar(50) NULL COMMENT '',
`amount` decimal(10,2) NULL COMMENT '',
`apiName` varchar(50) NULL COMMENT '',
`AutoReceive` varchar(255) NULL COMMENT '',
`Receive` varchar(255) NULL COMMENT '',
`bank` varchar(15) NULL COMMENT '',
`remark1` varchar(255) NULL COMMENT '',
`remark2` varchar(255) NULL COMMENT '',
`start_time` int(11) NULL COMMENT '',
`finish_time` int(11) NULL COMMENT '',
`browser` varchar(255) NULL COMMENT '',
`okayapi_lvyou_jee_payment_bill_status` smallint(6) NULL COMMENT '',
KEY `OrderId` (`OrderId`),
KEY `POrderId` (`POrderId`),
KEY `MerchantID` (`MerchantID`),
KEY `amount` (`amount`),
KEY `apiName` (`apiName`),
KEY `AutoReceive` (`AutoReceive`),
KEY `Receive` (`Receive`),
KEY `bank` (`bank`),
KEY `remark1` (`remark1`),
KEY `remark2` (`remark2`),
KEY `start_time` (`start_time`),
KEY `finish_time` (`finish_time`),
KEY `browser` (`browser`),
KEY `okayapi_lvyou_jee_payment_bill_status` (`okayapi_lvyou_jee_payment_bill_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-支付账单';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-14 of 14 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
OrderId | varchar(50) | 否 | ||||
POrderId | varchar(50) | 否 | ||||
MerchantID | varchar(50) | 是 | ||||
amount | decimal(10,2) | 是 | ||||
apiName | varchar(50) | 是 | ||||
AutoReceive | varchar(255) | 是 | ||||
Receive | varchar(255) | 是 | ||||
bank | varchar(15) | 是 | ||||
remark1 | varchar(255) | 是 | ||||
remark2 | varchar(255) | 是 | ||||
start_time | int(11) | 是 | ||||
finish_time | int(11) | 是 | ||||
browser | varchar(255) | 是 | ||||
okayapi_lvyou_jee_payment_bill_status | smallint(6) | 是 |