okayapi_lvyou_jee_line_pic - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_line_pic：/tablelist/okayapi_lvyou_jee_line_pic.html


-- MySQL Table okayapi_lvyou_jee_line_pic
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line_pic` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `line_id` int(11) NULL COMMENT '',
    `okayapi_lvyou_jee_line_pic_names` varchar(100) NULL COMMENT '图片标题',
    `pic_path` varchar(100) NULL COMMENT '原图',
    `sort` int(11) NULL COMMENT '排序',
    `istitlepage` tinyint(1) NULL COMMENT '是否设置封面(1是2否)',
    KEY `line_id` (`line_id`),
    KEY `okayapi_lvyou_jee_line_pic_names` (`okayapi_lvyou_jee_line_pic_names`),
    KEY `pic_path` (`pic_path`),
    KEY `sort` (`sort`),
    KEY `istitlepage` (`istitlepage`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-路线图片';

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	IS NULL	Field Comment
line_id	int(11)	否
okayapi_lvyou_jee_line_pic_names	varchar(100)	是	图片标题
pic_path	varchar(100)	是	原图
sort	int(11)	是	排序
istitlepage	tinyint(1)	是	是否设置封面(1是2否)