基于Spring Boot的医疗陪护系统设计与实现(源码+定制+开发）病患陪护管理平台、医疗服务管理系统、医疗陪护信息平台
博主介绍：
✌我是阿龙，一名专注于Java技术领域的程序员，全网拥有10W+粉丝。作为CSDN特邀作者、博客专家、新星计划导师，我在计算机毕业设计开发方面积累了丰富的经验。同时，我也是掘金、华为云、阿里云、InfoQ等平台的优质作者。通过长期分享和实战指导，我致力于帮助更多学生完成毕业项目和技术提升。技术范围：
我熟悉的技术领域涵盖SpringBoot、Vue、SSM、HLMT、Jsp、PHP、Nodejs、Python、爬虫、数据可视化、小程序、安卓app、大数据、物联网、机器学习等方面的设计与开发。如果你有任何技术难题，我都乐意与你分享解决方案。主要内容：
我的服务内容包括：免费功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文撰写与辅导、论文降重、长期答辩答疑辅导。我还提供腾讯会议一对一的专业讲解和模拟答辩演练，帮助你全面掌握答辩技巧与代码逻辑。🍅获取源码请在文末联系我🍅
目录：
一、详细操作演示视频 在文章的尾声，您会发现一张电子名片👤，欢迎通过名片上的联系方式与我取得联系，以获取更多关于项目演示的详尽视频内容。视频将帮助您全面理解项目的关键点和操作流程。期待与您的进一步交流！ 承诺所有开发的项目，全程售后陪伴！！！
系统简介：
2 核心技术介绍
2.1 mysql技术介绍
2.2 IDEA编译器介绍
2.3 SpringBoot框架简介
2.4 springmvc框架简介
2.5 Vue.js技术简介
系统实现界面：
核心代码分析：
数据库核心代码
一、详细操作演示视频
在文章的尾声，您会发现一张电子名片👤，欢迎通过名片上的联系方式与我取得联系，以获取更多关于项目演示的详尽视频内容。视频将帮助您全面理解项目的关键点和操作流程。期待与您的进一步交流！
承诺所有开发的项目，全程售后陪伴！！！
系统简介：
医疗服务需求的增长推动了医疗陪护系统的开发，以满足现代医疗服务的多样化需求。基于SpringBoot的医疗陪护系统应运而生，为用户、护工、医生和管理员提供了一个全面的服务平台。
本系统采用Java语言开发，后端框架选择SpringBoot，前端使用Vue技术，数据库管理系统采用MySQL，确保了系统的高效运行和数据的安全管理。
本系统包含多个功能模块，针对不同角色设计了相应的服务功能。用户模块允许注册登录，并提供个人中心、医生信息查询、医疗陪护项目推荐等功能；护工模块为护工提供登录、服务项目管理和预约管理等；医生模块则包括了日程管理、病人管理以及在线咨询功能；管理员模块则负责整个系统的后台管理，包括用户管理、医生管理、服务评价和医疗陪护项目管理等。
此系统不仅优化了医疗服务流程，还提升了服务质量，满足了不同用户的个性化需求。
2 核心技术介绍
2.1 mysql技术介绍
MySQL作为一种广泛使用的开源关系型数据库管理系统，属于Oracle公司。由于其高性能、可靠性以及易用性，MySQL成为了许多开发者和公司的首选数据库。特别在Web应用领域，MySQL以其卓越的速度和效率，处理大量数据而不牺牲性能，广受好评。
在基于SpringBoot的医疗陪护系统中，MySQL扮演着关键的角色，负责存储和管理所有数据，包括用户信息、医生详情、预约数据以及医疗服务记录等。系统通过SQL查询，有效地检索和更新数据，确保信息流的高效和准确。MySQL的事务管理功能保证了数据库操作的原子性、一致性、隔离性和持久性[5]，这对于医疗陪护系统来说至关重要，因为需要确保数据的完整性和一致性。
MySQL还支持高级功能，如触发器、存储过程和视图，这些功能为医疗陪护系统提供了强大的数据处理能力。触发器可自动执行数据库中的操作，以响应特定事件，有助于自动化和简化复杂的数据处理过程。存储过程则允许在数据库服务器上直接执行复杂的SQL查询，减少了网络之间的数据传输，提高了系统的响应速度。
2.2 IDEA编译器介绍
IDEA全称IntelliJ IDEA，是对Java语言开发的一种集成环境，是JetBrains公司的产品。Idea倡导的是智慧编码，目的是能够减轻编程员的实际管理工作，主要特色功用是智能的选择、大量的导航模块、历史记录功能等，而更重要的功用则是调试(Debug)，能够对Java代码、JavaScript、Query等各种功能进行调试。IntelliJ在业内一直被认为是世界一流的Java技术开发工具[6]，尤其在智能代码助手、代码自动提醒。免费版只支持HYPERLINK 等极少数语言。
2.3 SpringBoot框架简介
Spring Boot是一款非常强大后台框架，因为Spring Boot开发时可以基本不用写配置文件，所以使用Spring Boot搭建网站的后台环境，在Spring Boot的yml配置文件中写入项目启动端口，项目就可以启动。项目的Java文件还有静态文件都是由Spring Boot来管理。
2.4 springmvc框架简介
spring框架包含springmvc框架，mvc是一种设计模式，model表示实体层，视图用V表示，用来表示jsp页面，控制器用C表示，用于jsp页面传递数据到控制器当中。处理请求和数据处理。springmvc框架的核心类是dispatcherServlet，将请求进行拦截，将请求转移到适配器当中进行处理[7]，寻求合适的方法对用户从页面中发出来的请求进行处理。发挥MVC框架的作用把数据展示在页面当中。MVC框架和spring框架是无缝连接的。MVC框架继承了ajax，所以可以在jsp页面当中使用ajax传递数据到controller类中。在controller中使用response body注解进行交互。mvc框架在和其它框架进行整合的时候要简单得多。
2.5 Vue.js技术简介
VUE是一套可以自底向上逐层应用的渐进式JavaScript框架，它可以用来构建用户界面。当与现代化的工具链以及各种支持类库结合使用时，VUE 也完全能够为复杂的单页应用（SPA）提供驱动。VUE 只关注视图层，采用自底向上增量开发的设计，还很容易和第三方库或者是已有的项目进行整合。
系统实现界面：
核心代码分析：
<template>
<div class="content" :style='{"minHeight":"100vh","padding":"0px 30px 20px","alignItems":"flex-start","flexWrap":"wrap","background":"url(http://codegen.caihongy.cn/20240409/022fa5d23027406e8723c4bfa0031326.png) no-repeat center top / cover","display":"block","width":"100%","fontSize":"14px","height":"auto"}'>
<!-- notice -->
<!-- title -->
<div class="text" :style='{"margin":"20px auto","color":"#697882","textAlign":"center","display":"block","width":"100%","fontSize":"30px","fontWeight":"600"}'>欢迎使用 {{this.$project.projectName}}</div>
<!-- echarts -->
</div>
</template>
<script>
//0
import router from '@/router/router-static'
import * as echarts from 'echarts'
export default {
data() {
return {
};
},
mounted(){
this.init();
},
methods:{
init(){
if(this.$storage.get('Token')){
this.$http({
url: `${this.$storage.get('sessionTable')}/session`,
method: "get"
}).then(({ data }) => {
if (data && data.code != 0) {
router.push({ name: 'login' })
}
});
}else{
router.push({ name: 'login' })
}
},
}
};
</script>
<style lang="scss" scoped>
.cardView {
display: flex;
flex-wrap: wrap;
width: 100%;
.cards {
display: flex;
align-items: center;
width: 100%;
margin-bottom: 10px;
justify-content: center;
.card {
width: calc(25% - 20px);
margin: 0 10px;
/deep/.el-card__body{
padding: 0;
}
}
}
}
// 日历
.calendar td .text {
border: 1px solid #eee;
border-radius: 4px;
flex-direction: column;
color: #888;
background: #fff;
display: flex;
width: 100%;
justify-content: center;
align-items: center;
height: 100%;
}
.calendar td .text:hover {
background: #fff;
}
.calendar td .text .new {
color: inherit;
font-size: inherit;
line-height: 1.4;
}
.calendar td .text .old {
color: inherit;
font-size: inherit;
line-height: 1.4;
}
.calendar td.festival .text {
border: 0px solid rgba(93, 213, 200, .1);
border-radius: 4px;
flex-direction: column;
color: #333;
background: #f2f6f9;
display: flex;
width: 100%;
justify-content: center;
align-items: center;
height: 100%;
}
.calendar td.festival .text:hover {
background: #f2f6f9;
}
.calendar td.festival .text .new {
color: inherit;
font-size: inherit;
line-height: 1.4;
}
.calendar td.festival .text .old {
color: inherit;
font-size: inherit;
line-height: 1.4;
}
.calendar td.other .text {
border-radius: 20px;
flex-direction: column;
background: none;
display: flex;
width: 100%;
font-size: inherit;
justify-content: center;
align-items: center;
opacity: 0.6;
height: 100%;
}
.calendar td.other .text:hover {
background: none;
}
.calendar td.other .text .new {
color: #000;
font-size: inherit;
line-height: 1.4;
}
.calendar td.other .text .old {
color: #666;
font-size: inherit;
line-height: 1.4;
}
.calendar td.today .text {
border-radius: 4px;
flex-direction: column;
color: #fff;
background: #5C9ACF;
display: flex;
width: 100%;
justify-content: center;
align-items: center;
height: 100%;
}
.calendar td.today .text:hover {
background: #5C9ACF;
}
.calendar td.today .text .new {
font-size: inherit;
line-height: 1.4;
}
.calendar td.today .text .old {
font-size: inherit;
line-height: 1.4;
}
// echarts1
.type1 .echarts1 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0 0 30px;
background: rgba(255,255,255,1);
width: 100%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type1 .echarts1:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
// echarts2
.type2 .echarts1 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type2 .echarts1:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type2 .echarts2 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type2 .echarts2:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
// echarts3
.type3 .echarts1 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0 0 30px;
color: #333;
background: rgba(255,255,255,.96);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type3 .echarts1:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type3 .echarts2 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type3 .echarts2:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type3 .echarts3 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0 0 30px;
background: rgba(255,255,255,1);
width: 100%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type3 .echarts3:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
// echarts4
.type4 .echarts1 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type4 .echarts1:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type4 .echarts2 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type4 .echarts2:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type4 .echarts3 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type4 .echarts3:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type4 .echarts4 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type4 .echarts4:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
// echarts5
.type5 .echarts1 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,.96);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type5 .echarts1:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type5 .echarts2 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 400px;
}
.type5 .echarts2:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type5 .echarts3 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,1);
width: 100%;
position: relative;
transition: 0.3s;
height: 360px;
}
.type5 .echarts3:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type5 .echarts4 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 360px;
}
.type5 .echarts4:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.type5 .echarts5 {
border: 0px solid #bababa;
border-radius: 5px;
padding: 10px;
box-shadow: none;
margin: 0px 0 30px;
background: rgba(255,255,255,1);
width: 49%;
position: relative;
transition: 0.3s;
height: 360px;
}
.type5 .echarts5:hover {
box-shadow: none;
transform: translate3d(0, 0px, 0);
z-index: 1;
}
.echarts-flag-2 {
display: flex;
flex-wrap: wrap;
justify-content: space-between;
padding: 10px 20px;
background: rebeccapurple;
&>div {
width: 32%;
height: 300px;
margin: 10px 0;
background: rgba(255,255,255,.1);
border-radius: 8px;
padding: 10px 20px;
}
}
</style>
数据库核心代码：
--
-- Current Database: `springbootm65707kt`
--
/*!40000 DROP DATABASE IF EXISTS `springbootm65707kt`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbootm65707kt` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `springbootm65707kt`;
--
-- Table structure for table `binglixinxi`
--
DROP TABLE IF EXISTS `binglixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `binglixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huanzhezhanghao` varchar(200) DEFAULT NULL COMMENT '患者账号',
`huanzhexingming` varchar(200) DEFAULT NULL COMMENT '患者姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`touxiang` longtext COMMENT '头像',
`jibingmingcheng` varchar(200) DEFAULT NULL COMMENT '疾病名称',
`bingqingmiaoshu` longtext COMMENT '病情描述',
`zhenduanjieguo` longtext COMMENT '诊断结果',
`zhiliaofangan` longtext COMMENT '治疗方案',
`jiuzhenriqi` date DEFAULT NULL COMMENT '就诊日期',
`yishenggonghao` varchar(200) DEFAULT NULL COMMENT '医生工号',
`yishengxingming` 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 `binglixinxi`
--
LOCK TABLES `binglixinxi` WRITE;
/*!40000 ALTER TABLE `binglixinxi` DISABLE KEYS */;
INSERT INTO `binglixinxi` VALUES (71,'2024-04-16 09:37:00','患者账号1','患者姓名1','性别1',1,'upload/binglixinxi_touxiang1.jpg,upload/binglixinxi_touxiang2.jpg,upload/binglixinxi_touxiang3.jpg','疾病名称1','病情描述1','诊断结果1','治疗方案1','2024-04-16','医生工号1','医生姓名1'),(72,'2024-04-16 09:37:00','患者账号2','患者姓名2','性别2',2,'upload/binglixinxi_touxiang2.jpg,upload/binglixinxi_touxiang3.jpg,upload/binglixinxi_touxiang4.jpg','疾病名称2','病情描述2','诊断结果2','治疗方案2','2024-04-16','医生工号2','医生姓名2'),(73,'2024-04-16 09:37:00','患者账号3','患者姓名3','性别3',3,'upload/binglixinxi_touxiang3.jpg,upload/binglixinxi_touxiang4.jpg,upload/binglixinxi_touxiang5.jpg','疾病名称3','病情描述3','诊断结果3','治疗方案3','2024-04-16','医生工号3','医生姓名3'),(74,'2024-04-16 09:37:00','患者账号4','患者姓名4','性别4',4,'upload/binglixinxi_touxiang4.jpg,upload/binglixinxi_touxiang5.jpg,upload/binglixinxi_touxiang6.jpg','疾病名称4','病情描述4','诊断结果4','治疗方案4','2024-04-16','医生工号4','医生姓名4'),(75,'2024-04-16 09:37:00','患者账号5','患者姓名5','性别5',5,'upload/binglixinxi_touxiang5.jpg,upload/binglixinxi_touxiang6.jpg,upload/binglixinxi_touxiang7.jpg','疾病名称5','病情描述5','诊断结果5','治疗方案5','2024-04-16','医生工号5','医生姓名5'),(76,'2024-04-16 09:37:00','患者账号6','患者姓名6','性别6',6,'upload/binglixinxi_touxiang6.jpg,upload/binglixinxi_touxiang7.jpg,upload/binglixinxi_touxiang8.jpg','疾病名称6','病情描述6','诊断结果6','治疗方案6','2024-04-16','医生工号6','医生姓名6'),(77,'2024-04-16 09:37:00','患者账号7','患者姓名7','性别7',7,'upload/binglixinxi_touxiang7.jpg,upload/binglixinxi_touxiang8.jpg,upload/binglixinxi_touxiang9.jpg','疾病名称7','病情描述7','诊断结果7','治疗方案7','2024-04-16','医生工号7','医生姓名7'),(78,'2024-04-16 09:37:00','患者账号8','患者姓名8','性别8',8,'upload/binglixinxi_touxiang8.jpg,upload/binglixinxi_touxiang9.jpg,upload/binglixinxi_touxiang10.jpg','疾病名称8','病情描述8','诊断结果8','治疗方案8','2024-04-16','医生工号8','医生姓名8');
/*!40000 ALTER TABLE `binglixinxi` 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 `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=159 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 (151,'2024-04-16 09:37:01','服务类型1'),(152,'2024-04-16 09:37:01','服务类型2'),(153,'2024-04-16 09:37:01','服务类型3'),(154,'2024-04-16 09:37:01','服务类型4'),(155,'2024-04-16 09:37:01','服务类型5'),(156,'2024-04-16 09:37:01','服务类型6'),(157,'2024-04-16 09:37:01','服务类型7'),(158,'2024-04-16 09:37:01','服务类型8');
/*!40000 ALTER TABLE `fuwuleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fuwupingjia`
--
DROP TABLE IF EXISTS `fuwupingjia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwupingjia` (
`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 '服务类型',
`fuwutupian` longtext COMMENT '服务图片',
`fuwupingxing` varchar(200) DEFAULT NULL COMMENT '服务评星',
`pingjiajianyi` longtext COMMENT '评价建议',
`hugonggonghao` varchar(200) DEFAULT NULL COMMENT '护工工号',
`hugongxingming` varchar(200) DEFAULT NULL COMMENT '护工姓名',
`huanzhezhanghao` varchar(200) DEFAULT NULL COMMENT '患者账号',
`huanzhexingming` varchar(200) DEFAULT NULL COMMENT '患者姓名',
`crossuserid` bigint(20) DEFAULT NULL COMMENT '跨表用户id',
`crossrefid` bigint(20) DEFAULT NULL COMMENT '跨表主键id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT='服务评价';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fuwupingjia`
--
LOCK TABLES `fuwupingjia` WRITE;
/*!40000 ALTER TABLE `fuwupingjia` DISABLE KEYS */;
INSERT INTO `fuwupingjia` VALUES (111,'2024-04-16 09:37:00','服务名称1','服务类型1','upload/fuwupingjia_fuwutupian1.jpg,upload/fuwupingjia_fuwutupian2.jpg,upload/fuwupingjia_fuwutupian3.jpg','★','评价建议1','护工工号1','护工姓名1','患者账号1','患者姓名1',1,1),(112,'2024-04-16 09:37:00','服务名称2','服务类型2','upload/fuwupingjia_fuwutupian2.jpg,upload/fuwupingjia_fuwutupian3.jpg,upload/fuwupingjia_fuwutupian4.jpg','★','评价建议2','护工工号2','护工姓名2','患者账号2','患者姓名2',2,2),(113,'2024-04-16 09:37:00','服务名称3','服务类型3','upload/fuwupingjia_fuwutupian3.jpg,upload/fuwupingjia_fuwutupian4.jpg,upload/fuwupingjia_fuwutupian5.jpg','★','评价建议3','护工工号3','护工姓名3','患者账号3','患者姓名3',3,3),(114,'2024-04-16 09:37:00','服务名称4','服务类型4','upload/fuwupingjia_fuwutupian4.jpg,upload/fuwupingjia_fuwutupian5.jpg,upload/fuwupingjia_fuwutupian6.jpg','★','评价建议4','护工工号4','护工姓名4','患者账号4','患者姓名4',4,4),(115,'2024-04-16 09:37:00','服务名称5','服务类型5','upload/fuwupingjia_fuwutupian5.jpg,upload/fuwupingjia_fuwutupian6.jpg,upload/fuwupingjia_fuwutupian7.jpg','★','评价建议5','护工工号5','护工姓名5','患者账号5','患者姓名5',5,5),(116,'2024-04-16 09:37:00','服务名称6','服务类型6','upload/fuwupingjia_fuwutupian6.jpg,upload/fuwupingjia_fuwutupian7.jpg,upload/fuwupingjia_fuwutupian8.jpg','★','评价建议6','护工工号6','护工姓名6','患者账号6','患者姓名6',6,6),(117,'2024-04-16 09:37:00','服务名称7','服务类型7','upload/fuwupingjia_fuwutupian7.jpg,upload/fuwupingjia_fuwutupian8.jpg,upload/fuwupingjia_fuwutupian9.jpg','★','评价建议7','护工工号7','护工姓名7','患者账号7','患者姓名7',7,7),(118,'2024-04-16 09:37:00','服务名称8','服务类型8','upload/fuwupingjia_fuwutupian8.jpg,upload/fuwupingjia_fuwutupian9.jpg,upload/fuwupingjia_fuwutupian10.jpg','★','评价建议8','护工工号8','护工姓名8','患者账号8','患者姓名8',8,8);
/*!40000 ALTER TABLE `fuwupingjia` 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 '创建时间',
`fuwumingcheng` varchar(200) DEFAULT NULL COMMENT '服务名称',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`fuwutupian` longtext COMMENT '服务图片',
`fuwujiage` int(11) DEFAULT NULL COMMENT '服务价格',
`yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',
`yuyuedizhi` varchar(200) DEFAULT NULL COMMENT '预约地址',
`yuyuebeizhu` varchar(200) DEFAULT NULL COMMENT '预约备注',
`hugonggonghao` varchar(200) DEFAULT NULL COMMENT '护工工号',
`hugongxingming` varchar(200) DEFAULT NULL COMMENT '护工姓名',
`huanzhezhanghao` varchar(200) DEFAULT NULL COMMENT '患者账号',
`huanzhexingming` varchar(200) DEFAULT NULL COMMENT '患者姓名',
`ispay` varchar(200) DEFAULT '未支付' 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 `fuwuyuyue`
--
LOCK TABLES `fuwuyuyue` WRITE;
/*!40000 ALTER TABLE `fuwuyuyue` DISABLE KEYS */;
INSERT INTO `fuwuyuyue` VALUES (101,'2024-04-16 09:37:00','服务名称1','服务类型1','upload/fuwuyuyue_fuwutupian1.jpg,upload/fuwuyuyue_fuwutupian2.jpg,upload/fuwuyuyue_fuwutupian3.jpg',1,'2024-04-16 17:37:00','预约地址1','预约备注1','护工工号1','护工姓名1','患者账号1','患者姓名1','未支付'),(102,'2024-04-16 09:37:00','服务名称2','服务类型2','upload/fuwuyuyue_fuwutupian2.jpg,upload/fuwuyuyue_fuwutupian3.jpg,upload/fuwuyuyue_fuwutupian4.jpg',2,'2024-04-16 17:37:00','预约地址2','预约备注2','护工工号2','护工姓名2','患者账号2','患者姓名2','未支付'),(103,'2024-04-16 09:37:00','服务名称3','服务类型3','upload/fuwuyuyue_fuwutupian3.jpg,upload/fuwuyuyue_fuwutupian4.jpg,upload/fuwuyuyue_fuwutupian5.jpg',3,'2024-04-16 17:37:00','预约地址3','预约备注3','护工工号3','护工姓名3','患者账号3','患者姓名3','未支付'),(104,'2024-04-16 09:37:00','服务名称4','服务类型4','upload/fuwuyuyue_fuwutupian4.jpg,upload/fuwuyuyue_fuwutupian5.jpg,upload/fuwuyuyue_fuwutupian6.jpg',4,'2024-04-16 17:37:00','预约地址4','预约备注4','护工工号4','护工姓名4','患者账号4','患者姓名4','未支付'),(105,'2024-04-16 09:37:00','服务名称5','服务类型5','upload/fuwuyuyue_fuwutupian5.jpg,upload/fuwuyuyue_fuwutupian6.jpg,upload/fuwuyuyue_fuwutupian7.jpg',5,'2024-04-16 17:37:00','预约地址5','预约备注5','护工工号5','护工姓名5','患者账号5','患者姓名5','未支付'),(106,'2024-04-16 09:37:00','服务名称6','服务类型6','upload/fuwuyuyue_fuwutupian6.jpg,upload/fuwuyuyue_fuwutupian7.jpg,upload/fuwuyuyue_fuwutupian8.jpg',6,'2024-04-16 17:37:00','预约地址6','预约备注6','护工工号6','护工姓名6','患者账号6','患者姓名6','未支付'),(107,'2024-04-16 09:37:00','服务名称7','服务类型7','upload/fuwuyuyue_fuwutupian7.jpg,upload/fuwuyuyue_fuwutupian8.jpg,upload/fuwuyuyue_fuwutupian9.jpg',7,'2024-04-16 17:37:00','预约地址7','预约备注7','护工工号7','护工姓名7','患者账号7','患者姓名7','未支付'),(108,'2024-04-16 09:37:00','服务名称8','服务类型8','upload/fuwuyuyue_fuwutupian8.jpg,upload/fuwuyuyue_fuwutupian9.jpg,upload/fuwuyuyue_fuwutupian10.jpg',8,'2024-04-16 17:37:00','预约地址8','预约备注8','护工工号8','护工姓名8','患者账号8','患者姓名8','未支付');
/*!40000 ALTER TABLE `fuwuyuyue` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guahaojilu`
--
DROP TABLE IF EXISTS `guahaojilu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guahaojilu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yishenggonghao` varchar(200) DEFAULT NULL COMMENT '医生工号',
`yishengxingming` varchar(200) DEFAULT NULL COMMENT '医生姓名',
`yishengtouxiang` longtext COMMENT '医生头像',
`keshimingcheng` varchar(200) DEFAULT NULL COMMENT '科室名称',
`guahaofei` int(11) DEFAULT NULL COMMENT '挂号费',
`piaoshu` int(11) DEFAULT NULL COMMENT '票数',
`riqi` varchar(200) DEFAULT NULL COMMENT '日期',
`shijian` varchar(200) DEFAULT NULL COMMENT '时间',
`huanzhezhanghao` varchar(200) DEFAULT NULL COMMENT '患者账号',
`huanzhexingming` varchar(200) DEFAULT NULL COMMENT '患者姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='挂号记录';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guahaojilu`
--
LOCK TABLES `guahaojilu` WRITE;
/*!40000 ALTER TABLE `guahaojilu` DISABLE KEYS */;
INSERT INTO `guahaojilu` VALUES (61,'2024-04-16 09:37:00','医生工号1','医生姓名1','upload/guahaojilu_yishengtouxiang1.jpg,upload/guahaojilu_yishengtouxiang2.jpg,upload/guahaojilu_yishengtouxiang3.jpg','科室名称1',1,1,'日期1','时间1','患者账号1','患者姓名1','性别1',1,'未支付',1),(62,'2024-04-16 09:37:00','医生工号2','医生姓名2','upload/guahaojilu_yishengtouxiang2.jpg,upload/guahaojilu_yishengtouxiang3.jpg,upload/guahaojilu_yishengtouxiang4.jpg','科室名称2',2,1,'日期2','时间2','患者账号2','患者姓名2','性别2',2,'未支付',2),(63,'2024-04-16 09:37:00','医生工号3','医生姓名3','upload/guahaojilu_yishengtouxiang3.jpg,upload/guahaojilu_yishengtouxiang4.jpg,upload/guahaojilu_yishengtouxiang5.jpg','科室名称3',3,1,'日期3','时间3','患者账号3','患者姓名3','性别3',3,'未支付',3),(64,'2024-04-16 09:37:00','医生工号4','医生姓名4','upload/guahaojilu_yishengtouxiang4.jpg,upload/guahaojilu_yishengtouxiang5.jpg,upload/guahaojilu_yishengtouxiang6.jpg','科室名称4',4,1,'日期4','时间4','患者账号4','患者姓名4','性别4',4,'未支付',4),(65,'2024-04-16 09:37:00','医生工号5','医生姓名5','upload/guahaojilu_yishengtouxiang5.jpg,upload/guahaojilu_yishengtouxiang6.jpg,upload/guahaojilu_yishengtouxiang7.jpg','科室名称5',5,1,'日期5','时间5','患者账号5','患者姓名5','性别5',5,'未支付',5),(66,'2024-04-16 09:37:00','医生工号6','医生姓名6','upload/guahaojilu_yishengtouxiang6.jpg,upload/guahaojilu_yishengtouxiang7.jpg,upload/guahaojilu_yishengtouxiang8.jpg','科室名称6',6,1,'日期6','时间6','患者账号6','患者姓名6','性别6',6,'未支付',6),(67,'2024-04-16 09:37:00','医生工号7','医生姓名7','upload/guahaojilu_yishengtouxiang7.jpg,upload/guahaojilu_yishengtouxiang8.jpg,upload/guahaojilu_yishengtouxiang9.jpg','科室名称7',7,1,'日期7','时间7','患者账号7','患者姓名7','性别7',7,'未支付',7),(68,'2024-04-16 09:37:00','医生工号8','医生姓名8','upload/guahaojilu_yishengtouxiang8.jpg,upload/guahaojilu_yishengtouxiang9.jpg,upload/guahaojilu_yishengtouxiang10.jpg','科室名称8',8,1,'日期8','时间8','患者账号8','患者姓名8','性别8',8,'未支付',8);
/*!40000 ALTER TABLE `guahaojilu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huanzhe`
--
DROP TABLE IF EXISTS `huanzhe`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huanzhe` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huanzhezhanghao` varchar(200) NOT NULL COMMENT '患者账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`huanzhexingming` varchar(200) NOT NULL COMMENT '患者姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
`touxiang` longtext COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `huanzhezhanghao` (`huanzhezhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='患者';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huanzhe`
--
LOCK TABLES `huanzhe` WRITE;
/*!40000 ALTER TABLE `huanzhe` DISABLE KEYS */;
INSERT INTO `huanzhe` VALUES (11,'2024-04-16 09:37:00','患者账号1','123456','患者姓名1','男',1,'13823888881','upload/huanzhe_touxiang1.jpg'),(12,'2024-04-16 09:37:00','患者账号2','123456','患者姓名2','男',2,'13823888882','upload/huanzhe_touxiang2.jpg'),(13,'2024-04-16 09:37:00','患者账号3','123456','患者姓名3','男',3,'13823888883','upload/huanzhe_touxiang3.jpg'),(14,'2024-04-16 09:37:00','患者账号4','123456','患者姓名4','男',4,'13823888884','upload/huanzhe_touxiang4.jpg'),(15,'2024-04-16 09:37:00','患者账号5','123456','患者姓名5','男',5,'13823888885','upload/huanzhe_touxiang5.jpg'),(16,'2024-04-16 09:37:00','患者账号6','123456','患者姓名6','男',6,'13823888886','upload/huanzhe_touxiang6.jpg'),(17,'2024-04-16 09:37:00','患者账号7','123456','患者姓名7','男',7,'13823888887','upload/huanzhe_touxiang7.jpg'),(18,'2024-04-16 09:37:00','患者账号8','123456','患者姓名8','男',8,'13823888888','upload/huanzhe_touxiang8.jpg');
/*!40000 ALTER TABLE `huanzhe` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `hugong`
--
DROP TABLE IF EXISTS `hugong`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hugong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`hugonggonghao` varchar(200) NOT NULL COMMENT '护工工号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`hugongxingming` varchar(200) NOT NULL COMMENT '护工姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
`touxiang` longtext COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `hugonggonghao` (`hugonggonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='护工';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `hugong`
--
LOCK TABLES `hugong` WRITE;
/*!40000 ALTER TABLE `hugong` DISABLE KEYS */;
INSERT INTO `hugong` VALUES (31,'2024-04-16 09:37:00','护工工号1','123456','护工姓名1','男','13823888881','440300199101010001','upload/hugong_touxiang1.jpg'),(32,'2024-04-16 09:37:00','护工工号2','123456','护工姓名2','男','13823888882','440300199202020002','upload/hugong_touxiang2.jpg'),(33,'2024-04-16 09:37:00','护工工号3','123456','护工姓名3','男','13823888883','440300199303030003','upload/hugong_touxiang3.jpg'),(34,'2024-04-16 09:37:00','护工工号4','123456','护工姓名4','男','13823888884','440300199404040004','upload/hugong_touxiang4.jpg'),(35,'2024-04-16 09:37:00','护工工号5','123456','护工姓名5','男','13823888885','440300199505050005','upload/hugong_touxiang5.jpg'),(36,'2024-04-16 09:37:00','护工工号6','123456','护工姓名6','男','13823888886','440300199606060006','upload/hugong_touxiang6.jpg'),(37,'2024-04-16 09:37:00','护工工号7','123456','护工姓名7','男','13823888887','440300199707070007','upload/hugong_touxiang7.jpg'),(38,'2024-04-16 09:37:00','护工工号8','123456','护工姓名8','男','13823888888','440300199808080008','upload/hugong_touxiang8.jpg');
/*!40000 ALTER TABLE `hugong` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `hugongqingjia`
--
DROP TABLE IF EXISTS `hugongqingjia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hugongqingjia` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`hugonggonghao` varchar(200) DEFAULT NULL COMMENT '护工工号',
`hugongxingming` varchar(200) DEFAULT NULL COMMENT '护工姓名',
`qingjiariqi` date DEFAULT NULL COMMENT '请假日期',
`huilairiqi` date DEFAULT NULL COMMENT '回来日期',
`qingjiayuanyin` varchar(200) DEFAULT NULL COMMENT '请假原因',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext 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 `hugongqingjia`
--
LOCK TABLES `hugongqingjia` WRITE;
/*!40000 ALTER TABLE `hugongqingjia` DISABLE KEYS */;
INSERT INTO `hugongqingjia` VALUES (131,'2024-04-16 09:37:01','护工工号1','护工姓名1','2024-04-16','2024-04-16','请假原因1','是',''),(132,'2024-04-16 09:37:01','护工工号2','护工姓名2','2024-04-16','2024-04-16','请假原因2','是',''),(133,'2024-04-16 09:37:01','护工工号3','护工姓名3','2024-04-16','2024-04-16','请假原因3','是',''),(134,'2024-04-16 09:37:01','护工工号4','护工姓名4','2024-04-16','2024-04-16','请假原因4','是',''),(135,'2024-04-16 09:37:01','护工工号5','护工姓名5','2024-04-16','2024-04-16','请假原因5','是',''),(136,'2024-04-16 09:37:01','护工工号6','护工姓名6','2024-04-16','2024-04-16','请假原因6','是',''),(137,'2024-04-16 09:37:01','护工工号7','护工姓名7','2024-04-16','2024-04-16','请假原因7','是',''),(138,'2024-04-16 09:37:01','护工工号8','护工姓名8','2024-04-16','2024-04-16','请假原因8','是','');
/*!40000 ALTER TABLE `hugongqingjia` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `hugongzhipai`
--
DROP TABLE IF EXISTS `hugongzhipai`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hugongzhipai` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`huanzhezhanghao` varchar(200) DEFAULT NULL COMMENT '患者账号',
`huanzhexingming` varchar(200) DEFAULT NULL COMMENT '患者姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`touxiang` longtext COMMENT '头像',
`hugonggonghao` varchar(200) DEFAULT NULL COMMENT '护工工号',
`hugongxingming` varchar(200) DEFAULT NULL COMMENT '护工姓名',
`zhipaishijian` date DEFAULT NULL COMMENT '指派时间',
`yishenggonghao` varchar(200) DEFAULT NULL COMMENT '医生工号',
`yishengxingming` varchar(200) DEFAULT NULL COMMENT '医生姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 COMMENT='护工指派';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `hugongzhipai`
--
LOCK TABLES `hugongzhipai` WRITE;
/*!40000 ALTER TABLE `hugongzhipai` DISABLE KEYS */;
INSERT INTO `hugongzhipai` VALUES (141,'2024-04-16 09:37:01','患者账号1','患者姓名1','性别1',1,'upload/hugongzhipai_touxiang1.jpg,upload/hugongzhipai_touxiang2.jpg,upload/hugongzhipai_touxiang3.jpg','护工工号1','护工姓名1','2024-04-16','医生工号1','医生姓名1'),(142,'2024-04-16 09:37:01','患者账号2','患者姓名2','性别2',2,'upload/hugongzhipai_touxiang2.jpg,upload/hugongzhipai_touxiang3.jpg,upload/hugongzhipai_touxiang4.jpg','护工工号2','护工姓名2','2024-04-16','医生工号2','医生姓名2'),(143,'2024-04-16 09:37:01','患者账号3','患者姓名3','性别3',3,'upload/hugongzhipai_touxiang3.jpg,upload/hugongzhipai_touxiang4.jpg,upload/hugongzhipai_touxiang5.jpg','护工工号3','护工姓名3','2024-04-16','医生工号3','医生姓名3'),(144,'2024-04-16 09:37:01','患者账号4','患者姓名4','性别4',4,'upload/hugongzhipai_touxiang4.jpg,upload/hugongzhipai_touxiang5.jpg,upload/hugongzhipai_touxiang6.jpg','护工工号4','护工姓名4','2024-04-16','医生工号4','医生姓名4'),(145,'2024-04-16 09:37:01','患者账号5','患者姓名5','性别5',5,'upload/hugongzhipai_touxiang5.jpg,upload/hugongzhipai_touxiang6.jpg,upload/hugongzhipai_touxiang7.jpg','护工工号5','护工姓名5','2024-04-16','医生工号5','医生姓名5'),(146,'2024-04-16 09:37:01','患者账号6','患者姓名6','性别6',6,'upload/hugongzhipai_touxiang6.jpg,upload/hugongzhipai_touxiang7.jpg,upload/hugongzhipai_touxiang8.jpg','护工工号6','护工姓名6','2024-04-16','医生工号6','医生姓名6'),(147,'2024-04-16 09:37:01','患者账号7','患者姓名7','性别7',7,'upload/hugongzhipai_touxiang7.jpg,upload/hugongzhipai_touxiang8.jpg,upload/hugongzhipai_touxiang9.jpg','护工工号7','护工姓名7','2024-04-16','医生工号7','医生姓名7'),(148,'2024-04-16 09:37:01','患者账号8','患者姓名8','性别8',8,'upload/hugongzhipai_touxiang8.jpg,upload/hugongzhipai_touxiang9.jpg,upload/hugongzhipai_touxiang10.jpg','护工工号8','护工姓名8','2024-04-16','医生工号8','医生姓名8');
/*!40000 ALTER TABLE `hugongzhipai` 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=199 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 (191,'2024-04-16 09:37:01',1,'用户名1','upload/messages_avatarurl1.jpg','留言内容1','upload/messages_cpicture1.jpg','回复内容1','upload/messages_rpicture1.jpg'),(192,'2024-04-16 09:37:01',2,'用户名2','upload/messages_avatarurl2.jpg','留言内容2','upload/messages_cpicture2.jpg','回复内容2','upload/messages_rpicture2.jpg'),(193,'2024-04-16 09:37:01',3,'用户名3','upload/messages_avatarurl3.jpg','留言内容3','upload/messages_cpicture3.jpg','回复内容3','upload/messages_rpicture3.jpg'),(194,'2024-04-16 09:37:01',4,'用户名4','upload/messages_avatarurl4.jpg','留言内容4','upload/messages_cpicture4.jpg','回复内容4','upload/messages_rpicture4.jpg'),(195,'2024-04-16 09:37:01',5,'用户名5','upload/messages_avatarurl5.jpg','留言内容5','upload/messages_cpicture5.jpg','回复内容5','upload/messages_rpicture5.jpg'),(196,'2024-04-16 09:37:01',6,'用户名6','upload/messages_avatarurl6.jpg','留言内容6','upload/messages_cpicture6.jpg','回复内容6','upload/messages_rpicture6.jpg'),(197,'2024-04-16 09:37:01',7,'用户名7','upload/messages_avatarurl7.jpg','留言内容7','upload/messages_cpicture7.jpg','回复内容7','upload/messages_rpicture7.jpg'),(198,'2024-04-16 09:37:01',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 `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`typename` varchar(200) DEFAULT NULL COMMENT '分类名称',
`name` varchar(200) DEFAULT NULL COMMENT '发布人',
`headportrait` longtext COMMENT '头像',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
`picture` longtext NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;
为什么选择我为什么选择我
我是程序员阿龙，专注于软件开发，拥有丰富的编程能力和实战经验。在过去的几年里，我辅导了上千名学生，帮助他们顺利完成毕业项目，同时我的技术分享也吸引了超过50W+的粉丝。我是CSDN特邀作者、博客专家、新星计划导师，并在Java领域内获得了多项荣誉，如博客之星。我的作品也被掘金、华为云、阿里云、InfoQ等多个平台推荐，成为各大平台的优质作者。
已经为上百名同学获得优秀毕业生！