okayapi_landi_room_pic - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_landi_room_pic：/tablelist/okayapi_landi_room_pic.html


-- MySQL Table okayapi_landi_room_pic
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_room_pic` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `room_id` int(11) NULL COMMENT '',
    `okayapi_landi_room_pic_type` int(10) NULL COMMENT '',
    `ctime` date NULL COMMENT '',
    `okayapi_landi_room_pic_name` varchar(64) NULL COMMENT '',
    `tag` varchar(64) NULL COMMENT '',
    `path` varchar(256) NULL COMMENT '',
    KEY `room_id` (`room_id`),
    KEY `okayapi_landi_room_pic_type` (`okayapi_landi_room_pic_type`),
    KEY `ctime` (`ctime`),
    KEY `okayapi_landi_room_pic_name` (`okayapi_landi_room_pic_name`),
    KEY `tag` (`tag`),
    KEY `path` (`path`),
    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-6 of 6 results.

Field Name	Field Type	IS NULL	Index
room_id	int(11)	是	Normal Index
okayapi_landi_room_pic_type	int(10)	是
ctime	date	是
okayapi_landi_room_pic_name	varchar(64)	是
tag	varchar(64)	是
path	varchar(256)	是