摘要针对医院窗口挂号排队久、分诊依赖人工经验、候诊信息不透明等问题本文设计并实现医院在线挂号预约与分诊系统。系统采用 Spring Boot 与 Vue 前后端分离架构并配套 uni-app 小程序面向管理员、医生和患者三类角色。患者可按症状智能分诊、浏览号源并完成预约支付实时查看候诊进度医生可维护排班、叫号接诊并开具检查与药品管理员负责科室医生、医保审核、号源规则及运行统计。系统将挂号费、医保抵扣、急诊优先与排队号纳入统一闭环结合大模型辅助分诊与本院目录约束的用药检查建议提升门诊资源配置效率。需求分析明确管理员、医生、患者的权限边界与核心业务流程系统设计给出总体架构、数据库表结构与REST接口划分并对系统重点业务模块的实现思路进行说明。经功能与流程测试验证主要业务可闭环运行能够支撑医院在线挂号预约与分诊系统的演示与应用需求为同类信息化系统建设提供参考。技术栈Spring Boot3uni-appVue3uViewPlusViteMybatsiPlusAI大模型微信小程序数据库表18张创新点症状驱动的AI大模型智能分诊推荐、医院目录约束的检查用药建议、排队号与时长预估的候诊进度、医生叫号接诊与就诊闭环、医保核验审核与挂号抵扣演示视频医院在线挂号预约与分诊小程序文末获取联系文末获取联系作者介绍专注计算机编程个人开发坚持原创非工作室源码全网唯一。✅技术主流SpringBootVueuni-app前后端分离MySQLAI大模型可本地运行✅配套资料源码 数据库 实验报告/论文 答辩 PPT部署演示远程调试问题解答技术范围AI大模型、智能算法、SpringBoot、Vue、数据可视化、小程序、HLMT、Nodejs、uni-app、MySQL数据库、ElementUi等设计与开发。适用范围软件工程、软件技术、计算机科学与技术、大数据、云计算、JavaWeb开发、JavaEE、Java、Web应用开发、动态网页设计、小程序的毕设参考开发文档创新点说明、功能需求分析、数据库表结构设计、后端接口设计、创新点代码分析功能展示患者用户序号菜单名称功能描述1患者首页汇总智能分诊、号源预约、我的预约和医保绑定等常用入口。2智能分诊患者填写症状后由系统推荐科室与医生并给出是否建议急诊等提示。3医生号源按科室浏览医生卡片及可预约排班进入详情查看出诊时段。4预约挂号选择号源时段后确认费用、医保抵扣与优先级完成支付生成排队号。5我的预约查看待支付、候诊中、已完成等预约列表进入详情或取消预约。6候诊进度展示当日排队号、前方人数和预估等待时长并随叫号刷新。7医保绑定填写医保号并上传凭证提交后等待管理员审核。8医院公告浏览医院发布的停诊、就诊须知等公告正文。9候诊提醒接收叫号、候诊和预约状态变更消息支持已读处理医生序号菜单名称功能描述1候诊队列按当日排队号展示本科室候诊患者支持叫下一号并进入接诊。2接诊工作台对当前预约书写病历、开具检查与药品可调用 AI 起草病历和建议项目后完成就诊。3医生资料医生查看并更新本人简介、擅长方向与出诊相关资料。4病历模板维护个人或公用病历模板接诊时快速套用主诉、诊断与处理意见结构。5排班号源按日期与上下午设置出诊时段、号源数量和挂号价格控制可预约库存。6预约记录查询本人名下历史与当日预约核对患者信息和就诊状态。管理员序号菜单名称功能描述1数据统计按科室、医生和日期汇总挂号量、候诊与完成就诊等指标以图表展示门诊运行概况。2患者管理分页维护患者档案支持检索、编辑、拉黑以及查看医保绑定与核验状态。3医生管理维护医生账号、所属科室、职称与出诊资料支持新增、编辑、审核启用与删除。4科室管理维护内科、外科等科室树形分类供号源挂靠与分诊推荐使用。5预约管理按患者、医生、状态查询全院预约单可查看进度、协助取消或核对费用。6医保审核审核患者提交的医保号与凭证通过后用于挂号费抵扣驳回需填写原因。7检查项目维护血常规、心电图等检查目录的名称、价格与启用状态供接诊开单选用。8号源规则配置各时段平均接诊时长等规则用于计算前方人数对应的预估候诊时间。9药品管理维护门诊常用药品的规格、库存、用法与价格供医生开药时匹配本院目录。10公告管理发布、编辑和上下架医院公告患者端与小程序同步展示。11管理员账号维护后台管理员账号的创建、编辑、启用禁用与删除。数据库及架构系统数据库设计为数据库设计SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS 0; -- ---------------------------- -- Table structure for admins -- ---------------------------- DROP TABLE IF EXISTS admins; CREATE TABLE admins ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 账号, password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 密码, name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 姓名, phone varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 手机号, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX username(username) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 3 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 管理员 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for categories -- ---------------------------- DROP TABLE IF EXISTS categories; CREATE TABLE categories ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 科室名称, parent_id bigint(20) NULL DEFAULT 0 COMMENT 父科室, description varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 科室简介, sort_order int(11) NULL DEFAULT 0 COMMENT 排序, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 科室 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for doctors -- ---------------------------- DROP TABLE IF EXISTS doctors; CREATE TABLE doctors ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 账号, password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 密码, name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 医生姓名, phone varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 联系电话, avatar varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 头像, shop_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 职称, shop_logo varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 照片, shop_desc text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 医生简介, category_id bigint(20) NULL DEFAULT NULL COMMENT 所属科室主/子科室子科室优先, parent_category_id bigint(20) NULL DEFAULT NULL COMMENT 主科室, default_slot_quota int(11) NULL DEFAULT 10 COMMENT 默认每时段号源数量批量排班参考, status tinyint(4) NULL DEFAULT 0 COMMENT 审核状态 0待审 1通过 -1驳回, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX username(username) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 医生 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for drugs -- ---------------------------- DROP TABLE IF EXISTS drugs; CREATE TABLE drugs ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, name varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 药品名称, spec varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 规格, unit varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 单位, price decimal(10, 2) NULL DEFAULT 0.00 COMMENT 单价, manufacturer varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 生产厂家, stock int(11) NULL DEFAULT 0 COMMENT 库存, usage_desc varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 用法说明, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 药品库 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for exam_items -- ---------------------------- DROP TABLE IF EXISTS exam_items; CREATE TABLE exam_items ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, name varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 检查项目名称, price decimal(10, 2) NULL DEFAULT 0.00 COMMENT 单价, unit varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 单位, remark varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 备注说明, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 检查项目库 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for exam_reports -- ---------------------------- DROP TABLE IF EXISTS exam_reports; CREATE TABLE exam_reports ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, order_id bigint(20) NULL DEFAULT NULL COMMENT 预约单, prescription_id bigint(20) NULL DEFAULT NULL COMMENT 关联检查项目, user_id bigint(20) NOT NULL COMMENT 患者, title varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 报告名称, file_url varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 报告文件, content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 报告摘要, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 出具时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 3 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 检查报告 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for medical_records -- ---------------------------- DROP TABLE IF EXISTS medical_records; CREATE TABLE medical_records ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, order_id bigint(20) NOT NULL COMMENT 预约单, user_id bigint(20) NOT NULL COMMENT 患者, doctor_id bigint(20) NOT NULL COMMENT 医生, chief_complaint text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 主诉, diagnosis text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 诊断, treatment text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 处理意见, content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 完整病历, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间, updated_at datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 更新时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 病历 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for merchants -- ---------------------------- DROP TABLE IF EXISTS merchants; CREATE TABLE merchants ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 账号, password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 密码, name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 医生姓名, phone varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 联系电话, avatar varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 头像, shop_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 职称, shop_logo varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 照片, shop_desc text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 医生简介, category_id bigint(20) NULL DEFAULT NULL COMMENT 所属科室, default_slot_quota int(11) NULL DEFAULT 10 COMMENT 默认每时段号源数量批量排班参考, status tinyint(4) NULL DEFAULT 0 COMMENT 审核状态 0待审 1通过 -1驳回, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX username(username) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 3 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 医生 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for notices -- ---------------------------- DROP TABLE IF EXISTS notices; CREATE TABLE notices ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, title varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 标题, content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 内容, status tinyint(4) NULL DEFAULT 1 COMMENT 状态, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 发布时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 公告 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for notifications -- ---------------------------- DROP TABLE IF EXISTS notifications; CREATE TABLE notifications ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, user_id bigint(20) NOT NULL COMMENT 患者, order_id bigint(20) NULL DEFAULT NULL COMMENT 预约单, title varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 标题, content varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 内容, is_read tinyint(4) NULL DEFAULT 0 COMMENT 是否已读, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间, PRIMARY KEY (id) USING BTREE, INDEX idx_user_read(user_id, is_read) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 候诊提醒 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for order_items -- ---------------------------- DROP TABLE IF EXISTS order_items; CREATE TABLE order_items ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, order_id bigint(20) NOT NULL COMMENT 预约单, schedule_id bigint(20) NULL DEFAULT NULL COMMENT 号源, schedule_name varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 号源名称, price decimal(10, 2) NULL DEFAULT 0.00 COMMENT 单价, quantity int(11) NULL DEFAULT 1 COMMENT 数量, subtotal decimal(10, 2) NULL DEFAULT 0.00 COMMENT 小计, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 7 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 预约明细 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for order_status_logs -- ---------------------------- DROP TABLE IF EXISTS order_status_logs; CREATE TABLE order_status_logs ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, order_id bigint(20) NOT NULL COMMENT 预约单, from_status tinyint(4) NULL DEFAULT NULL COMMENT 原状态, to_status tinyint(4) NOT NULL COMMENT 新状态, operator_id bigint(20) NULL DEFAULT NULL COMMENT 操作人, operator_role varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 操作角色, remark varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 备注, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 操作时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 11 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 预约状态日志 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for orders -- ---------------------------- DROP TABLE IF EXISTS orders; CREATE TABLE orders ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, order_no varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 预约单号, user_id bigint(20) NOT NULL COMMENT 患者, doctor_id bigint(20) NOT NULL COMMENT 医生, schedule_id bigint(20) NULL DEFAULT NULL COMMENT 号源, category_id bigint(20) NULL DEFAULT NULL COMMENT 科室, schedule_date date NULL DEFAULT NULL COMMENT 就诊日期, time_slot varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 就诊时段, total_amount decimal(10, 2) NULL DEFAULT 0.00 COMMENT 挂号费, discount_amount decimal(10, 2) NULL DEFAULT 0.00 COMMENT 医保抵扣, pay_amount decimal(10, 2) NULL DEFAULT 0.00 COMMENT 实付, use_insurance tinyint(4) NULL DEFAULT 0 COMMENT 是否使用医保, priority tinyint(4) NULL DEFAULT 0 COMMENT 0普通1复诊2急诊, queue_no int(11) NULL DEFAULT NULL COMMENT 当日排队序号, queue_status tinyint(4) NULL DEFAULT 0 COMMENT 0未入队1候诊2叫号中3接诊中4完成, status tinyint(4) NULL DEFAULT 0 COMMENT 0待支付1候诊2叫号3接诊4完成5取消, remark varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 备注, order_time datetime NULL DEFAULT NULL COMMENT 预约时间, pay_time datetime NULL DEFAULT NULL COMMENT 支付时间, called_at datetime NULL DEFAULT NULL COMMENT 叫号时间, finish_time datetime NULL DEFAULT NULL COMMENT 完成时间, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX order_no(order_no) USING BTREE, INDEX idx_doctor_queue(doctor_id, schedule_date, queue_no) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 7 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 预约挂号 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for prescriptions -- ---------------------------- DROP TABLE IF EXISTS prescriptions; CREATE TABLE prescriptions ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, order_id bigint(20) NOT NULL COMMENT 预约单, record_id bigint(20) NULL DEFAULT NULL COMMENT 病历, drug_id bigint(20) NULL DEFAULT NULL COMMENT 关联药品开药时, type varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT DRUG COMMENT DRUG药品 EXAM检查, item_name varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 项目/药品名, dosage varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 用法用量, quantity int(11) NULL DEFAULT 1 COMMENT 数量, unit_price decimal(10, 2) NULL DEFAULT 0.00 COMMENT 单价, amount decimal(10, 2) NULL DEFAULT 0.00 COMMENT 金额quantity*unit_price, remark varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 备注, created_at datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 开具时间, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 10 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 处方检查 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for quota_rules -- ---------------------------- DROP TABLE IF EXISTS quota_rules; CREATE TABLE quota_rules ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, rule_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 规则名称, advance_days int(11) NULL DEFAULT 7 COMMENT 可提前预约天数, avg_minutes int(11) NULL DEFAULT 12 COMMENT 平均接诊分钟数候诊预估, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 3 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 号源规则 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for record_templates -- ---------------------------- DROP TABLE IF EXISTS record_templates; CREATE TABLE record_templates ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, doctor_id bigint(20) NULL DEFAULT NULL COMMENT 医生, title varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 模板名称, content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 模板内容, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 病历模板 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for schedules -- ---------------------------- DROP TABLE IF EXISTS schedules; CREATE TABLE schedules ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, doctor_id bigint(20) NOT NULL COMMENT 医生, category_id bigint(20) NULL DEFAULT NULL COMMENT 科室, name varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 排班标题, description varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 说明, main_image varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 图片, price decimal(10, 2) NULL DEFAULT 0.00 COMMENT 挂号费, schedule_date date NULL DEFAULT NULL COMMENT 出诊日期, time_slot varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 时段 如09:00-09:30, stock int(11) NULL DEFAULT 0 COMMENT 号源余量医生设定, sales int(11) NULL DEFAULT 0 COMMENT 已预约数, status tinyint(4) NULL DEFAULT 1 COMMENT 状态 1可预约 2已过期, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE, INDEX idx_schedule(doctor_id, schedule_date, time_slot) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 11 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 排班号源 ROW_FORMAT Dynamic; -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS users; CREATE TABLE users ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键, username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 账号, password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 密码, name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 姓名, phone varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 手机号, avatar varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 头像, id_card varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 身份证号, insurance_no varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 医保号, insurance_card_url varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 医保电子凭证照片, insurance_audit_status tinyint(4) NULL DEFAULT 0 COMMENT 医保审核 0未提交1待审核2已通过3已驳回, insurance_audit_remark varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 医保审核备注, insurance_verified tinyint(4) NULL DEFAULT 0 COMMENT 医保是否核验 0否1是audit_status2时为1, blacklisted tinyint(4) NULL DEFAULT 0 COMMENT 是否黑名单 0否1是, enabled tinyint(4) NULL DEFAULT 1 COMMENT 是否启用, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX username(username) USING BTREE ) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 患者 ROW_FORMAT Dynamic; SET FOREIGN_KEY_CHECKS 1;擅长功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文编写和辅导、论文降重、长期答辩答疑辅导、腾讯会议一对一专业讲解辅导答辩、模拟答辩演练、和理解代码逻辑思路等。获取联系项目功能完整可在本地运行并可远程调试确保运行顺利获取联系方式毕业设计获取https://blog.csdn.net/qq_59059632/article/details/163759879?spm1011.2415.3001.5331