+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_line:/tablelist/okayapi_lvyou_jee_line.html


-- MySQL Table okayapi_lvyou_jee_line
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_lvyou_jee_line_names` varchar(200) NULL COMMENT '',
    `okayapi_lvyou_jee_line_code` varchar(50) NULL COMMENT '',
    `seo_id` int(11) NULL DEFAULT '0' COMMENT '',
    `line_type` int(11) NULL COMMENT '',
    `trip_days` int(11) NULL COMMENT '',
    `traffic` varchar(100) NULL COMMENT '',
    `city_id` int(11) NULL COMMENT '',
    `target_type` int(11) NULL COMMENT '',
    `target_topic` varchar(50) NULL COMMENT '',
    `target` varchar(50) NULL COMMENT '',
    `topic` varchar(50) NULL COMMENT '',
    `deal_type` int(11) NULL COMMENT '',
    `compnay` varchar(50) NULL COMMENT '',
    `ly_type` varchar(50) NULL COMMENT '',
    `ps` varchar(255) NULL COMMENT '',
    `award` int(11) NULL COMMENT '',
    `front_money` int(11) NULL COMMENT '',
    `cmoney` int(11) NULL COMMENT '',
    `bonus_comm` int(11) NULL COMMENT '',
    `property` int(11) NULL COMMENT '',
    `sort` int(11) NULL COMMENT '',
    `okayapi_lvyou_jee_line_status` int(11) NULL DEFAULT '1' COMMENT '',
    `edit_model` int(11) NULL DEFAULT '1' COMMENT '编辑模式(1,按天,2,可视化)',
    `hits` int(11) NULL COMMENT '',
    KEY `okayapi_lvyou_jee_line_names` (`okayapi_lvyou_jee_line_names`),
    KEY `okayapi_lvyou_jee_line_code` (`okayapi_lvyou_jee_line_code`),
    KEY `seo_id` (`seo_id`),
    KEY `line_type` (`line_type`),
    KEY `trip_days` (`trip_days`),
    KEY `traffic` (`traffic`),
    KEY `city_id` (`city_id`),
    KEY `target_type` (`target_type`),
    KEY `target_topic` (`target_topic`),
    KEY `target` (`target`),
    KEY `topic` (`topic`),
    KEY `deal_type` (`deal_type`),
    KEY `compnay` (`compnay`),
    KEY `ly_type` (`ly_type`),
    KEY `ps` (`ps`),
    KEY `award` (`award`),
    KEY `front_money` (`front_money`),
    KEY `cmoney` (`cmoney`),
    KEY `bonus_comm` (`bonus_comm`),
    KEY `property` (`property`),
    KEY `sort` (`sort`),
    KEY `okayapi_lvyou_jee_line_status` (`okayapi_lvyou_jee_line_status`),
    KEY `edit_model` (`edit_model`),
    KEY `hits` (`hits`),
    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-24 of 24 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_lvyou_jee_line_namesvarchar(200)
okayapi_lvyou_jee_line_codevarchar(50)
seo_idint(11)00
line_typeint(11)
trip_daysint(11)
trafficvarchar(100)
city_idint(11)
target_typeint(11)
target_topicvarchar(50)
targetvarchar(50)
topicvarchar(50)
deal_typeint(11)
compnayvarchar(50)
ly_typevarchar(50)
psvarchar(255)
awardint(11)
front_moneyint(11)
cmoneyint(11)
bonus_commint(11)
propertyint(11)
sortint(11)
okayapi_lvyou_jee_line_statusint(11)11
edit_modelint(11)1编辑模式(1,按天,2,可视化)1
hitsint(11)

Guess You Like

MySQL Table Design okayapi_opentrip_travel_admin

MySQL Table Design okayapi_opentrip_travel_category

MySQL Table Design okayapi_opentrip_travel_order

MySQL Table Design okayapi_opentrip_travel_product

MySQL Table Design okayapi_opentrip_travel_shopcart

MySQL Table Design okayapi_opentrip_travel_user

MySQL Table Design okayapi_travel_agents

MySQL Table Design okayapi_travel_agent_users

MySQL Table Design okayapi_travel_categories

MySQL Table Design okayapi_travel_depots

MySQL Table Design okayapi_travel_depot_annuals

MySQL Table Design okayapi_travel_depot_logs

MySQL Table Design okayapi_travel_depot_staffs

MySQL Table Design okayapi_travel_depot_vouchers

MySQL Table Design okayapi_travel_devices

MySQL Table Design okayapi_travel_exist_statistics

MySQL Table Design okayapi_travel_features

MySQL Table Design okayapi_travel_groups

MySQL Table Design okayapi_travel_orders

MySQL Table Design okayapi_travel_staff_exchanges

TOP ↑