MySQL Create Table SQL
Table Structure: okayapi_landi_guest_service:/tablelist/okayapi_landi_guest_service.html
-- MySQL Table okayapi_landi_guest_service
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_guest_service` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`free_money` double NULL COMMENT '赠送金额',
`free_reason` varchar(64) NULL COMMENT '赠送理由',
`guest_id` int(10) NULL COMMENT '',
`room_number` varchar(64) NULL COMMENT '',
`okayapi_landi_guest_service_name` varchar(64) NULL COMMENT '',
`lecharge` double NULL COMMENT '',
`lecount` int(11) NULL COMMENT '',
`spcharge` double NULL COMMENT '',
`spcount` int(11) NULL COMMENT '',
`turn` int(11) NULL COMMENT '',
`okayapi_landi_guest_service_comment` varchar(256) NULL COMMENT '',
`free` int(11) NULL COMMENT '',
`sys_state` int(11) NULL DEFAULT '1' COMMENT '',
KEY `free_money` (`free_money`),
KEY `free_reason` (`free_reason`),
KEY `guest_id` (`guest_id`),
KEY `room_number` (`room_number`),
KEY `okayapi_landi_guest_service_name` (`okayapi_landi_guest_service_name`),
KEY `lecharge` (`lecharge`),
KEY `lecount` (`lecount`),
KEY `spcharge` (`spcharge`),
KEY `spcount` (`spcount`),
KEY `turn` (`turn`),
KEY `okayapi_landi_guest_service_comment` (`okayapi_landi_guest_service_comment`),
KEY `free` (`free`),
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-13 of 13 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
free_money | double | 是 | 赠送金额 | |||
free_reason | varchar(64) | 是 | 赠送理由 | |||
guest_id | int(10) | 是 | Normal Index | |||
room_number | varchar(64) | 是 | Normal Index | |||
okayapi_landi_guest_service_name | varchar(64) | 是 | ||||
lecharge | double | 是 | ||||
lecount | int(11) | 是 | ||||
spcharge | double | 是 | ||||
spcount | int(11) | 是 | ||||
turn | int(11) | 是 | ||||
okayapi_landi_guest_service_comment | varchar(256) | 是 | ||||
free | int(11) | 是 | ||||
sys_state | int(11) | 1 | 是 | 1 |