MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_line_impr:/tablelist/okayapi_lvyou_jee_line_impr.html
-- MySQL Table okayapi_lvyou_jee_line_impr
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line_impr` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL COMMENT '',
`impr_id` varchar(100) NOT NULL COMMENT '',
`travel` int(11) NOT NULL COMMENT '',
`guide` int(11) NOT NULL COMMENT '',
`traffic` int(11) NOT NULL COMMENT '',
`room` int(11) NOT NULL COMMENT '',
`okayapi_lvyou_jee_line_impr_point` int(11) NOT NULL COMMENT '',
`content` varchar(100) NOT NULL COMMENT '',
`create_time` int(11) NOT NULL COMMENT '',
`okayapi_lvyou_jee_line_impr_status` int(11) NOT NULL COMMENT '',
KEY `order_id` (`order_id`),
KEY `impr_id` (`impr_id`),
KEY `travel` (`travel`),
KEY `guide` (`guide`),
KEY `traffic` (`traffic`),
KEY `room` (`room`),
KEY `okayapi_lvyou_jee_line_impr_point` (`okayapi_lvyou_jee_line_impr_point`),
KEY `content` (`content`),
KEY `create_time` (`create_time`),
KEY `okayapi_lvyou_jee_line_impr_status` (`okayapi_lvyou_jee_line_impr_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-路线impr';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-10 of 10 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
order_id | int(11) | 是 | ||||
impr_id | varchar(100) | 是 | ||||
travel | int(11) | 是 | ||||
guide | int(11) | 是 | ||||
traffic | int(11) | 是 | ||||
room | int(11) | 是 | ||||
okayapi_lvyou_jee_line_impr_point | int(11) | 是 | ||||
content | varchar(100) | 是 | ||||
create_time | int(11) | 是 | ||||
okayapi_lvyou_jee_line_impr_status | int(11) | 否 |