MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_payment_merchant:/tablelist/okayapi_lvyou_jee_payment_merchant.html
-- MySQL Table okayapi_lvyou_jee_payment_merchant
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_payment_merchant` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`merchant_name` varchar(50) NULL COMMENT '',
`MerchantID` varchar(20) NULL COMMENT '',
`MerchantKey` varchar(64) NULL COMMENT '',
`api_lists` varchar(255) NULL COMMENT '',
`okayapi_lvyou_jee_payment_merchant_status` tinyint(1) NULL COMMENT '',
KEY `merchant_name` (`merchant_name`),
KEY `MerchantID` (`MerchantID`),
KEY `MerchantKey` (`MerchantKey`),
KEY `api_lists` (`api_lists`),
KEY `okayapi_lvyou_jee_payment_merchant_status` (`okayapi_lvyou_jee_payment_merchant_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-5 of 5 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
merchant_name | varchar(50) | 否 | ||||
MerchantID | varchar(20) | 是 | ||||
MerchantKey | varchar(64) | 是 | ||||
api_lists | varchar(255) | 是 | ||||
okayapi_lvyou_jee_payment_merchant_status | tinyint(1) | 是 |