MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_remittance：/tablelist/okayapi_lvyou_jee_remittance.html
-- MySQL Table okayapi_lvyou_jee_remittance
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_remittance` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '',
`bankname` varchar(20) NOT NULL COMMENT '',
`amount` decimal(10,2) NOT NULL COMMENT '',
`addtime` datetime NOT NULL COMMENT '',
`memo` varchar(200) NOT NULL COMMENT '',
`okayapi_lvyou_jee_remittance_status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '',
KEY `user_id` (`user_id`),
KEY `bankname` (`bankname`),
KEY `amount` (`amount`),
KEY `addtime` (`addtime`),
KEY `memo` (`memo`),
KEY `okayapi_lvyou_jee_remittance_status` (`okayapi_lvyou_jee_remittance_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-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| user_id | int(11) | 否 | ||||
| bankname | varchar(20) | 否 | ||||
| amount | decimal(10,2) | 否 | ||||
| addtime | datetime | 否 | ||||
| memo | varchar(200) | 是 | ||||
| okayapi_lvyou_jee_remittance_status | tinyint(2) | 0 | 否 | 0 |
