安卓框架：uniapp 安卓开发软件：HBuilder X 开发模式：混合开发
后台： 开发语言：Java 框架：springboot JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器
DROP TABLE IF EXISTS config;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE config (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
name varchar(100) NOT NULL COMMENT '配置参数名称',
value varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table config
--
LOCK TABLES config WRITE;
/*!40000 ALTER TABLE config DISABLE KEYS /;
INSERT INTO config VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/!40000 ALTER TABLE config ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table discusszixunshi
--
DROP TABLE IF EXISTS discusszixunshi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE discusszixunshi (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
refid bigint(20) NOT NULL COMMENT '关联表id',
userid bigint(20) NOT NULL COMMENT '用户id',
avatarurl longtext COMMENT '头像',
nickname varchar(200) DEFAULT NULL COMMENT '用户名',
content longtext NOT NULL COMMENT '评论内容',
reply longtext COMMENT '回复内容',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='咨询师评论表';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table discusszixunshi
--
LOCK TABLES discusszixunshi WRITE;
/*!40000 ALTER TABLE discusszixunshi DISABLE KEYS /;
/!40000 ALTER TABLE discusszixunshi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table exampaper
--
DROP TABLE IF EXISTS exampaper;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE exampaper (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
name varchar(200) NOT NULL COMMENT '心理测试名称',
time int(11) NOT NULL COMMENT '测试时长(分钟)',
status int(11) NOT NULL DEFAULT '0' COMMENT '心理测试状态',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='心理测试表';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table exampaper
--
LOCK TABLES exampaper WRITE;
/*!40000 ALTER TABLE exampaper DISABLE KEYS /;
INSERT INTO exampaper VALUES (1,'2023-04-14 00:05:01','十万个为什么',60,1);
/!40000 ALTER TABLE exampaper ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table examquestion
--
DROP TABLE IF EXISTS examquestion;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE examquestion (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
paperid bigint(20) NOT NULL COMMENT '所属心理测试id（外键）',
papername varchar(200) NOT NULL COMMENT '心理测试名称',
questionname varchar(200) NOT NULL COMMENT '试题名称',
options longtext COMMENT '选项，json字符串',
score bigint(20) DEFAULT '0' COMMENT '分值',
answer varchar(200) DEFAULT NULL COMMENT '正确答案',
analysis longtext COMMENT '答案解析',
type bigint(20) DEFAULT '0' COMMENT '试题类型，0：单选题 1：多选题 2：判断题 3：填空题（暂不考虑多项填空）',
sequence bigint(20) DEFAULT '100' COMMENT '试题排序，值越大排越前面',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='试题表';
/!40101 SET character_set_client = @saved_cs_client */;
