MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_line_travel_section:/tablelist/okayapi_lvyou_jee_line_travel_section.html
-- MySQL Table okayapi_lvyou_jee_line_travel_section
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line_travel_section` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`line_id` int(11) NULL COMMENT '',
`travel_id` int(11) NULL COMMENT '',
`okayapi_lvyou_jee_line_travel_section_names` int(11) NULL COMMENT '',
`title` varchar(255) NULL COMMENT '',
`content` text NULL COMMENT '',
KEY `line_id` (`line_id`),
KEY `travel_id` (`travel_id`),
KEY `okayapi_lvyou_jee_line_travel_section_names` (`okayapi_lvyou_jee_line_travel_section_names`),
KEY `title` (`title`),
KEY `content` (`content`),
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 | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
line_id | int(11) | 是 | ||||
travel_id | int(11) | 是 | ||||
okayapi_lvyou_jee_line_travel_section_names | int(11) | 是 | ||||
title | varchar(255) | 是 | ||||
content | text | 是 |