💗博主介绍:✌全网粉丝10W+,CSDN全栈领域优质创作者,博客之星、掘金/知乎/b站/华为云/阿里云等平台优质作者、专注于Java、小程序/APP、python、大数据等技术领域和毕业项目实战,以及程序定制化开发、文档编写、答疑辅导等。
👇🏻 精彩专栏 推荐订阅👇🏻
计算机毕业设计精品项目案例(持续更新)
🌟文末获取源码+数据库+文档🌟
感兴趣的可以先收藏起来,还有大家在毕设选题,项目以及论文编写等相关问题都可以和学长沟通,希望帮助更多的人
一.前言
随着人口老龄化现象日益加剧,社区养老成为公众、政府和社会各界关注的焦点。传统的养老服务模式无法满足日益增长的个性化、多样化需求,迫切需要信息化技术的支撑以提升服务质量和效率。本系统的开发正是为了解决这一社会需求,通过构建一个智慧养老服务平台,利用先进的信息技术改善养老服务流程,为老年人提供便捷、周到的服务,同时为福利机构和社区管理者提供高效的管理工具。此外,系统的使用能够促进资源的优化配置,提高服务透明度,增强用户体验,从而推动社区养老服务的整体水平提升。
本系统采用了Spring Boot作为后端开发框架,结合Vue前端框架和微信小程序平台,通过MyBatis持久层框架与MySQL数据库进行数据交互,使用Axios作为HTTP客户端执行异步请求,构建一个响应迅速且用户体验良好的社区养老服务系统。在实现上,该系统完成了用户管理、养老服务管理、订单管理、知识库管理、求救信息管理以及健康档案管理等关键业务功能,满足用户从寻求帮助、接受服务到健康监护的全方位需求。
该系统的实施和运营有效解决了社区养老服务的痛点问题:优化了资源分配,减少了服务过程中的信息不对称和运行不透明现象;强化了服务跟踪和反馈机制,提高了服务的个性化水平;简化了服务流程,为老年用户提供了简洁直观的操作界面,显著提高了用户便捷性和满意度。总之,系统的部署不仅提高了养老服务的质量和效率,同时也展现了技术对社会服务领域的积极影响力。
二.技术环境
jdk版本:1.8 及以上
ide工具:Eclipse或者 IDEA,微信小程序开发工具
数据库: mysql5.7 (必须5.7)
编程语言: Java
java框架:SpringBoot
maven: 3.6.1
详细技术:HTML+CSS+JAVA+SpringBoot+MYSQL+VUE+MAVEN+微信开发工具
三.功能设计
系统将分为用户和管理员两种角色,具体功能设计如下所示:
(一)用户模块功能
1.服务预订模块:提供护理服务、康复服务、餐饮服务等的预订功能,用户可以根据自己的需求选择合适的服务项目和时间。
2.健康管理模块:包括健康档案、健康咨询等功能,用户可以实时关注自己的健康状况,并得到专业的健康指导。
3.社交互动模块:用户可以通过小程序与其他用户进行交流、分享经验,也可以参加社区组织的活动,增强社交互动。
4.在线购物模块:提供生活用品、医疗器械等商品的在线购买服务,方便用户购买所需物品。
5.知识库模块:包含各类养老知识、健康资讯等内容,用户可以随时学习和了解相关信息。
6.定位服务模块:用户可以通过定位功能查找附近的养老服务机构、医疗机构等,方便及时获取服务。
7.紧急救援模块:设置紧急联系人,在遇到紧急情况时,用户可以一键发送求救信息。
8.意见反馈模块:用户可以向平台反馈意见和建议,帮助平台不断改进和完善服务。
(二)管理员模块功能
1.用户管理:包括用户注册、登录、信息修改、密码重置等功能,以及对用户角色和权限的管理。
2.服务管理:对小程序提供的各种养老服务进行管理,包括添加、修改、删除服务项目,设定服务价格、服务时间等。
3.预订管理:处理用户的服务预订请求,包括查看预订记录、确认预订、取消预订等。
4.健康管理:管理用户的健康档案,包括记录用户的健康指标、医疗记录等。
5.社交管理:管理小程序内的社交互动,包括用户之间的私信、评论、点赞等。
6.在线购物管理:管理小程序内的商品购买订单功能,包括商品添加、修改、删除,处理订单、退款等。
7.知识库管理:管理小程序的养老知识库内容,包括添加、修改、删除文章、问答等。
8.紧急救援管理:管理小程序的紧急救援功能,包括设置紧急联系人、发送求救信号等。
9.意见反馈管理:处理用户对小程序的意见和建议,及时回复并进行改进。
10.数据统计分析:对小程序的使用数据进行统计和分析,了解用户行为和需求,为决策提供数据支持。
用户模块需要能够进行如下操作:意见反馈管理、社区互动管理、购物管理等。用户模块用例图如图 所示。
管理员是本系统权限最高的用户类型,管理员需要进行的操作包括养老服务管理、服务管理、在线购物管理等,管理员模块用例图如图所示。
程序上交给用户进行使用时,需要提供程序的操作流程图,这样便于用户容易理解程序的具体工作步骤,现如今程序的操作流程都有一个大致的标准,即先通过登录页面提交登录数据,通过程序验证正确之后,用户才能在程序功能操作区页面操作对应的功能。
四.数据设计
数据库概念模型的设计是为了抽象真实世界的信息,并对信息世界进行建模。它是数据库设计的强大工具。数据库概念模型设计可以通过E-R图描述现实世界的概念模型。而且Mysql数据库是自我保护能力比较强的数据库,限于篇幅要求,仅列出关键部分实体属性图和E-R图,如下所述。
系统总体E-R图如下所示:
五.部分效果展示
5.1用户微信端功能实现效果
当用户打开微信小程序的网址后,首先看到的就是微信小程序首页界面。在这里,用户能够看到微信小程序社区养老一站式服务系统的导航条显示首页、意见反馈、社区互动、我的等,如图所示。
登录界面,首先双击打开微信小程序端系统,连上网络之后会显示出本系统的登录界面,这是进入小程序的第初始页面“登录”,能成功进入到该登录界面则代表小程序的开启是成功的,接下来就可以操作本系统所带有的其他所有的功能,如图所示。
用户击养老服务,在养老服务列表页面可输入服务名称、服务类型进行查询,并可以查看详情的养老服务信息,进行在线预约服务操作。如图所示。
用户点击在线购物,在在线购物列表页面可输入商品名称、商品类型进行查询,并可以查看详细的商品信息,进行在线购买、点赞、收藏、评论等操作。如图所示。
用户点击在知识库,在知识库列表页面可输入知识名称、知识类型进行查询,并可以查看知识具体内容,进行在线播放知识视频、点赞、收藏、评论等操作。如图所示。
在我的功能界面,用户点击“我的”进入我的页面,在我的页面可以对服务预约、取消预约、商品订单、退款申请、紧急联系人、求救信息、健康档案、我的收藏、健康咨询、我的发帖等进行详细操作,如图所示。
5.2管理员服务端功能实现效果
管理员的登陆界面包括管理员的账号、密码,其中就是已有的账号,还有需要注册的账号。只要管理员在账号上注册,注册信息就会被录入 MySQL数据库,有一个资料库,只要输入成功,就可以登陆,然后进入主页的管理。管理员登录界面如图所示。
管理员进入主页面,主要功能包括对系统首页、用户管理、养老服务管理、服务类型管理、服务预约管理、取消服务管理、在线购物管理、商品类型管理、商品订单管理、退款申请管理、知识库管理、知识分类管理、定位服务、紧急联系人管理等进行操作。管理员主页面如图所示:
实现服务预约管理模块时,为确保系统能够有效展示与用户角色相关联的信息并能够处理大量的预约数据,我们面临几个关键问题。首先是如何根据不同用户角色显示相应的服务预约信息,解决这一问题的方法是在后端接口中加以判断用户的角色,并据此过滤信息,确保用户只能看到对他们角色相关的数据。其次是优化信息的查询和统计,对此应用了后端接口的聚合函数,以高效地按条件进行数据统计,并把结果传递给前端。面对批量审核的需求,通过在后端接口中实现一个允许传递多个预约ID和审核状态的方法,使管理员能够进行批量操作。采用这些方法不仅优化了用户体验,保证了信息安全,还提高了操作效率和数据处理的准确性。
在线购物管理模块的设计涵盖了产品信息的展现、管理以及用户交互操作三个核心领域,确保了管理员能够高效管理商品并提供用户友好的购物体验。数据查询与展示机制采用了后端接口提供数据,前端通过动态参数筛选和排序以呈现商品列表和详情,这种模式使页面加载更快,用户交互更流畅,同时方便扩展其他筛选和排序功能。为了实现对商品的增删改查操作,开发了专门的接口,这些接口直接与数据库进行交互,确保数据的准确性和安全性。用户的点赞和踩的投票行为通过即时更新点赞数和踩数的方式加以体现,以获得用户对商品偏好的即时反馈。智能排序功能则是通过调用排序参数,利用Map的数据结构执行高效的降序排序,以实现产品点击率高的产品优先展示的需求,促进产品的曝光率和购买概率。这些机制相互配合,不仅提高了管理员效率,也增强了用户体验,并为平台带来了潜在的商业价值。
在实现知识库管理模块的功能时,我们面临了多项设计和技术选择问题,包括知识库信息的展示、详情查看、评价系统(点赞或踩)、信息的新增与更新以及删除操作。要解决这些问题,选用了Springboot和Mybatis作为后端开发框架,利用其简洁的编码和强大的数据库交互功能。前端采用Vue框架和Axios库不仅因其易于集成和高效更新DOM的特点,而且提高了开发效率和页面响应速度。这些技术的组合优化了数据处理的流畅性和用户界面的交互体验,通过MVC设计模式将业务逻辑、数据和显示分离,旨在提供可维护性高和扩展性好的管理平台。
为了实现健康档案管理模块的高效与安全的信息管理功能,开发团队在设计和实施过程中均考虑了多个核心问题,包括前后端的协同工作、数据的安全传输及处理效率。解决这些问题的策略为:采用Vue框架构建前端,提升用户界面的交互性和响应速度;使用Springboot构建后端服务,简化企业应用开发和微服务架构;以Mybatis作为持久层框架,对数据库操作进行更加灵活的映射与管理;并通过Axios用于前后端的数据交互,确保数据的异步传输同时在安全性方面进行了SSL加密等措施。这种设计之所以被采纳,是因为它能够将现代Web应用中关键的组件协同起来,确保整个系统结构的清晰、安全和高效。
部分功能代码
/**
* 上传文件
*/
@RequestMapping("/upload")
@IgnoreAuth
public R upload(@RequestParam("file") MultipartFile file,String type) throws Exception {
if (file.isEmpty()) {
throw new EIException("上传文件不能为空");
}
String fileExt = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf(".")+1);
File path = new File(ResourceUtils.getURL("classpath:static").getPath());
if(!path.exists()) {
path = new File("");
}
File upload = new File(path.getAbsolutePath(),"/upload/");
if(!upload.exists()) {
upload.mkdirs();
}
String fileName = new Date().getTime()+"."+fileExt;
if(StringUtils.isNotBlank(type) && type.contains("_template")) {
fileName = type + "."+fileExt;
new File(upload.getAbsolutePath()+"/"+fileName).deleteOnExit();
}
File dest = new File(upload.getAbsolutePath()+"/"+fileName);
file.transferTo(dest);
if(StringUtils.isNotBlank(type) && type.equals("1")) {
ConfigEntity configEntity = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "faceFile"));
if(configEntity==null) {
configEntity = new ConfigEntity();
configEntity.setName("faceFile");
configEntity.setValue(fileName);
} else {
configEntity.setValue(fileName);
}
configService.insertOrUpdate(configEntity);
}
return R.ok().put("file", fileName);
}
/**
* 登录
*/
@IgnoreAuth
@RequestMapping(value = "/login")
public R login(String username, String password, String captcha, HttpServletRequest request) {
UsersEntity user = userService.selectOne(new EntityWrapper<UsersEntity>().eq("username", username));
if(user==null || !user.getPassword().equals(password)) {
return R.error("账号或密码不正确");
}
String token = tokenService.generateToken(user.getId(),username, "users", user.getRole());
return R.ok().put("token", token);
}
/**
* 注册
*/
@IgnoreAuth
@PostMapping(value = "/register")
public R register(@RequestBody UsersEntity user){
// ValidatorUtils.validateEntity(user);
if(userService.selectOne(new EntityWrapper<UsersEntity>().eq("username", user.getUsername())) !=null) {
return R.error("用户已存在");
}
userService.insert(user);
return R.ok();
}
数据库参考
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: springbootbi7prq19
-- ------------------------------------------------------
-- Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Current Database: `springbootbi7prq19`
--
/*!40000 DROP DATABASE IF EXISTS `springbootbi7prq19`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbootbi7prq19` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `springbootbi7prq19`;
--
-- Table structure for table `chat`
--
DROP TABLE IF EXISTS `chat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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=179 DEFAULT CHARSET=utf8 COMMENT='健康咨询';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat`
--
LOCK TABLES `chat` WRITE;
/*!40000 ALTER TABLE `chat` DISABLE KEYS */;
INSERT INTO `chat` VALUES (171,'2024-04-05 03:23:52',1,1,'提问1','回复1',1),(172,'2024-04-05 03:23:52',2,2,'提问2','回复2',2),(173,'2024-04-05 03:23:52',3,3,'提问3','回复3',3),(174,'2024-04-05 03:23:52',4,4,'提问4','回复4',4),(175,'2024-04-05 03:23:52',5,5,'提问5','回复5',5),(176,'2024-04-05 03:23:52',6,6,'提问6','回复6',6),(177,'2024-04-05 03:23:52',7,7,'提问7','回复7',7),(178,'2024-04-05 03:23:52',8,8,'提问8','回复8',8);
/*!40000 ALTER TABLE `chat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
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 '配置参数值',
`url` varchar(500) DEFAULT NULL COMMENT 'url',
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',NULL),(2,'picture2','upload/picture2.jpg',NULL),(3,'picture3','upload/picture3.jpg',NULL);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dingweifuwu`
--
DROP TABLE IF EXISTS `dingweifuwu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dingweifuwu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jigoumingcheng` varchar(200) DEFAULT NULL COMMENT '机构名称',
`jigouleixing` varchar(200) DEFAULT NULL COMMENT '机构类型',
`jigouguimo` varchar(200) DEFAULT NULL COMMENT '机构规模',
`jigoujieshao` longtext COMMENT '机构介绍',
`jigoutupian` longtext COMMENT '机构图片',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
`longitude` double DEFAULT NULL COMMENT '经度',
`latitude` double DEFAULT NULL COMMENT '纬度',
`fulladdress` varchar(200) DEFAULT NULL COMMENT '地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='定位服务';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dingweifuwu`
--
LOCK TABLES `dingweifuwu` WRITE;
/*!40000 ALTER TABLE `dingweifuwu` DISABLE KEYS */;
INSERT INTO `dingweifuwu` VALUES (121,'2024-04-05 03:23:52','机构名称1','机构类型1','机构规模1','机构介绍1','upload/dingweifuwu_jigoutupian1.jpg,upload/dingweifuwu_jigoutupian2.jpg,upload/dingweifuwu_jigoutupian3.jpg',1,1,1,'宇宙银河系地球1号'),(122,'2024-04-05 03:23:52','机构名称2','机构类型2','机构规模2','机构介绍2','upload/dingweifuwu_jigoutupian2.jpg,upload/dingweifuwu_jigoutupian3.jpg,upload/dingweifuwu_jigoutupian4.jpg',2,2,2,'宇宙银河系地球2号'),(123,'2024-04-05 03:23:52','机构名称3','机构类型3','机构规模3','机构介绍3','upload/dingweifuwu_jigoutupian3.jpg,upload/dingweifuwu_jigoutupian4.jpg,upload/dingweifuwu_jigoutupian5.jpg',3,3,3,'宇宙银河系地球3号'),(124,'2024-04-05 03:23:52','机构名称4','机构类型4','机构规模4','机构介绍4','upload/dingweifuwu_jigoutupian4.jpg,upload/dingweifuwu_jigoutupian5.jpg,upload/dingweifuwu_jigoutupian6.jpg',4,4,4,'宇宙银河系地球4号'),(125,'2024-04-05 03:23:52','机构名称5','机构类型5','机构规模5','机构介绍5','upload/dingweifuwu_jigoutupian5.jpg,upload/dingweifuwu_jigoutupian6.jpg,upload/dingweifuwu_jigoutupian7.jpg',5,5,5,'宇宙银河系地球5号'),(126,'2024-04-05 03:23:52','机构名称6','机构类型6','机构规模6','机构介绍6','upload/dingweifuwu_jigoutupian6.jpg,upload/dingweifuwu_jigoutupian7.jpg,upload/dingweifuwu_jigoutupian8.jpg',6,6,6,'宇宙银河系地球6号'),(127,'2024-04-05 03:23:52','机构名称7','机构类型7','机构规模7','机构介绍7','upload/dingweifuwu_jigoutupian7.jpg,upload/dingweifuwu_jigoutupian8.jpg,upload/dingweifuwu_jigoutupian9.jpg',7,7,7,'宇宙银河系地球7号'),(128,'2024-04-05 03:23:52','机构名称8','机构类型8','机构规模8','机构介绍8','upload/dingweifuwu_jigoutupian8.jpg,upload/dingweifuwu_jigoutupian9.jpg,upload/dingweifuwu_jigoutupian10.jpg',8,8,8,'宇宙银河系地球8号');
/*!40000 ALTER TABLE `dingweifuwu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusszaixiangouwu`
--
DROP TABLE IF EXISTS `discusszaixiangouwu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusszaixiangouwu` (
`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 `discusszaixiangouwu`
--
LOCK TABLES `discusszaixiangouwu` WRITE;
/*!40000 ALTER TABLE `discusszaixiangouwu` DISABLE KEYS */;
/*!40000 ALTER TABLE `discusszaixiangouwu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusszhishiku`
--
DROP TABLE IF EXISTS `discusszhishiku`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusszhishiku` (
`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 `discusszhishiku`
--
LOCK TABLES `discusszhishiku` WRITE;
/*!40000 ALTER TABLE `discusszhishiku` DISABLE KEYS */;
/*!40000 ALTER TABLE `discusszhishiku` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forum`
--
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
`content` longtext NOT NULL COMMENT '帖子内容',
`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`avatarurl` longtext COMMENT '头像',
`isdone` varchar(200) DEFAULT NULL COMMENT '状态',
`istop` int(11) DEFAULT '0' COMMENT '是否置顶',
`toptime` datetime DEFAULT NULL COMMENT '置顶时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8 COMMENT='社区互动';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forum`
--
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (181,'2024-04-05 03:23:52','帖子标题1','帖子内容1',0,1,'用户名1','upload/forum_avatarurl1.jpg,upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg','开放',0,'2024-04-05 11:23:52'),(182,'2024-04-05 03:23:52','帖子标题2','帖子内容2',0,2,'用户名2','upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg','开放',0,'2024-04-05 11:23:52'),(183,'2024-04-05 03:23:52','帖子标题3','帖子内容3',0,3,'用户名3','upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg','开放',0,'2024-04-05 11:23:52'),(184,'2024-04-05 03:23:52','帖子标题4','帖子内容4',0,4,'用户名4','upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg','开放',0,'2024-04-05 11:23:52'),(185,'2024-04-05 03:23:52','帖子标题5','帖子内容5',0,5,'用户名5','upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg','开放',0,'2024-04-05 11:23:52'),(186,'2024-04-05 03:23:52','帖子标题6','帖子内容6',0,6,'用户名6','upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg','开放',0,'2024-04-05 11:23:52'),(187,'2024-04-05 03:23:52','帖子标题7','帖子内容7',0,7,'用户名7','upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg','开放',0,'2024-04-05 11:23:52'),(188,'2024-04-05 03:23:52','帖子标题8','帖子内容8',0,8,'用户名8','upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg,upload/forum_avatarurl10.jpg','开放',0,'2024-04-05 11:23:52');
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwuleixing`
--
DROP TABLE IF EXISTS `fuwuleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwuleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='服务类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwuleixing`
--
LOCK TABLES `fuwuleixing` WRITE;
/*!40000 ALTER TABLE `fuwuleixing` DISABLE KEYS */;
INSERT INTO `fuwuleixing` VALUES (31,'2024-04-05 03:23:52','服务类型1'),(32,'2024-04-05 03:23:52','服务类型2'),(33,'2024-04-05 03:23:52','服务类型3'),(34,'2024-04-05 03:23:52','服务类型4'),(35,'2024-04-05 03:23:52','服务类型5'),(36,'2024-04-05 03:23:52','服务类型6'),(37,'2024-04-05 03:23:52','服务类型7'),(38,'2024-04-05 03:23:52','服务类型8');
/*!40000 ALTER TABLE `fuwuleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwuyuyue`
--
DROP TABLE IF EXISTS `fuwuyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwuyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`fuwumingcheng` varchar(200) DEFAULT NULL COMMENT '服务名称',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`fuwujiage` int(11) DEFAULT NULL COMMENT '服务价格',
`fuwutupian` longtext COMMENT '服务图片',
`yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',
`yuyuebeizhu` varchar(200) DEFAULT NULL COMMENT '预约备注',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
`zhuzhi` varchar(200) DEFAULT NULL COMMENT '住址',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='服务预约';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwuyuyue`
--
LOCK TABLES `fuwuyuyue` WRITE;
/*!40000 ALTER TABLE `fuwuyuyue` DISABLE KEYS */;
INSERT INTO `fuwuyuyue` VALUES (41,'2024-04-05 03:23:52','1111111111','服务名称1','服务类型1',1,'upload/fuwuyuyue_fuwutupian1.jpg,upload/fuwuyuyue_fuwutupian2.jpg,upload/fuwuyuyue_fuwutupian3.jpg','2024-04-05 11:23:52','预约备注1','用户账号1','用户姓名1','13823888881','住址1','是','','未支付'),(42,'2024-04-05 03:23:52','2222222222','服务名称2','服务类型2',2,'upload/fuwuyuyue_fuwutupian2.jpg,upload/fuwuyuyue_fuwutupian3.jpg,upload/fuwuyuyue_fuwutupian4.jpg','2024-04-05 11:23:52','预约备注2','用户账号2','用户姓名2','13823888882','住址2','是','','未支付'),(43,'2024-04-05 03:23:52','3333333333','服务名称3','服务类型3',3,'upload/fuwuyuyue_fuwutupian3.jpg,upload/fuwuyuyue_fuwutupian4.jpg,upload/fuwuyuyue_fuwutupian5.jpg','2024-04-05 11:23:52','预约备注3','用户账号3','用户姓名3','13823888883','住址3','是','','未支付'),(44,'2024-04-05 03:23:52','4444444444','服务名称4','服务类型4',4,'upload/fuwuyuyue_fuwutupian4.jpg,upload/fuwuyuyue_fuwutupian5.jpg,upload/fuwuyuyue_fuwutupian6.jpg','2024-04-05 11:23:52','预约备注4','用户账号4','用户姓名4','13823888884','住址4','是','','未支付'),(45,'2024-04-05 03:23:52','5555555555','服务名称5','服务类型5',5,'upload/fuwuyuyue_fuwutupian5.jpg,upload/fuwuyuyue_fuwutupian6.jpg,upload/fuwuyuyue_fuwutupian7.jpg','2024-04-05 11:23:52','预约备注5','用户账号5','用户姓名5','13823888885','住址5','是','','未支付'),(46,'2024-04-05 03:23:52','6666666666','服务名称6','服务类型6',6,'upload/fuwuyuyue_fuwutupian6.jpg,upload/fuwuyuyue_fuwutupian7.jpg,upload/fuwuyuyue_fuwutupian8.jpg','2024-04-05 11:23:52','预约备注6','用户账号6','用户姓名6','13823888886','住址6','是','','未支付'),(47,'2024-04-05 03:23:52','7777777777','服务名称7','服务类型7',7,'upload/fuwuyuyue_fuwutupian7.jpg,upload/fuwuyuyue_fuwutupian8.jpg,upload/fuwuyuyue_fuwutupian9.jpg','2024-04-05 11:23:52','预约备注7','用户账号7','用户姓名7','13823888887','住址7','是','','未支付'),(48,'2024-04-05 03:23:52','8888888888','服务名称8','服务类型8',8,'upload/fuwuyuyue_fuwutupian8.jpg,upload/fuwuyuyue_fuwutupian9.jpg,upload/fuwuyuyue_fuwutupian10.jpg','2024-04-05 11:23:52','预约备注8','用户账号8','用户姓名8','13823888888','住址8','是','','未支付');
/*!40000 ALTER TABLE `fuwuyuyue` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiankangdangan`
--
DROP TABLE IF EXISTS `jiankangdangan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiankangdangan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`touxiang` longtext COMMENT '头像',
`jibingmingcheng` varchar(200) DEFAULT NULL COMMENT '疾病名称',
`jiuzhenshijian` date DEFAULT NULL COMMENT '就诊时间',
`zhenduanjieguo` longtext COMMENT '诊断结果',
`zhiliaofangan` longtext COMMENT '治疗方案',
`yongyaojilu` longtext COMMENT '用药记录',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8 COMMENT='健康档案';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiankangdangan`
--
LOCK TABLES `jiankangdangan` WRITE;
/*!40000 ALTER TABLE `jiankangdangan` DISABLE KEYS */;
INSERT INTO `jiankangdangan` VALUES (161,'2024-04-05 03:23:52','用户账号1','用户姓名1','性别1','upload/jiankangdangan_touxiang1.jpg,upload/jiankangdangan_touxiang2.jpg,upload/jiankangdangan_touxiang3.jpg','疾病名称1','2024-04-05','诊断结果1','治疗方案1','用药记录1'),(162,'2024-04-05 03:23:52','用户账号2','用户姓名2','性别2','upload/jiankangdangan_touxiang2.jpg,upload/jiankangdangan_touxiang3.jpg,upload/jiankangdangan_touxiang4.jpg','疾病名称2','2024-04-05','诊断结果2','治疗方案2','用药记录2'),(163,'2024-04-05 03:23:52','用户账号3','用户姓名3','性别3','upload/jiankangdangan_touxiang3.jpg,upload/jiankangdangan_touxiang4.jpg,upload/jiankangdangan_touxiang5.jpg','疾病名称3','2024-04-05','诊断结果3','治疗方案3','用药记录3'),(164,'2024-04-05 03:23:52','用户账号4','用户姓名4','性别4','upload/jiankangdangan_touxiang4.jpg,upload/jiankangdangan_touxiang5.jpg,upload/jiankangdangan_touxiang6.jpg','疾病名称4','2024-04-05','诊断结果4','治疗方案4','用药记录4'),(165,'2024-04-05 03:23:52','用户账号5','用户姓名5','性别5','upload/jiankangdangan_touxiang5.jpg,upload/jiankangdangan_touxiang6.jpg,upload/jiankangdangan_touxiang7.jpg','疾病名称5','2024-04-05','诊断结果5','治疗方案5','用药记录5'),(166,'2024-04-05 03:23:52','用户账号6','用户姓名6','性别6','upload/jiankangdangan_touxiang6.jpg,upload/jiankangdangan_touxiang7.jpg,upload/jiankangdangan_touxiang8.jpg','疾病名称6','2024-04-05','诊断结果6','治疗方案6','用药记录6'),(167,'2024-04-05 03:23:52','用户账号7','用户姓名7','性别7','upload/jiankangdangan_touxiang7.jpg,upload/jiankangdangan_touxiang8.jpg,upload/jiankangdangan_touxiang9.jpg','疾病名称7','2024-04-05','诊断结果7','治疗方案7','用药记录7'),(168,'2024-04-05 03:23:52','用户账号8','用户姓名8','性别8','upload/jiankangdangan_touxiang8.jpg,upload/jiankangdangan_touxiang9.jpg,upload/jiankangdangan_touxiang10.jpg','疾病名称8','2024-04-05','诊断结果8','治疗方案8','用药记录8');
/*!40000 ALTER TABLE `jiankangdangan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jigouleixing`
--
DROP TABLE IF EXISTS `jigouleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jigouleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jigouleixing` varchar(200) DEFAULT NULL COMMENT '机构类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8 COMMENT='机构类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jigouleixing`
--
LOCK TABLES `jigouleixing` WRITE;
/*!40000 ALTER TABLE `jigouleixing` DISABLE KEYS */;
INSERT INTO `jigouleixing` VALUES (131,'2024-04-05 03:23:52','机构类型1'),(132,'2024-04-05 03:23:52','机构类型2'),(133,'2024-04-05 03:23:52','机构类型3'),(134,'2024-04-05 03:23:52','机构类型4'),(135,'2024-04-05 03:23:52','机构类型5'),(136,'2024-04-05 03:23:52','机构类型6'),(137,'2024-04-05 03:23:52','机构类型7'),(138,'2024-04-05 03:23:52','机构类型8');
/*!40000 ALTER TABLE `jigouleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jinjilianxiren`
--
DROP TABLE IF EXISTS `jinjilianxiren`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jinjilianxiren` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`guanxi` varchar(200) DEFAULT NULL COMMENT '关系',
`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
`dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`touxiang` longtext COMMENT '头像',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 COMMENT='紧急联系人';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jinjilianxiren`
--
LOCK TABLES `jinjilianxiren` WRITE;
/*!40000 ALTER TABLE `jinjilianxiren` DISABLE KEYS */;
INSERT INTO `jinjilianxiren` VALUES (141,'2024-04-05 03:23:52','姓名1','男','亲戚','13823888881','地址1','备注1','upload/jinjilianxiren_touxiang1.jpg,upload/jinjilianxiren_touxiang2.jpg,upload/jinjilianxiren_touxiang3.jpg',1),(142,'2024-04-05 03:23:52','姓名2','男','亲戚','13823888882','地址2','备注2','upload/jinjilianxiren_touxiang2.jpg,upload/jinjilianxiren_touxiang3.jpg,upload/jinjilianxiren_touxiang4.jpg',2),(143,'2024-04-05 03:23:52','姓名3','男','亲戚','13823888883','地址3','备注3','upload/jinjilianxiren_touxiang3.jpg,upload/jinjilianxiren_touxiang4.jpg,upload/jinjilianxiren_touxiang5.jpg',3),(144,'2024-04-05 03:23:52','姓名4','男','亲戚','13823888884','地址4','备注4','upload/jinjilianxiren_touxiang4.jpg,upload/jinjilianxiren_touxiang5.jpg,upload/jinjilianxiren_touxiang6.jpg',4),(145,'2024-04-05 03:23:52','姓名5','男','亲戚','13823888885','地址5','备注5','upload/jinjilianxiren_touxiang5.jpg,upload/jinjilianxiren_touxiang6.jpg,upload/jinjilianxiren_touxiang7.jpg',5),(146,'2024-04-05 03:23:52','姓名6','男','亲戚','13823888886','地址6','备注6','upload/jinjilianxiren_touxiang6.jpg,upload/jinjilianxiren_touxiang7.jpg,upload/jinjilianxiren_touxiang8.jpg',6),(147,'2024-04-05 03:23:52','姓名7','男','亲戚','13823888887','地址7','备注7','upload/jinjilianxiren_touxiang7.jpg,upload/jinjilianxiren_touxiang8.jpg,upload/jinjilianxiren_touxiang9.jpg',7),(148,'2024-04-05 03:23:52','姓名8','男','亲戚','13823888888','地址8','备注8','upload/jinjilianxiren_touxiang8.jpg,upload/jinjilianxiren_touxiang9.jpg,upload/jinjilianxiren_touxiang10.jpg',8);
/*!40000 ALTER TABLE `jinjilianxiren` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '留言人id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`avatarurl` longtext COMMENT '头像',
`content` longtext NOT NULL COMMENT '留言内容',
`cpicture` longtext COMMENT '留言图片',
`reply` longtext COMMENT '回复内容',
`rpicture` longtext COMMENT '回复图片',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=utf8 COMMENT='意见反馈';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (201,'2024-04-05 03:23:52',1,'用户名1','upload/messages_avatarurl1.jpg','留言内容1','upload/messages_cpicture1.jpg','回复内容1','upload/messages_rpicture1.jpg'),(202,'2024-04-05 03:23:52',2,'用户名2','upload/messages_avatarurl2.jpg','留言内容2','upload/messages_cpicture2.jpg','回复内容2','upload/messages_rpicture2.jpg'),(203,'2024-04-05 03:23:52',3,'用户名3','upload/messages_avatarurl3.jpg','留言内容3','upload/messages_cpicture3.jpg','回复内容3','upload/messages_rpicture3.jpg'),(204,'2024-04-05 03:23:52',4,'用户名4','upload/messages_avatarurl4.jpg','留言内容4','upload/messages_cpicture4.jpg','回复内容4','upload/messages_rpicture4.jpg'),(205,'2024-04-05 03:23:52',5,'用户名5','upload/messages_avatarurl5.jpg','留言内容5','upload/messages_cpicture5.jpg','回复内容5','upload/messages_rpicture5.jpg'),(206,'2024-04-05 03:23:52',6,'用户名6','upload/messages_avatarurl6.jpg','留言内容6','upload/messages_cpicture6.jpg','回复内容6','upload/messages_rpicture6.jpg'),(207,'2024-04-05 03:23:52',7,'用户名7','upload/messages_avatarurl7.jpg','留言内容7','upload/messages_cpicture7.jpg','回复内容7','upload/messages_rpicture7.jpg'),(208,'2024-04-05 03:23:52',8,'用户名8','upload/messages_avatarurl8.jpg','留言内容8','upload/messages_cpicture8.jpg','回复内容8','upload/messages_rpicture8.jpg');
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `qiujiuxinxi`
--
DROP TABLE IF EXISTS `qiujiuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qiujiuxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`touxiang` longtext COMMENT '头像',
`qiujiushijian` datetime DEFAULT NULL COMMENT '求救时间',
`qiujiuneirong` longtext COMMENT '求救内容',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8 COMMENT='求救信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `qiujiuxinxi`
--
LOCK TABLES `qiujiuxinxi` WRITE;
/*!40000 ALTER TABLE `qiujiuxinxi` DISABLE KEYS */;
INSERT INTO `qiujiuxinxi` VALUES (151,'2024-04-05 03:23:52','姓名1','upload/qiujiuxinxi_touxiang1.jpg,upload/qiujiuxinxi_touxiang2.jpg,upload/qiujiuxinxi_touxiang3.jpg','2024-04-05 11:23:52','求救内容1','用户账号1','用户姓名1'),(152,'2024-04-05 03:23:52','姓名2','upload/qiujiuxinxi_touxiang2.jpg,upload/qiujiuxinxi_touxiang3.jpg,upload/qiujiuxinxi_touxiang4.jpg','2024-04-05 11:23:52','求救内容2','用户账号2','用户姓名2'),(153,'2024-04-05 03:23:52','姓名3','upload/qiujiuxinxi_touxiang3.jpg,upload/qiujiuxinxi_touxiang4.jpg,upload/qiujiuxinxi_touxiang5.jpg','2024-04-05 11:23:52','求救内容3','用户账号3','用户姓名3'),(154,'2024-04-05 03:23:52','姓名4','upload/qiujiuxinxi_touxiang4.jpg,upload/qiujiuxinxi_touxiang5.jpg,upload/qiujiuxinxi_touxiang6.jpg','2024-04-05 11:23:52','求救内容4','用户账号4','用户姓名4'),(155,'2024-04-05 03:23:52','姓名5','upload/qiujiuxinxi_touxiang5.jpg,upload/qiujiuxinxi_touxiang6.jpg,upload/qiujiuxinxi_touxiang7.jpg','2024-04-05 11:23:52','求救内容5','用户账号5','用户姓名5'),(156,'2024-04-05 03:23:52','姓名6','upload/qiujiuxinxi_touxiang6.jpg,upload/qiujiuxinxi_touxiang7.jpg,upload/qiujiuxinxi_touxiang8.jpg','2024-04-05 11:23:52','求救内容6','用户账号6','用户姓名6'),(157,'2024-04-05 03:23:52','姓名7','upload/qiujiuxinxi_touxiang7.jpg,upload/qiujiuxinxi_touxiang8.jpg,upload/qiujiuxinxi_touxiang9.jpg','2024-04-05 11:23:52','求救内容7','用户账号7','用户姓名7'),(158,'2024-04-05 03:23:52','姓名8','upload/qiujiuxinxi_touxiang8.jpg,upload/qiujiuxinxi_touxiang9.jpg,upload/qiujiuxinxi_touxiang10.jpg','2024-04-05 11:23:52','求救内容8','用户账号8','用户姓名8');
/*!40000 ALTER TABLE `qiujiuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `quxiaofuwu`
--
DROP TABLE IF EXISTS `quxiaofuwu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quxiaofuwu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`fuwumingcheng` varchar(200) DEFAULT NULL COMMENT '服务名称',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`fuwujiage` int(11) DEFAULT NULL COMMENT '服务价格',
`fuwutupian` longtext COMMENT '服务图片',
`quxiaoshijian` datetime DEFAULT NULL COMMENT '取消时间',
`quxiaoyuanyin` varchar(200) DEFAULT NULL COMMENT '取消原因',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
`zhuzhi` varchar(200) DEFAULT NULL COMMENT '住址',
`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='取消服务';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `quxiaofuwu`
--
LOCK TABLES `quxiaofuwu` WRITE;
/*!40000 ALTER TABLE `quxiaofuwu` DISABLE KEYS */;
INSERT INTO `quxiaofuwu` VALUES (51,'2024-04-05 03:23:52','订单编号1','服务名称1','服务类型1',1,'upload/quxiaofuwu_fuwutupian1.jpg,upload/quxiaofuwu_fuwutupian2.jpg,upload/quxiaofuwu_fuwutupian3.jpg','2024-04-05 11:23:52','取消原因1','用户账号1','用户姓名1','13823888881','住址1',1,1,'是',''),(52,'2024-04-05 03:23:52','订单编号2','服务名称2','服务类型2',2,'upload/quxiaofuwu_fuwutupian2.jpg,upload/quxiaofuwu_fuwutupian3.jpg,upload/quxiaofuwu_fuwutupian4.jpg','2024-04-05 11:23:52','取消原因2','用户账号2','用户姓名2','13823888882','住址2',2,2,'是',''),(53,'2024-04-05 03:23:52','订单编号3','服务名称3','服务类型3',3,'upload/quxiaofuwu_fuwutupian3.jpg,upload/quxiaofuwu_fuwutupian4.jpg,upload/quxiaofuwu_fuwutupian5.jpg','2024-04-05 11:23:52','取消原因3','用户账号3','用户姓名3','13823888883','住址3',3,3,'是',''),(54,'2024-04-05 03:23:52','订单编号4','服务名称4','服务类型4',4,'upload/quxiaofuwu_fuwutupian4.jpg,upload/quxiaofuwu_fuwutupian5.jpg,upload/quxiaofuwu_fuwutupian6.jpg','2024-04-05 11:23:52','取消原因4','用户账号4','用户姓名4','13823888884','住址4',4,4,'是',''),(55,'2024-04-05 03:23:52','订单编号5','服务名称5','服务类型5',5,'upload/quxiaofuwu_fuwutupian5.jpg,upload/quxiaofuwu_fuwutupian6.jpg,upload/quxiaofuwu_fuwutupian7.jpg','2024-04-05 11:23:52','取消原因5','用户账号5','用户姓名5','13823888885','住址5',5,5,'是',''),(56,'2024-04-05 03:23:52','订单编号6','服务名称6','服务类型6',6,'upload/quxiaofuwu_fuwutupian6.jpg,upload/quxiaofuwu_fuwutupian7.jpg,upload/quxiaofuwu_fuwutupian8.jpg','2024-04-05 11:23:52','取消原因6','用户账号6','用户姓名6','13823888886','住址6',6,6,'是',''),(57,'2024-04-05 03:23:52','订单编号7','服务名称7','服务类型7',7,'upload/quxiaofuwu_fuwutupian7.jpg,upload/quxiaofuwu_fuwutupian8.jpg,upload/quxiaofuwu_fuwutupian9.jpg','2024-04-05 11:23:52','取消原因7','用户账号7','用户姓名7','13823888887','住址7',7,7,'是',''),(58,'2024-04-05 03:23:52','订单编号8','服务名称8','服务类型8',8,'upload/quxiaofuwu_fuwutupian8.jpg,upload/quxiaofuwu_fuwutupian9.jpg,upload/quxiaofuwu_fuwutupian10.jpg','2024-04-05 11:23:52','取消原因8','用户账号8','用户姓名8','13823888888','住址8',8,8,'是','');
/*!40000 ALTER TABLE `quxiaofuwu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shangpindingdan`
--
DROP TABLE IF EXISTS `shangpindingdan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangpindingdan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
`shangpinleixing` varchar(200) DEFAULT NULL COMMENT '商品类型',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`jiage` int(11) DEFAULT NULL COMMENT '价格',
`zonge` double DEFAULT NULL COMMENT '总额',
`goumaishijian` date DEFAULT NULL COMMENT '购买时间',
`dingdanbeizhu` varchar(200) DEFAULT NULL COMMENT '订单备注',
`shangpintupian` longtext COMMENT '商品图片',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='商品订单';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shangpindingdan`
--
LOCK TABLES `shangpindingdan` WRITE;
/*!40000 ALTER TABLE `shangpindingdan` DISABLE KEYS */;
INSERT INTO `shangpindingdan` VALUES (81,'2024-04-05 03:23:52','1111111111','商品名称1','商品类型1','品牌1','规格1',1,1,1,'2024-04-05','订单备注1','upload/shangpindingdan_shangpintupian1.jpg,upload/shangpindingdan_shangpintupian2.jpg,upload/shangpindingdan_shangpintupian3.jpg','用户账号1','用户姓名1','未支付'),(82,'2024-04-05 03:23:52','2222222222','商品名称2','商品类型2','品牌2','规格2',2,2,2,'2024-04-05','订单备注2','upload/shangpindingdan_shangpintupian2.jpg,upload/shangpindingdan_shangpintupian3.jpg,upload/shangpindingdan_shangpintupian4.jpg','用户账号2','用户姓名2','未支付'),(83,'2024-04-05 03:23:52','3333333333','商品名称3','商品类型3','品牌3','规格3',3,3,3,'2024-04-05','订单备注3','upload/shangpindingdan_shangpintupian3.jpg,upload/shangpindingdan_shangpintupian4.jpg,upload/shangpindingdan_shangpintupian5.jpg','用户账号3','用户姓名3','未支付'),(84,'2024-04-05 03:23:52','4444444444','商品名称4','商品类型4','品牌4','规格4',4,4,4,'2024-04-05','订单备注4','upload/shangpindingdan_shangpintupian4.jpg,upload/shangpindingdan_shangpintupian5.jpg,upload/shangpindingdan_shangpintupian6.jpg','用户账号4','用户姓名4','未支付'),(85,'2024-04-05 03:23:52','5555555555','商品名称5','商品类型5','品牌5','规格5',5,5,5,'2024-04-05','订单备注5','upload/shangpindingdan_shangpintupian5.jpg,upload/shangpindingdan_shangpintupian6.jpg,upload/shangpindingdan_shangpintupian7.jpg','用户账号5','用户姓名5','未支付'),(86,'2024-04-05 03:23:52','6666666666','商品名称6','商品类型6','品牌6','规格6',6,6,6,'2024-04-05','订单备注6','upload/shangpindingdan_shangpintupian6.jpg,upload/shangpindingdan_shangpintupian7.jpg,upload/shangpindingdan_shangpintupian8.jpg','用户账号6','用户姓名6','未支付'),(87,'2024-04-05 03:23:52','7777777777','商品名称7','商品类型7','品牌7','规格7',7,7,7,'2024-04-05','订单备注7','upload/shangpindingdan_shangpintupian7.jpg,upload/shangpindingdan_shangpintupian8.jpg,upload/shangpindingdan_shangpintupian9.jpg','用户账号7','用户姓名7','未支付'),(88,'2024-04-05 03:23:52','8888888888','商品名称8','商品类型8','品牌8','规格8',8,8,8,'2024-04-05','订单备注8','upload/shangpindingdan_shangpintupian8.jpg,upload/shangpindingdan_shangpintupian9.jpg,upload/shangpindingdan_shangpintupian10.jpg','用户账号8','用户姓名8','未支付');
/*!40000 ALTER TABLE `shangpindingdan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shangpinleixing`
--
DROP TABLE IF EXISTS `shangpinleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangpinleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangpinleixing` varchar(200) DEFAULT NULL COMMENT '商品类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='商品类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shangpinleixing`
--
LOCK TABLES `shangpinleixing` WRITE;
/*!40000 ALTER TABLE `shangpinleixing` DISABLE KEYS */;
INSERT INTO `shangpinleixing` VALUES (71,'2024-04-05 03:23:52','商品类型1'),(72,'2024-04-05 03:23:52','商品类型2'),(73,'2024-04-05 03:23:52','商品类型3'),(74,'2024-04-05 03:23:52','商品类型4'),(75,'2024-04-05 03:23:52','商品类型5'),(76,'2024-04-05 03:23:52','商品类型6'),(77,'2024-04-05 03:23:52','商品类型7'),(78,'2024-04-05 03:23:52','商品类型8');
/*!40000 ALTER TABLE `shangpinleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '商品id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '名称',
`picture` longtext COMMENT '图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
`remark` varchar(200) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tuikuanshenqing`
--
DROP TABLE IF EXISTS `tuikuanshenqing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tuikuanshenqing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
`shangpinleixing` varchar(200) DEFAULT NULL COMMENT '商品类型',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`jiage` int(11) DEFAULT NULL COMMENT '价格',
`zonge` double DEFAULT NULL COMMENT '总额',
`tuikuanshijian` date DEFAULT NULL COMMENT '退款时间',
`tuikuanyuanyin` varchar(200) DEFAULT NULL COMMENT '退款原因',
`shangpintupian` longtext COMMENT '商品图片',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='退款申请';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tuikuanshenqing`
--
LOCK TABLES `tuikuanshenqing` WRITE;
/*!40000 ALTER TABLE `tuikuanshenqing` DISABLE KEYS */;
INSERT INTO `tuikuanshenqing` VALUES (91,'2024-04-05 03:23:52','订单编号1','商品名称1','商品类型1','品牌1','规格1',1,1,1,'2024-04-05','退款原因1','upload/tuikuanshenqing_shangpintupian1.jpg,upload/tuikuanshenqing_shangpintupian2.jpg,upload/tuikuanshenqing_shangpintupian3.jpg','用户账号1','用户姓名1',1,1,'是','','未支付'),(92,'2024-04-05 03:23:52','订单编号2','商品名称2','商品类型2','品牌2','规格2',2,2,2,'2024-04-05','退款原因2','upload/tuikuanshenqing_shangpintupian2.jpg,upload/tuikuanshenqing_shangpintupian3.jpg,upload/tuikuanshenqing_shangpintupian4.jpg','用户账号2','用户姓名2',2,2,'是','','未支付'),(93,'2024-04-05 03:23:52','订单编号3','商品名称3','商品类型3','品牌3','规格3',3,3,3,'2024-04-05','退款原因3','upload/tuikuanshenqing_shangpintupian3.jpg,upload/tuikuanshenqing_shangpintupian4.jpg,upload/tuikuanshenqing_shangpintupian5.jpg','用户账号3','用户姓名3',3,3,'是','','未支付'),(94,'2024-04-05 03:23:52','订单编号4','商品名称4','商品类型4','品牌4','规格4',4,4,4,'2024-04-05','退款原因4','upload/tuikuanshenqing_shangpintupian4.jpg,upload/tuikuanshenqing_shangpintupian5.jpg,upload/tuikuanshenqing_shangpintupian6.jpg','用户账号4','用户姓名4',4,4,'是','','未支付'),(95,'2024-04-05 03:23:52','订单编号5','商品名称5','商品类型5','品牌5','规格5',5,5,5,'2024-04-05','退款原因5','upload/tuikuanshenqing_shangpintupian5.jpg,upload/tuikuanshenqing_shangpintupian6.jpg,upload/tuikuanshenqing_shangpintupian7.jpg','用户账号5','用户姓名5',5,5,'是','','未支付'),(96,'2024-04-05 03:23:52','订单编号6','商品名称6','商品类型6','品牌6','规格6',6,6,6,'2024-04-05','退款原因6','upload/tuikuanshenqing_shangpintupian6.jpg,upload/tuikuanshenqing_shangpintupian7.jpg,upload/tuikuanshenqing_shangpintupian8.jpg','用户账号6','用户姓名6',6,6,'是','','未支付'),(97,'2024-04-05 03:23:52','订单编号7','商品名称7','商品类型7','品牌7','规格7',7,7,7,'2024-04-05','退款原因7','upload/tuikuanshenqing_shangpintupian7.jpg,upload/tuikuanshenqing_shangpintupian8.jpg,upload/tuikuanshenqing_shangpintupian9.jpg','用户账号7','用户姓名7',7,7,'是','','未支付'),(98,'2024-04-05 03:23:52','订单编号8','商品名称8','商品类型8','品牌8','规格8',8,8,8,'2024-04-05','退款原因8','upload/tuikuanshenqing_shangpintupian8.jpg,upload/tuikuanshenqing_shangpintupian9.jpg,upload/tuikuanshenqing_shangpintupian10.jpg','用户账号8','用户姓名8',8,8,'是','','未支付');
/*!40000 ALTER TABLE `tuikuanshenqing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`image` varchar(200) DEFAULT NULL COMMENT '头像',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 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 `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','admin','upload/image1.jpg','管理员','2024-04-05 03:23:52');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yanglaofuwu`
--
DROP TABLE IF EXISTS `yanglaofuwu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yanglaofuwu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`fuwumingcheng` varchar(200) DEFAULT NULL COMMENT '服务名称',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`fuwufanwei` varchar(200) DEFAULT NULL COMMENT '服务范围',
`fuwujiage` int(11) DEFAULT NULL COMMENT '服务价格',
`fuwudianhua` varchar(200) DEFAULT NULL COMMENT '服务电话',
`fuwujieshao` longtext COMMENT '服务介绍',
`fuwutupian` longtext COMMENT '服务图片',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='养老服务';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yanglaofuwu`
--
LOCK TABLES `yanglaofuwu` WRITE;
/*!40000 ALTER TABLE `yanglaofuwu` DISABLE KEYS */;
INSERT INTO `yanglaofuwu` VALUES (21,'2024-04-05 03:23:52','服务名称1','服务类型1','服务范围1',1,'13823888881','服务介绍1','upload/yanglaofuwu_fuwutupian1.jpg,upload/yanglaofuwu_fuwutupian2.jpg,upload/yanglaofuwu_fuwutupian3.jpg','2024-04-05 11:23:52',1,1),(22,'2024-04-05 03:23:52','服务名称2','服务类型2','服务范围2',2,'13823888882','服务介绍2','upload/yanglaofuwu_fuwutupian2.jpg,upload/yanglaofuwu_fuwutupian3.jpg,upload/yanglaofuwu_fuwutupian4.jpg','2024-04-05 11:23:52',2,2),(23,'2024-04-05 03:23:52','服务名称3','服务类型3','服务范围3',3,'13823888883','服务介绍3','upload/yanglaofuwu_fuwutupian3.jpg,upload/yanglaofuwu_fuwutupian4.jpg,upload/yanglaofuwu_fuwutupian5.jpg','2024-04-05 11:23:52',3,3),(24,'2024-04-05 03:23:52','服务名称4','服务类型4','服务范围4',4,'13823888884','服务介绍4','upload/yanglaofuwu_fuwutupian4.jpg,upload/yanglaofuwu_fuwutupian5.jpg,upload/yanglaofuwu_fuwutupian6.jpg','2024-04-05 11:23:52',4,4),(25,'2024-04-05 03:23:52','服务名称5','服务类型5','服务范围5',5,'13823888885','服务介绍5','upload/yanglaofuwu_fuwutupian5.jpg,upload/yanglaofuwu_fuwutupian6.jpg,upload/yanglaofuwu_fuwutupian7.jpg','2024-04-05 11:23:52',5,5),(26,'2024-04-05 03:23:52','服务名称6','服务类型6','服务范围6',6,'13823888886','服务介绍6','upload/yanglaofuwu_fuwutupian6.jpg,upload/yanglaofuwu_fuwutupian7.jpg,upload/yanglaofuwu_fuwutupian8.jpg','2024-04-05 11:23:52',6,6),(27,'2024-04-05 03:23:52','服务名称7','服务类型7','服务范围7',7,'13823888887','服务介绍7','upload/yanglaofuwu_fuwutupian7.jpg,upload/yanglaofuwu_fuwutupian8.jpg,upload/yanglaofuwu_fuwutupian9.jpg','2024-04-05 11:23:52',7,7),(28,'2024-04-05 03:23:52','服务名称8','服务类型8','服务范围8',8,'13823888888','服务介绍8','upload/yanglaofuwu_fuwutupian8.jpg,upload/yanglaofuwu_fuwutupian9.jpg,upload/yanglaofuwu_fuwutupian10.jpg','2024-04-05 11:23:52',8,8);
/*!40000 ALTER TABLE `yanglaofuwu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yonghu`
--
DROP TABLE IF EXISTS `yonghu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`yonghuxingming` varchar(200) NOT NULL COMMENT '用户姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`dianhua` varchar(200) NOT NULL COMMENT '电话',
`zhuzhi` varchar(200) NOT NULL COMMENT '住址',
`touxiang` longtext COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yonghu`
--
LOCK TABLES `yonghu` WRITE;
/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
INSERT INTO `yonghu` VALUES (11,'2024-04-05 03:23:52','用户账号1','123456','用户姓名1','男','13823888881','住址1','upload/yonghu_touxiang1.jpg'),(12,'2024-04-05 03:23:52','用户账号2','123456','用户姓名2','男','13823888882','住址2','upload/yonghu_touxiang2.jpg'),(13,'2024-04-05 03:23:52','用户账号3','123456','用户姓名3','男','13823888883','住址3','upload/yonghu_touxiang3.jpg'),(14,'2024-04-05 03:23:52','用户账号4','123456','用户姓名4','男','13823888884','住址4','upload/yonghu_touxiang4.jpg'),(15,'2024-04-05 03:23:52','用户账号5','123456','用户姓名5','男','13823888885','住址5','upload/yonghu_touxiang5.jpg'),(16,'2024-04-05 03:23:52','用户账号6','123456','用户姓名6','男','13823888886','住址6','upload/yonghu_touxiang6.jpg'),(17,'2024-04-05 03:23:52','用户账号7','123456','用户姓名7','男','13823888887','住址7','upload/yonghu_touxiang7.jpg'),(18,'2024-04-05 03:23:52','用户账号8','123456','用户姓名8','男','13823888888','住址8','upload/yonghu_touxiang8.jpg');
/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zaixiangouwu`
--
DROP TABLE IF EXISTS `zaixiangouwu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zaixiangouwu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
`shangpinleixing` varchar(200) DEFAULT NULL COMMENT '商品类型',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`jiage` int(11) DEFAULT NULL COMMENT '价格',
`shengchanchangjia` varchar(200) DEFAULT NULL COMMENT '生产厂家',
`shengchanriqi` date DEFAULT NULL COMMENT '生产日期',
`shangpinjieshao` longtext COMMENT '商品介绍',
`shangpintupian` longtext COMMENT '商品图片',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`discussnum` int(11) DEFAULT '0' COMMENT '评论数',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='在线购物';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zaixiangouwu`
--
LOCK TABLES `zaixiangouwu` WRITE;
/*!40000 ALTER TABLE `zaixiangouwu` DISABLE KEYS */;
INSERT INTO `zaixiangouwu` VALUES (61,'2024-04-05 03:23:52','商品名称1','商品类型1','品牌1','规格1',1,1,'生产厂家1','2024-04-05','商品介绍1','upload/zaixiangouwu_shangpintupian1.jpg,upload/zaixiangouwu_shangpintupian2.jpg,upload/zaixiangouwu_shangpintupian3.jpg',1,1,'2024-04-05 11:23:52',1,0,1),(62,'2024-04-05 03:23:52','商品名称2','商品类型2','品牌2','规格2',2,2,'生产厂家2','2024-04-05','商品介绍2','upload/zaixiangouwu_shangpintupian2.jpg,upload/zaixiangouwu_shangpintupian3.jpg,upload/zaixiangouwu_shangpintupian4.jpg',2,2,'2024-04-05 11:23:52',2,0,2),(63,'2024-04-05 03:23:52','商品名称3','商品类型3','品牌3','规格3',3,3,'生产厂家3','2024-04-05','商品介绍3','upload/zaixiangouwu_shangpintupian3.jpg,upload/zaixiangouwu_shangpintupian4.jpg,upload/zaixiangouwu_shangpintupian5.jpg',3,3,'2024-04-05 11:23:52',3,0,3),(64,'2024-04-05 03:23:52','商品名称4','商品类型4','品牌4','规格4',4,4,'生产厂家4','2024-04-05','商品介绍4','upload/zaixiangouwu_shangpintupian4.jpg,upload/zaixiangouwu_shangpintupian5.jpg,upload/zaixiangouwu_shangpintupian6.jpg',4,4,'2024-04-05 11:23:52',4,0,4),(65,'2024-04-05 03:23:52','商品名称5','商品类型5','品牌5','规格5',5,5,'生产厂家5','2024-04-05','商品介绍5','upload/zaixiangouwu_shangpintupian5.jpg,upload/zaixiangouwu_shangpintupian6.jpg,upload/zaixiangouwu_shangpintupian7.jpg',5,5,'2024-04-05 11:23:52',5,0,5),(66,'2024-04-05 03:23:52','商品名称6','商品类型6','品牌6','规格6',6,6,'生产厂家6','2024-04-05','商品介绍6','upload/zaixiangouwu_shangpintupian6.jpg,upload/zaixiangouwu_shangpintupian7.jpg,upload/zaixiangouwu_shangpintupian8.jpg',6,6,'2024-04-05 11:23:52',6,0,6),(67,'2024-04-05 03:23:52','商品名称7','商品类型7','品牌7','规格7',7,7,'生产厂家7','2024-04-05','商品介绍7','upload/zaixiangouwu_shangpintupian7.jpg,upload/zaixiangouwu_shangpintupian8.jpg,upload/zaixiangouwu_shangpintupian9.jpg',7,7,'2024-04-05 11:23:52',7,0,7),(68,'2024-04-05 03:23:52','商品名称8','商品类型8','品牌8','规格8',8,8,'生产厂家8','2024-04-05','商品介绍8','upload/zaixiangouwu_shangpintupian8.jpg,upload/zaixiangouwu_shangpintupian9.jpg,upload/zaixiangouwu_shangpintupian10.jpg',8,8,'2024-04-05 11:23:52',8,0,8);
/*!40000 ALTER TABLE `zaixiangouwu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zhishifenlei`
--
DROP TABLE IF EXISTS `zhishifenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhishifenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhishifenlei` varchar(200) DEFAULT NULL COMMENT '知识分类',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT='知识分类';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zhishifenlei`
--
LOCK TABLES `zhishifenlei` WRITE;
/*!40000 ALTER TABLE `zhishifenlei` DISABLE KEYS */;
INSERT INTO `zhishifenlei` VALUES (111,'2024-04-05 03:23:52','知识分类1'),(112,'2024-04-05 03:23:52','知识分类2'),(113,'2024-04-05 03:23:52','知识分类3'),(114,'2024-04-05 03:23:52','知识分类4'),(115,'2024-04-05 03:23:52','知识分类5'),(116,'2024-04-05 03:23:52','知识分类6'),(117,'2024-04-05 03:23:52','知识分类7'),(118,'2024-04-05 03:23:52','知识分类8');
/*!40000 ALTER TABLE `zhishifenlei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zhishiku`
--
DROP TABLE IF EXISTS `zhishiku`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhishiku` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhishimingcheng` varchar(200) NOT NULL COMMENT '知识名称',
`zhishifenlei` varchar(200) NOT NULL COMMENT '知识分类',
`zhishilaiyuan` varchar(200) DEFAULT NULL COMMENT '知识来源',
`zhishishipin` longtext COMMENT '知识视频',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
`neirongjianjie` longtext COMMENT '内容简介',
`zhishifengmian` longtext COMMENT '知识封面',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`discussnum` int(11) DEFAULT '0' COMMENT '评论数',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='知识库';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zhishiku`
--
LOCK TABLES `zhishiku` WRITE;
/*!40000 ALTER TABLE `zhishiku` DISABLE KEYS */;
INSERT INTO `zhishiku` VALUES (101,'2024-04-05 03:23:52','知识名称1','知识分类1','知识来源1','','2024-04-05','内容简介1','upload/zhishiku_zhishifengmian1.jpg,upload/zhishiku_zhishifengmian2.jpg,upload/zhishiku_zhishifengmian3.jpg',1,1,'2024-04-05 11:23:52',1,0,1),(102,'2024-04-05 03:23:52','知识名称2','知识分类2','知识来源2','','2024-04-05','内容简介2','upload/zhishiku_zhishifengmian2.jpg,upload/zhishiku_zhishifengmian3.jpg,upload/zhishiku_zhishifengmian4.jpg',2,2,'2024-04-05 11:23:52',2,0,2),(103,'2024-04-05 03:23:52','知识名称3','知识分类3','知识来源3','','2024-04-05','内容简介3','upload/zhishiku_zhishifengmian3.jpg,upload/zhishiku_zhishifengmian4.jpg,upload/zhishiku_zhishifengmian5.jpg',3,3,'2024-04-05 11:23:52',3,0,3),(104,'2024-04-05 03:23:52','知识名称4','知识分类4','知识来源4','','2024-04-05','内容简介4','upload/zhishiku_zhishifengmian4.jpg,upload/zhishiku_zhishifengmian5.jpg,upload/zhishiku_zhishifengmian6.jpg',4,4,'2024-04-05 11:23:52',4,0,4),(105,'2024-04-05 03:23:52','知识名称5','知识分类5','知识来源5','','2024-04-05','内容简介5','upload/zhishiku_zhishifengmian5.jpg,upload/zhishiku_zhishifengmian6.jpg,upload/zhishiku_zhishifengmian7.jpg',5,5,'2024-04-05 11:23:52',5,0,5),(106,'2024-04-05 03:23:52','知识名称6','知识分类6','知识来源6','','2024-04-05','内容简介6','upload/zhishiku_zhishifengmian6.jpg,upload/zhishiku_zhishifengmian7.jpg,upload/zhishiku_zhishifengmian8.jpg',6,6,'2024-04-05 11:23:52',6,0,6),(107,'2024-04-05 03:23:52','知识名称7','知识分类7','知识来源7','','2024-04-05','内容简介7','upload/zhishiku_zhishifengmian7.jpg,upload/zhishiku_zhishifengmian8.jpg,upload/zhishiku_zhishifengmian9.jpg',7,7,'2024-04-05 11:23:52',7,0,7),(108,'2024-04-05 03:23:52','知识名称8','知识分类8','知识来源8','','2024-04-05','内容简介8','upload/zhishiku_zhishifengmian8.jpg,upload/zhishiku_zhishifengmian9.jpg,upload/zhishiku_zhishifengmian10.jpg',8,8,'2024-04-05 11:23:52',8,0,8);
/*!40000 ALTER TABLE `zhishiku` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2024-04-05 11:28:38
源码及文档获取
文章下方名片联系我即可~
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻
精彩专栏推荐订阅:在下方专栏👇🏻
最新计算机毕业设计选题篇-选题推荐
小程序毕业设计精品项目案例-200套
Java毕业设计精品项目案例-200套
Python毕业设计精品项目案例-200套
大数据毕业设计精品项目案例-200套
💟💟如果大家有任何疑虑,欢迎在下方位置详细交流。