MySQL Create Table SQL
Table Structure: okayapi_landi_maintain:/tablelist/okayapi_landi_maintain.html
-- MySQL Table okayapi_landi_maintain
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_maintain` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`room_number` varchar(64) NULL COMMENT '',
`guest_id` int(11) NULL COMMENT '',
`stime` datetime NULL COMMENT '',
`ftime` datetime NULL COMMENT '',
`etime` datetime NULL COMMENT '',
`okayapi_landi_maintain_level` int(11) NULL COMMENT '',
`problem` varchar(1024) NULL COMMENT '',
`pro_type` varchar(256) NULL COMMENT '',
`pro_cause` varchar(256) NULL COMMENT '',
`pro_detail` varchar(1024) NULL COMMENT '',
`pic` varchar(256) NULL COMMENT '',
`charge` double NULL DEFAULT '0' COMMENT '',
`times` int(11) NULL DEFAULT '1' COMMENT '',
`okayapi_landi_maintain_comment` varchar(256) NULL COMMENT '',
`follow` varchar(1024) NULL COMMENT '',
`state` int(11) NULL DEFAULT '0' COMMENT '',
`pay` tinyint(1) NULL DEFAULT '0' COMMENT '',
`sys_state` int(11) NULL DEFAULT '1' COMMENT '',
KEY `room_number` (`room_number`),
KEY `guest_id` (`guest_id`),
KEY `stime` (`stime`),
KEY `ftime` (`ftime`),
KEY `etime` (`etime`),
KEY `okayapi_landi_maintain_level` (`okayapi_landi_maintain_level`),
KEY `problem` (`problem`),
KEY `pro_type` (`pro_type`),
KEY `pro_cause` (`pro_cause`),
KEY `pro_detail` (`pro_detail`),
KEY `pic` (`pic`),
KEY `charge` (`charge`),
KEY `times` (`times`),
KEY `okayapi_landi_maintain_comment` (`okayapi_landi_maintain_comment`),
KEY `follow` (`follow`),
KEY `state` (`state`),
KEY `pay` (`pay`),
KEY `sys_state` (`sys_state`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-维修';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-18 of 18 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
room_number | varchar(64) | 是 | Normal Index | |||
guest_id | int(11) | 是 | ||||
stime | datetime | 是 | ||||
ftime | datetime | 是 | ||||
etime | datetime | 是 | ||||
okayapi_landi_maintain_level | int(11) | 是 | ||||
problem | varchar(1024) | 是 | ||||
pro_type | varchar(256) | 是 | ||||
pro_cause | varchar(256) | 是 | ||||
pro_detail | varchar(1024) | 是 | ||||
pic | varchar(256) | 是 | ||||
charge | double | 0 | 是 | 0 | ||
times | int(11) | 1 | 是 | 1 | ||
okayapi_landi_maintain_comment | varchar(256) | 是 | ||||
follow | varchar(1024) | 是 | ||||
state | int(11) | 0 | 是 | 0 | ||
pay | tinyint(1) | 0 | 是 | 0 | ||
sys_state | int(11) | 1 | 是 | 1 |