MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_payment_api:/tablelist/okayapi_lvyou_jee_payment_api.html
-- MySQL Table okayapi_lvyou_jee_payment_api
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_payment_api` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`api_id` int(11) NULL COMMENT '',
`okayapi_lvyou_jee_payment_api_names` varchar(50) NULL COMMENT '',
`names_en` varchar(50) NULL COMMENT '',
`url` varchar(255) NULL COMMENT '',
`merchantid` varchar(50) NULL COMMENT '',
`merchantkey` varchar(255) NULL COMMENT '',
`UDID` varchar(255) NULL COMMENT '',
`payment_pwd` varchar(255) NULL COMMENT '',
`payment_in` varchar(255) NULL COMMENT '',
`fee` double NULL COMMENT '',
`sort` int(11) NULL COMMENT '',
`okayapi_lvyou_jee_payment_api_status` smallint(6) NULL COMMENT '',
`description` varchar(255) NULL COMMENT '',
`configs` text NULL COMMENT '映射',
KEY `api_id` (`api_id`),
KEY `okayapi_lvyou_jee_payment_api_names` (`okayapi_lvyou_jee_payment_api_names`),
KEY `names_en` (`names_en`),
KEY `url` (`url`),
KEY `merchantid` (`merchantid`),
KEY `merchantkey` (`merchantkey`),
KEY `UDID` (`UDID`),
KEY `payment_pwd` (`payment_pwd`),
KEY `payment_in` (`payment_in`),
KEY `fee` (`fee`),
KEY `sort` (`sort`),
KEY `okayapi_lvyou_jee_payment_api_status` (`okayapi_lvyou_jee_payment_api_status`),
KEY `description` (`description`),
KEY `configs` (`configs`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-支付API接口';
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 |
---|---|---|---|---|---|---|
api_id | int(11) | 否 | ||||
okayapi_lvyou_jee_payment_api_names | varchar(50) | 否 | ||||
names_en | varchar(50) | 是 | ||||
url | varchar(255) | 否 | ||||
merchantid | varchar(50) | 否 | ||||
merchantkey | varchar(255) | 否 | ||||
UDID | varchar(255) | 否 | ||||
payment_pwd | varchar(255) | 否 | ||||
payment_in | varchar(255) | 否 | ||||
fee | double | 否 | ||||
sort | int(11) | 否 | ||||
okayapi_lvyou_jee_payment_api_status | smallint(6) | 否 | ||||
description | varchar(255) | 否 | ||||
configs | text | 是 | 映射 |