/*
 Navicat Premium Data Transfer

 Source Server         : chen
 Source Server Type    : MySQL
 Source Server Version : 80033 (8.0.33)
 Source Host           : localhost:3306
 Source Schema         : hospital

 Target Server Type    : MySQL
 Target Server Version : 80033 (8.0.33)
 File Encoding         : 65001

 Date: 16/05/2024 21:39:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '账号',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
  `headPhoto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (2, 'admin', 'admin', 'admin', '13888888888', '1234@163.com', 'http://localhost:8081/api/file/download/1713720337703_哥斯拉.', 'ADMIN');
INSERT INTO `admin` VALUES (5, 'chen', '陈杰', '123456', '13688098546', 'c1718605971@163.com', 'http://localhost:8081/api/file/download/震惊.jpg', 'ADMIN');
INSERT INTO `admin` VALUES (46, 'cxq', '陈雪琴', '123456', '19881153896', '1234@163.com', 'http://localhost:8081/api/file/download/Snipaste_2024-04-22_13-56-14.jpg', 'ADMIN');

-- ----------------------------
-- Table structure for administrative
-- ----------------------------
DROP TABLE IF EXISTS `administrative`;
CREATE TABLE `administrative`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `DepartmentName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '科室名称',
  `DepartmentDescription` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '科室描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '科室信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of administrative
-- ----------------------------
INSERT INTO `administrative` VALUES (1, '儿科', '这是儿科');
INSERT INTO `administrative` VALUES (2, '外科', '这是外科');
INSERT INTO `administrative` VALUES (3, '内科', '这是内科');
INSERT INTO `administrative` VALUES (4, '耳鼻喉科', '这是耳鼻喉科');
INSERT INTO `administrative` VALUES (5, '骨科', '这是骨科');
INSERT INTO `administrative` VALUES (6, '放射科', '这是放射科');

-- ----------------------------
-- Table structure for announcement
-- ----------------------------
DROP TABLE IF EXISTS `announcement`;
CREATE TABLE `announcement`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '标题',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '内容',
  `creat_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '公告信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of announcement
-- ----------------------------
INSERT INTO `announcement` VALUES (1, '完成了公告信息页面', '完成了公告信息页面', '2024-04-24', '陈杰');
INSERT INTO `announcement` VALUES (5, '科室信息', '完成了科室信息', '2024-04-24', '陈杰');
INSERT INTO `announcement` VALUES (6, '医生排班', '完成了医生排班', '2024-04-24', '陈杰');
INSERT INTO `announcement` VALUES (10, '完成了从请求头中获取用户名', '完成了从请求头中获取用户名', '2024-04-24', '陈杰');
INSERT INTO `announcement` VALUES (11, '系统功能初步完成，可以使用了', '系统功能初步完成', '2024-04-24', '陈杰');
INSERT INTO `announcement` VALUES (14, '公告信息页面查询条件修改为了以公告内容和创建人查询并删除了标题', '公告信息页面查询条件修改为了以公告内容和创建人查询并删除了标题', '2024-04-25', 'admin');

-- ----------------------------
-- Table structure for doctor
-- ----------------------------
DROP TABLE IF EXISTS `doctor`;
CREATE TABLE `doctor`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '账号',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',
  `intro` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '简介',
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '挂号费',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
  `work_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '入职时间',
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '职位',
  `headPhoto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色',
  `administrativeId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '科室id\'',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '医生信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of doctor
-- ----------------------------
INSERT INTO `doctor` VALUES (1, 'zhangsan', '张医生', '主任医师，副院长，1985年毕业于解放军第三军医大学医疗系，获学士学位。广东省全科医师分会委员，天河区全科医师分会副秘书长。从事内科临床工作30年，开设糖尿病内分泌专科门诊16年，在糖尿病等老年慢性病及内科常见疾病诊治方面具有丰富的临床经验。', '25', '123456', '13988889999', '123@163.com', '2024-04-02', '主任医生', 'http://localhost:8081/api/file/download/1713720337703_哥斯拉.', 'DOCTOR', '5');
INSERT INTO `doctor` VALUES (2, 'lisi', '李医生', '医学硕士，心血管主任医师，毕业后一直在三甲医院从事临床一线工作，2004年调入华工医院，2010年在中山医附属第一医院CCU进修，有二十余年临床工作经验，擅长高血压病、冠心病、心律失常等常见心血管疾病的诊治。', '10', '123456', '13688098546', 'c1718605971@163.com', '2024-04-08', '副主任医师', 'http://localhost:8081/api/file/download/1713769007683_震惊.', 'DOCTOR', '2');
INSERT INTO `doctor` VALUES (3, 'zhao', '赵医生', '副主任医师，本科毕业于中南大学湘雅医学院，硕士毕业于中山大学。有多年三甲医院工作经验，曾在华侨医院进修消化内科。擅长内科常见病的诊断及治疗，尤其擅长肝病及呼吸内科疾病的治疗。', '20', '123456', '3688098546', 'c1718605971@163.com', '2024-04-01', '副主任医师', 'http://localhost:8081/api/file/download/1713948116952_06.', 'DOCTOR', '1');
INSERT INTO `doctor` VALUES (4, 'qian', '钱医生', '医学硕士，2012年毕业于中山大学医学院，曾在中山大学第二附属医院急诊科和广州医学院附属第二医院神经内科进修。2013年来我院工作，擅长神经内科如脑中风、偏头痛、帕金森等常见病、多发病及疑难病症的诊断与治疗。', '30', '123456', '3688098546', 'c1718605971@163.com', '2024-04-10', '主任医师', 'http://localhost:8081/api/file/download/1713948239137_屏幕截图 2023-03-27 121017.', 'DOCTOR', '3');

-- ----------------------------
-- Table structure for hospital
-- ----------------------------
DROP TABLE IF EXISTS `hospital`;
CREATE TABLE `hospital`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `patientName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '患者姓名',
  `roomNumber` int NULL DEFAULT NULL COMMENT '房号',
  `roomPrice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '费用',
  `payFeeState` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '缴费状态',
  `hospitalInsurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否医保',
  `roomState` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '住院状态',
  `patientAttendanceId` int NULL DEFAULT NULL COMMENT '患者就诊id',
  `patientAttendanceAppointmentTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '患者就诊时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '住院登记表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hospital
-- ----------------------------
INSERT INTO `hospital` VALUES (15, '王五', 101, '1200', '1', '1', '1', 16, '2024-04-25');

-- ----------------------------
-- Table structure for patient
-- ----------------------------
DROP TABLE IF EXISTS `patient`;
CREATE TABLE `patient`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `PatientName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '患者姓名',
  `DoctorName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '医生姓名',
  `AppointmentTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '预约时间',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '挂号状态 -1 待叫号 1 已叫号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '患者挂号表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of patient
-- ----------------------------
INSERT INTO `patient` VALUES (22, '王五', '李医生', '2024-04-27 08:00:00', '1');
INSERT INTO `patient` VALUES (23, '王五', '李医生', '2024-04-27 23:40:41', '-1');
INSERT INTO `patient` VALUES (24, '王五', '李医生', '2024-04-29 00:00:00', '-1');

-- ----------------------------
-- Table structure for patient_attendance
-- ----------------------------
DROP TABLE IF EXISTS `patient_attendance`;
CREATE TABLE `patient_attendance`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `PatientName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '患者姓名',
  `DoctorName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '医生姓名',
  `AppointmentTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '就诊时间',
  `doctorAdvice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '医嘱病历',
  `inHospital` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否住院',
  `checkIn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否住院登记',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '患者就诊表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of patient_attendance
-- ----------------------------
INSERT INTO `patient_attendance` VALUES (16, '王五', '李医生', '2024-04-25', '多读书，多看报，少吃零食，多睡觉', '1', '是');
INSERT INTO `patient_attendance` VALUES (17, '王五', '李医生', '2024-04-27 08:00:00', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, 'ADMIN');
INSERT INTO `role` VALUES (2, 'DOCTOR');
INSERT INTO `role` VALUES (3, 'USER');

-- ----------------------------
-- Table structure for scheduling
-- ----------------------------
DROP TABLE IF EXISTS `scheduling`;
CREATE TABLE `scheduling`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `doctor_id` int NULL DEFAULT NULL COMMENT '医生id',
  `num` int NULL DEFAULT NULL COMMENT '就诊数量',
  `week` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '排班日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '排班信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of scheduling
-- ----------------------------
INSERT INTO `scheduling` VALUES (17, 1, 10, '星期一');
INSERT INTO `scheduling` VALUES (18, 2, 10, '星期一');
INSERT INTO `scheduling` VALUES (19, 3, 10, '星期一');
INSERT INTO `scheduling` VALUES (20, 4, 10, '星期一');
INSERT INTO `scheduling` VALUES (21, 1, 10, '星期二');
INSERT INTO `scheduling` VALUES (22, 2, 10, '星期二');
INSERT INTO `scheduling` VALUES (23, 3, 10, '星期二');
INSERT INTO `scheduling` VALUES (24, 4, 10, '星期二');
INSERT INTO `scheduling` VALUES (25, 1, 10, '星期三');
INSERT INTO `scheduling` VALUES (26, 2, 10, '星期三');
INSERT INTO `scheduling` VALUES (27, 3, 10, '星期三');
INSERT INTO `scheduling` VALUES (28, 4, 10, '星期三');
INSERT INTO `scheduling` VALUES (29, 1, 10, '星期四');
INSERT INTO `scheduling` VALUES (30, 2, 10, '星期四');
INSERT INTO `scheduling` VALUES (31, 3, 10, '星期四');
INSERT INTO `scheduling` VALUES (32, 4, 10, '星期四');
INSERT INTO `scheduling` VALUES (33, 1, 10, '星期五');
INSERT INTO `scheduling` VALUES (34, 2, 10, '星期五');
INSERT INTO `scheduling` VALUES (35, 3, 10, '星期五');
INSERT INTO `scheduling` VALUES (36, 4, 10, '星期五');
INSERT INTO `scheduling` VALUES (37, 1, 0, '星期六');
INSERT INTO `scheduling` VALUES (38, 2, 3, '星期六');
INSERT INTO `scheduling` VALUES (39, 3, 10, '星期六');
INSERT INTO `scheduling` VALUES (40, 4, 10, '星期六');
INSERT INTO `scheduling` VALUES (41, 1, 10, '星期日');
INSERT INTO `scheduling` VALUES (42, 2, 10, '星期日');
INSERT INTO `scheduling` VALUES (43, 3, 10, '星期日');
INSERT INTO `scheduling` VALUES (44, 4, 10, '星期日');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '账号',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
  `headPhoto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色',
  `price` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户余额',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (2, 'wangwu', '王五', '123456', '13888888888', '123@163.com', 'http://localhost:8081/api/file/download/1713770240039_哥斯拉.', 'USER', '100');
INSERT INTO `user` VALUES (7, 'zhaoliu', '赵六', '123456', '20240406', '1234@163.com', 'http://localhost:8081/api/file/download/1713771282400_震惊.', 'USER', '200');
INSERT INTO `user` VALUES (12, '123', NULL, '123', NULL, NULL, NULL, 'USER', NULL);

SET FOREIGN_KEY_CHECKS = 1;