mysql分析问卷_问卷调查相关表

CREATE TABLE `tf_survey` (

`id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

`title` VARCHAR(255) NOT NULL COMMENT '标题',

`begin_time` INT(11) NULL COMMENT '开始时间',

`end_time` INT(11) NULL COMMENT '结束时间',

`create_time` INT(11) NOT NULL COMMENT '创建时间',

`is_publish` TINYINT(4) NOT NULL DEFAULT 0 COMMENT '状态 0未发布 1已发布',

`deleted` TINYINT(4) NOT NULL DEFAULT 0 COMMENT '0 正常 1删除',

PRIMARY KEY (`id`)

) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '问卷调查，发布之后不可编辑';

CREATE TABLE `tf_survey_question` (

`id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

`survey_id` INT(11) NOT NULL COMMENT '问卷id',

`subject` VARCHAR(255) NOT NULL