MySQL Create Table SQL
Table Structure: okayapi_landi_problem:/tablelist/okayapi_landi_problem.html
-- MySQL Table okayapi_landi_problem
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_problem` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`room_num` varchar(255) NULL COMMENT '',
`room_state` varchar(255) NULL COMMENT '',
`guest_name` varchar(255) NULL COMMENT '',
`reflect_date` date NULL COMMENT '报修时间',
`solve_date` date NULL COMMENT '需要解决时间',
`reflecter_id` int(11) NULL COMMENT '申报人',
`reflecter_name` varchar(255) NULL COMMENT '',
`description` varchar(255) NULL COMMENT '问题描述',
`outsider_reason` varchar(255) NULL COMMENT '',
`outsider_comment` varchar(255) NULL COMMENT '备注',
`is_lemanage` int(11) NULL COMMENT '',
`okayapi_landi_problem_type` varchar(255) NULL COMMENT '',
`subtype` varchar(255) NULL COMMENT '',
`okayapi_landi_problem_level` varchar(255) NULL COMMENT '',
`repairer_reason` varchar(255) NULL COMMENT '',
`repairer_comment` varchar(255) NULL COMMENT '',
KEY `room_num` (`room_num`),
KEY `room_state` (`room_state`),
KEY `guest_name` (`guest_name`),
KEY `reflect_date` (`reflect_date`),
KEY `solve_date` (`solve_date`),
KEY `reflecter_id` (`reflecter_id`),
KEY `reflecter_name` (`reflecter_name`),
KEY `description` (`description`),
KEY `outsider_reason` (`outsider_reason`),
KEY `outsider_comment` (`outsider_comment`),
KEY `is_lemanage` (`is_lemanage`),
KEY `okayapi_landi_problem_type` (`okayapi_landi_problem_type`),
KEY `subtype` (`subtype`),
KEY `okayapi_landi_problem_level` (`okayapi_landi_problem_level`),
KEY `repairer_reason` (`repairer_reason`),
KEY `repairer_comment` (`repairer_comment`),
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-16 of 16 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
room_num | varchar(255) | 是 | ||||
room_state | varchar(255) | 是 | ||||
guest_name | varchar(255) | 是 | ||||
reflect_date | date | 是 | 报修时间 | |||
solve_date | date | 是 | 需要解决时间 | |||
reflecter_id | int(11) | 是 | 申报人 | |||
reflecter_name | varchar(255) | 是 | ||||
description | varchar(255) | 是 | 问题描述 | |||
outsider_reason | varchar(255) | 是 | ||||
outsider_comment | varchar(255) | 是 | 备注 | |||
is_lemanage | int(11) | 是 | ||||
okayapi_landi_problem_type | varchar(255) | 是 | ||||
subtype | varchar(255) | 是 | ||||
okayapi_landi_problem_level | varchar(255) | 是 | ||||
repairer_reason | varchar(255) | 是 | ||||
repairer_comment | varchar(255) | 是 |