okayapi_lvyou_jee_line_info - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_line_info：/tablelist/okayapi_lvyou_jee_line_info.html


-- MySQL Table okayapi_lvyou_jee_line_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line_info` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `lid` int(11) NULL COMMENT '',
    `okayapi_lvyou_jee_line_info_General` text NULL COMMENT '可视化模式的行程安排',
    `special_info` text NULL COMMENT '',
    `order_info` text NULL COMMENT '',
    `tip` text NULL COMMENT '',
    `contain` text NULL COMMENT '包含费用',
    `notcontain` text NULL COMMENT '不包含费用',
    `selfpay` text NULL COMMENT '自费项目',
    KEY `lid` (`lid`),
    KEY `okayapi_lvyou_jee_line_info_General` (`okayapi_lvyou_jee_line_info_General`),
    KEY `special_info` (`special_info`),
    KEY `order_info` (`order_info`),
    KEY `tip` (`tip`),
    KEY `contain` (`contain`),
    KEY `notcontain` (`notcontain`),
    KEY `selfpay` (`selfpay`),
    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-8 of 8 results.

Field Name	Field Type	IS NULL	Field Comment
lid	int(11)	否
okayapi_lvyou_jee_line_info_General	text	是	可视化模式的行程安排
special_info	text	是
order_info	text	是
tip	text	是
contain	text	是	包含费用
notcontain	text	是	不包含费用
selfpay	text	是	自费项目