okayapi_lvyou_jee_line_que - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_line_que：/tablelist/okayapi_lvyou_jee_line_que.html


-- MySQL Table okayapi_lvyou_jee_line_que
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line_que` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `line_id` int(11) NULL COMMENT '',
    `user_id` int(11) NULL COMMENT '',
    `question1` varchar(600) NULL COMMENT '',
    `question2` varchar(1000) NULL COMMENT '',
    `answer` varchar(1600) NULL COMMENT '',
    `publish_time` int(11) NULL COMMENT '',
    `answer_time` int(11) NULL COMMENT '',
    `okayapi_lvyou_jee_line_que_status` smallint(2) NULL DEFAULT '1' COMMENT '',
    `sort` int(11) NULL COMMENT '',
    KEY `line_id` (`line_id`),
    KEY `user_id` (`user_id`),
    KEY `question1` (`question1`),
    KEY `question2` (`question2`),
    KEY `answer` (`answer`),
    KEY `publish_time` (`publish_time`),
    KEY `answer_time` (`answer_time`),
    KEY `okayapi_lvyou_jee_line_que_status` (`okayapi_lvyou_jee_line_que_status`),
    KEY `sort` (`sort`),
    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-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Demo Data
line_id	int(11)		否
user_id	int(11)		是
question1	varchar(600)		否
question2	varchar(1000)		是
answer	varchar(1600)		是
publish_time	int(11)		否
answer_time	int(11)		是
okayapi_lvyou_jee_line_que_status	smallint(2)	1	是	1
sort	int(11)		是