okayapi_landi_room_state - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_landi_room_state：/tablelist/okayapi_landi_room_state.html


-- MySQL Table okayapi_landi_room_state
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_room_state` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `room_number` varchar(64) NOT NULL COMMENT '',
    `cus_id` int(11) NOT NULL COMMENT '',
    `cus_name` varchar(64) NOT NULL COMMENT '',
    `state` int(11) NOT NULL DEFAULT '0' COMMENT '0表示无人入住 1表示已有人入住 2房间非管理 3 其他使用',
    `room_id` int(11) NOT NULL COMMENT '',
    KEY `room_number` (`room_number`),
    KEY `cus_id` (`cus_id`),
    KEY `cus_name` (`cus_name`),
    KEY `state` (`state`),
    KEY `room_id` (`room_id`),
    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-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
room_number	varchar(64)		否		Unique Index
cus_id	int(11)		是
cus_name	varchar(64)		是
state	int(11)	0	是	0表示无人入住 1表示已有人入住 2房间非管理 3 其他使用		0
room_id	int(11)		否		Unique Index