基于微信小程序+Java后端的社区养老服务毕业设计(源码+演示视频+说明+数据库).rar

/* SQLyog Ultimate v11.3 (64 bit) MySQL - 5.7.32-log : Database - ssmfr870 ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`ssmfr870` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `ssmfr870`; /*Table structure for table `chat` */ DROP TABLE IF EXISTS `chat`; CREATE TABLE `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id', `ask` longtext COMMENT '提问', `reply` longtext COMMENT '回复', `isreply` int(11) DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 COMMENT='在线客服'; /*Data for the table `chat` */ insert into `chat`(`id`,`addtime`,`userid`,`adminid`,`ask`,`reply`,`isreply`) values (191,'2021-04-01 20:21:21',1,1,'提问1','回复1',1),(192,'2021-04-01 20:21:21',2,2,'提问2','回复2',2),(193,'2021-04-01 20:21:21',3,3,'提问3','回复3',3),(194,'2021-04-01 20:21:21',4,4,'提问4','回复4',4),(195,'2021-04-01 20:21:21',5,5,'提问5','回复5',5),(196,'2021-04-01 20:21:21',6,6,'提问6','回复6',6); /*Table structure for table `chexiaotousu` */ DROP TABLE IF EXISTS `chexiaotousu`; CREATE TABLE `chexiaotousu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `nianling` varchar(200) DEFAULT NULL COMMENT '年龄', `shouji` varchar(200) DEFAULT NULL COMMENT '手机', `fuwumingcheng` varchar(200) DEFAULT NULL COMMENT '服务名称', `fuwuyuan` varchar(200) DEFAULT NULL COMMENT '服务员', `fuwushijian` varchar(200) DEFAULT NULL COMMENT '服务时间', `pingjia` longtext COMMENT '评价', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核', `shhf` longtext COMMENT '审核回复', `userid` bigint(20) DEFAULT NULL COMMENT '用户id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 COMMENT='撤销投诉'; /*Data for the table `chexiaotousu` */ insert into `chexiaotousu`(`id`,`addtime`,`zhanghao`,`xingming`,`nianling`,`shouji`,`fuwumingcheng`,`fuwuyuan`,`fuwushijian`,`pingjia`,`tupian`,`sfsh`,`shhf`,`userid`) values (181,'2021-04-01 20:21:21','账号1','姓名1','年龄1','手机1','服务名称1','服务员1','服务时间1','评价1','http://localhost:8080/ssmfr870/upload/chexiaotousu_tupian1.jpg','是','',1),(182,'2021-04-01 20:21:21','账号2','姓名2','年龄2','手机2','服务名称2','服务员2','服务时间2','评价2','http://localhost:8080/ssmfr870/upload/chexiaotousu_tupian2.jpg','是','',2),(183,'2021-04-01 20:21:21','账号3','姓名3','年龄3','手机3','服务名称3','服务员3','服务时间3','评价3','http://localhost:8080/ssmfr870/upload/chexiaotousu_tupian3.jpg','是','',3),(184,'2021-04-01 20:21:21','账号4','姓名4','年龄4','手机4','服务名称4','服务员4','服务时间4','评价4','http://localhost:8080/ssmfr870/upload/chexiaotousu_tupian4.jpg','是','',4),(185,'2021-04-01 20:21:21','账号5','姓名5','年龄5','手机5','服务名称5','服务员5','服务时间5','评价5','http://localhost:8080/ssmfr870/upload/chexiaotousu_tupian5.jpg','是','',5),(186,'2021-04-01 20:21:21','账号6','姓名6','年龄6','手机6','服务名称6','服务员6','服务时间6','评价6','http://localhost:8080/ssmfr870/upload/chexiaotousu_tupian6.jpg','是','',6); /*Table structure for table `config` */ DROP TABLE IF EXISTS `config`; 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=7 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*Data for the table `config` */ insert into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/ssmfr870/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssmfr870/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssmfr870/upload/picture3.jpg'),(6,'homepage',NULL); /*Table structure for table `daiwanchengfuwu` */ DROP TABLE IF EXISTS `daiwanchengfuwu`; CREATE TABLE `daiwanchengfuwu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `fuwumingcheng` varchar(200) DEFAULT NULL COMMENT '服务名称', `fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型', `yuyueshijian` varchar(200) DEFAULT NULL COMMENT '预约时间', `fuwuzhuangtai` varchar(200) DEFAULT NULL COMMENT '服务状态', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `userid` bigint(20) DEFAULT NULL COMMENT '用户id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1617279978883 DEFAULT CHARSET=utf8 COMMENT='待完成服务'; /*Data for the table `daiwanchengfuwu` */ insert into `daiwanchengfuwu`(`id`,`addtime`,`zhanghao`,`xingming`,`fuwumingcheng`,`fuwuleixing`,`yuyueshijian`,`fuwuzhuangtai`,`tupian`,`userid`) values (61,'2021-04-01 20:21:21','账号1','姓名1','服务名称1','服务类型1','预约时间1','待完成服务','http://localhost:8080/ssmfr870/upload/daiwanchengfuwu_tupian1.jpg',1),(62,'2021-04-01 20:21:21','账号2','姓名2','服务名称2','服务类型2','预约时间2','待完成服务','http://localhost:8080/ssmfr870/upload/daiwanchengfuwu_tupian2.jpg',2),(63,'2021-04-01 20:21:21','账号3','姓名3','服务名称3','服务类型3','预约时间3','待完成服务','http://localhost:8080/ssmfr870/upload/daiwanchengfuwu_tupian3.jpg',3),(64,'2021-04-01 20:21:21','账号4','姓名4','服务名称4','服务类型4','预约时间4','待完成服务','http://localhost:8080/ssmfr870/upload/daiwanchengfuwu_tupian4.jpg',4),(65,'2021-04-01 20:21:21','账号5','姓名5','服务名称5','服务类型5','预约时间5','待完成服务','http://localhost:8080/ssmfr870/upload/daiwanchengfuwu_tupian5.jpg',5),(66,'2021-04-01 20:21:21','账号6','姓名6','服务名称6','服务类型6','预约时间6','待完成服务','http://localhost:8080/ssmfr870/upload/daiwanchengfuwu_tupian6.jpg',6),(1617279967925,'2021-04-01 20:26:06','用户1','姓名1','服务名称1','医疗服务','2021-04-01 20:24:08','代办服务','http://localhost:8080/ssmfr870/upload/fuwuchanpin_tupian1.jpg',11),(1617279978882,'2021-04-01 20:26:18','用户1','姓名1','服务名称1','医疗服务','2021-04-01 20:24:08','待完成服务','http://localhost:8080/ssmfr870/upload/fuwuchanpin_tupian1.jpg',11); /*Table structure for table `discussfuwuchanpin` */ DROP TABLE IF EXISTS `discussfuwuchanpin`; CREATE TABLE `discussfuwuchanpin` ( `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', `nickname` varchar(200) DEFAULT NULL COMMENT '用户名', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO