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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_lvyou_jee_line_names | varchar(200) | 是 | ||||
okayapi_lvyou_jee_line_code | varchar(50) | 是 | ||||
seo_id | int(11) | 0 | 是 | 0 | ||
line_type | int(11) | 是 | ||||
trip_days | int(11) | 是 | ||||
traffic | varchar(100) | 是 | ||||
city_id | int(11) | 是 | ||||
target_type | int(11) | 是 | ||||
target_topic | varchar(50) | 是 | ||||
target | varchar(50) | 是 | ||||
topic | varchar(50) | 是 | ||||
deal_type | int(11) | 是 | ||||
compnay | varchar(50) | 是 | ||||
ly_type | varchar(50) | 是 | ||||
ps | varchar(255) | 是 | ||||
award | int(11) | 是 | ||||
front_money | int(11) | 是 | ||||
cmoney | int(11) | 是 | ||||
bonus_comm | int(11) | 是 | ||||
property | int(11) | 是 | ||||
sort | int(11) | 是 | ||||
okayapi_lvyou_jee_line_status | int(11) | 1 | 是 | 1 | ||
edit_model | int(11) | 1 | 是 | 编辑模式(1,按天,2,可视化) | 1 | |
hits | int(11) | 是 |