okayapi_landi_room - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_landi_room：/tablelist/okayapi_landi_room.html


-- MySQL Table okayapi_landi_room
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_room` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `room_number` varchar(64) NULL COMMENT '',
    `okayapi_landi_room_type` varchar(64) NULL COMMENT '',
    `area` double NULL COMMENT '',
    `rent` int(11) NULL COMMENT '',
    `state` int(11) NULL COMMENT '',
    `comm` varchar(256) NULL COMMENT '',
    `owner_name` varchar(10) NULL COMMENT '',
    `receipt_time` datetime NULL COMMENT '接收时间',
    `refund_time` datetime NULL COMMENT '退还时间',
    `replace_room` varchar(64) NULL COMMENT '',
    KEY `room_number` (`room_number`),
    KEY `okayapi_landi_room_type` (`okayapi_landi_room_type`),
    KEY `area` (`area`),
    KEY `rent` (`rent`),
    KEY `state` (`state`),
    KEY `comm` (`comm`),
    KEY `owner_name` (`owner_name`),
    KEY `receipt_time` (`receipt_time`),
    KEY `refund_time` (`refund_time`),
    KEY `replace_room` (`replace_room`),
    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-10 of 10 results.

Field Name	Field Type	IS NULL	Field Comment	Index
room_number	varchar(64)	是		Unique Index
okayapi_landi_room_type	varchar(64)	是
area	double	是
rent	int(11)	是
state	int(11)	是
comm	varchar(256)	是
owner_name	varchar(10)	是
receipt_time	datetime	是	接收时间
refund_time	datetime	是	退还时间
replace_room	varchar(64)	是