MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_user_bill:/tablelist/okayapi_lvyou_jee_user_bill.html
-- MySQL Table okayapi_lvyou_jee_user_bill
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_user_bill` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '',
`code_id` varchar(20) NOT NULL COMMENT '',
`money` decimal(10,2) NOT NULL COMMENT '',
`balance` decimal(10,2) NOT NULL COMMENT '',
`mark` varchar(20) NOT NULL COMMENT '',
`okayapi_lvyou_jee_user_bill_type` smallint(6) NOT NULL COMMENT '',
`create_time` int(11) NOT NULL COMMENT '',
KEY `user_id` (`user_id`),
KEY `code_id` (`code_id`),
KEY `money` (`money`),
KEY `balance` (`balance`),
KEY `mark` (`mark`),
KEY `okayapi_lvyou_jee_user_bill_type` (`okayapi_lvyou_jee_user_bill_type`),
KEY `create_time` (`create_time`),
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-7 of 7 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
user_id | int(11) | 否 | ||||
code_id | varchar(20) | 否 | ||||
money | decimal(10,2) | 否 | ||||
balance | decimal(10,2) | 否 | ||||
mark | varchar(20) | 否 | ||||
okayapi_lvyou_jee_user_bill_type | smallint(6) | 否 | ||||
create_time | int(11) | 否 |