master

分支 (2)

管理

管理

master

dev

questionnaire-item-ssm
/
survey.sql

/*
Navicat MySQL Data Transfer

Source Server         : 云服务
Source Server Version : 50649
Source Host           : 101.37.28.148:3306
Source Database       : survey

Target Server Type    : MYSQL
Target Server Version : 50649
File Encoding         : 65001

Date: 2021-07-26 00:48:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tb_admin
-- ----------------------------
DROP TABLE IF EXISTS `tb_admin`;
CREATE TABLE `tb_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `remark` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2081 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tb_admin
-- ----------------------------
INSERT INTO `tb_admin` VALUES ('2073', 'admin', 'e3773fb273deb9ba62af8e4bfae96ef2', 'xx', '18533333333', '');
INSERT INTO `tb_admin` VALUES ('2077', 'xx', '433db2fa87c8e880868dcf6ae9c2fca2', 'xxx', '18555555555', 'xxxx');
INSERT INTO `tb_admin` VALUES ('2079', 'asdfasdf', '433db2fa87c8e880868dcf6ae9c2fca2', 'asdfasdfasdf', '18533333333', '');
INSERT INTO `tb_admin` VALUES ('2080', '111111111111111111111111111', '433db2fa87c8e880868dcf6ae9c2fca2', '111111111111111111111', '18533333333', '');

-- ----------------------------
-- Table structure for tb_answer_opt
-- ----------------------------
DROP TABLE IF EXISTS `tb_answer_opt`;
CREATE TABLE `tb_answer_opt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `survey_id` int(11) DEFAULT NULL,
  `question_id` int(11) DEFAULT NULL,
  `opt_id` int(11) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL COMMENT '1radio|2checkbox',
  `create_time` datetime DEFAULT NULL,
  `voter` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK_Reference_2` (`opt_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tb_answer_opt
-- ----------------------------
INSERT INTO `tb_answer_opt` VALUES ('57', '23', '4', '25', '1', '2020-12-01 14:51:52', '46dab48c-94d5-4776-b945-fe789f2d89f7');
INSERT INTO `tb_answer_opt` VALUES ('58', '23', '5', '33', '2', '2020-12-01 14:51:52', '46dab48c-94d5-4776-b945-fe789f2d89f7');
INSERT INTO `tb_answer_opt` VALUES ('59', '23', '5', '34', '2', '2020-12-01 14:51:53', '46dab48c-94d5-4776-b945-fe789f2d89f7');

-- ----------------------------
-- Table structure for tb_answer_txt
-- ----------------------------
DROP TABLE IF EXISTS `tb_answer_txt`;
CREATE TABLE `tb_answer_txt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `survey_id` int(11) DEFAULT NULL,
  `question_id` int(11) DEFAULT NULL,
  `result` varchar(200) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `voter` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tb_answer_txt
-- ----------------------------
INSERT INTO `tb_answer_txt` VALUES ('28', '23', '6', '一有空吗', '2020-12-01 14:51:53', '46dab48c-94d5-4776-b945-fe789f2d89f7');
INSERT INTO `tb_answer_txt` VALUES ('29', '23', '7', '雇佣兵环境保护', '2020-12-01 14:51:53', '46dab48c-94d5-4776-b945-fe789f2d89f7');

-- ----------------------------
-- Table structure for tb_question
-- ----------------------------
DROP TABLE IF EXISTS `tb_question`;
CREATE TABLE `tb_question` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '问题表ID',
  `title` varchar(200) DEFAULT NULL COMMENT '问题名称',
  `remark` varchar(200) DEFAULT NULL COMMENT '问题描述',
  `type` int(1) DEFAULT NULL COMMENT '题目类型（1.单行，2.多行，3.单行，4多行）',
  `required` int(1) DEFAULT NULL COMMENT '0非必填1必填',
  `check_style` varchar(50) DEFAULT NULL COMMENT '验证方式 text;number;date',
  `order_style` int(1) DEFAULT NULL COMMENT '0顺序1随机',
  `show_style` int(1) DEFAULT NULL COMMENT '1;2;3;4',
  `test` int(1) DEFAULT NULL COMMENT '0不测评1测评',
  `score` int(3) DEFAULT NULL COMMENT '评测分值',
  `orderby` int(11) DEFAULT NULL COMMENT '排序号',
  `creator` int(11) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `survey_id` int(11) DEFAULT NULL COMMENT '问卷ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK_Reference_1` (`survey_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tb_question
-- ----------------------------
INSERT INTO `tb_question` VALUES ('1', '标题撒旦法', '描述地方', '1', '1', null, null, null, '1', '5', null, null, '2020-11-24 19:30:16', '22');
INSERT INTO `tb_question` VALUES ('2', '标题撒旦法', '描述地方', '1', '1', null, null, null, '0', '0', null, null, '2020-11-25 14:39:27', '22');
INSERT INTO `tb_question` VALUES ('3', '标题第三方', '描述是大法官', '1', '1', null, null, null, '1', '5', null, null, '2020-11-26 13:02:26', '22');
INSERT INTO `tb_question` VALUES ('4', '第一题', '语文基础', '1', '1', null, null, null, '1', '2', null, null, '2020-11-28 14:47:26', '23');
INSERT INTO `tb_question` VALUES ('5', '数学多选题', '这个题意外的有多选', '2', '1', null, null, null, '1', '2', null, null, '2020-11-28 14:48:25', '23');
INSERT INTO `tb_question` VALUES ('6', '语文描述题', '对一个事物的描述', '3', '1', null, null, null, null, null, null, null, '2020-11-28 14:48:46', '23');
INSERT INTO `tb_question` VALUES ('7', '语文作文', '作文题目自定义，自我发挥', '4', '1', null, null, null, null, null, null, null, '2020-11-28 14:49:11', '23');

-- ----------------------------
-- Table structure for tb_question_opt
-- ----------------------------
DROP TABLE IF EXISTS `tb_question_opt`;
CREATE TABLE `tb_question_opt` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '问题选项表ID',
  `survey_id` int(11) DEFAULT NULL COMMENT '问卷ID',
  `question_id` int(11) DEFAULT NULL COMMENT '问题ID',
  `type` varchar(20) DEFAULT NULL COMMENT '问题类型（单选或多选）',
  `opt` varchar(200) DEFAULT NULL COMMENT '选项',
  `orderby` int(11) DEFAULT NULL COMMENT '排序号',
  `answer` int(1) DEFAULT NULL COMMENT '默认为NULL；1答案',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tb_question_opt
-- ----------------------------
INSERT INTO `tb_question_opt` VALUES ('25', '23', '4', '1', 'A........', '1', null);
INSERT INTO `tb_question_opt` VALUES ('26', '23', '4', '1', 'B........', '2', null);
INSERT INTO `tb_question_opt` VALUES ('27', '23', '4', '1', 'C........', '3', '1');
INSERT INTO `tb_question_opt` VALUES ('28', '23', '4', '1', 'D.......', '4', null);
INSERT INTO `tb_question_opt` VALUES ('33', '23', '5', '2', 'A.......', '1', null);
INSERT INTO `tb_question_opt` VALUES ('34', '23', '5', '2', 'B.......', '2', '1');
INSERT INTO `tb_question_opt` VALUES ('35', '23', '5', '2', 'C.......', '3', '1');
INSERT INTO `tb_question_opt` VALUES ('36', '23', '5', '2', 'D.......', '4', null);

-- ----------------------------
-- Table structure for tb_survey
-- ----------------------------
DROP TABLE IF EXISTS `tb_survey`;
CREATE TABLE `tb_survey` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `remark` varchar(200) DEFAULT NULL,
  `bounds` int(1) DEFAULT NULL COMMENT '0:不限制;1:限制',
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `rules` int(1) DEFAULT NULL COMMENT '0公开;1密码',
  `password` varchar(50) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL COMMENT '创建、执行中、结束',
  `logo` varchar(200) DEFAULT NULL,
  `bgimg` varchar(200) DEFAULT NULL,
  `anon` int(1) DEFAULT NULL COMMENT '0匿名；1不匿名',
  `creator` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tb_survey
-- ----------------------------
INSERT INTO `tb_survey` VALUES ('23', '第一份问卷', '这是我的第一份问卷', '0', '2020-11-26 16:00:00', '2020-12-30 16:00:00', '1', '123456789', 'http://localhost:8080/survey/diy/3e515ab7-0bf3-46ac-be13-4667eb1b3f8f', '结束', null, null, '0', '2073', '2020-11-28 14:46:16');