登录 注册
开源 企业版 高校版 私有云 模力方舟
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 0

米豆/health

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
health.sql 50.15 KB
一键复制 编辑 原始数据 按行查看 历史
米豆 提交于 2024-01-24 08:31 +08:00 . 数据库
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435
/*

 Navicat Premium Data Transfer



 Source Server         : mysql80

 Source Server Type    : MySQL

 Source Server Version : 80033

 Source Host           : localhost:3306

 Source Schema         : hospital



 Target Server Type    : MySQL

 Target Server Version : 80033

 File Encoding         : 65001



 Date: 19/01/2024 19:13:27

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for department

-- ----------------------------

DROP TABLE IF EXISTS `department`;

CREATE TABLE `department`  (

  `id` int(0) NOT NULL AUTO_INCREMENT,

  `hoscode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '给医院分配的唯一标识',

  `depcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '科室编号',

  `depname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '科室名称',

  `intro` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '科室描述',

  `bigcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '大科室编号',

  `bigname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '大科室名称',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '详情地址',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hospital

-- ----------------------------

DROP TABLE IF EXISTS `hospital`;

CREATE TABLE `hospital`  (

  `id` int(0) NOT NULL AUTO_INCREMENT,

  `hoscode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '给医院分配的唯一标识',

  `hosname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '医院名称',

  `hostype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '医院类型(1:三级甲等,2:三级乙等,3:二级甲等,4:二级乙等,5:一级)',

  `provinceCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省code',

  `cityCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市code',

  `districtCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区code',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '详情地址',

  `logoData` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '医院logo',

  `intro` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '医院简介',

  `route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '坐车路线',

  `bookingRule` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预约规则',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for hospital_set

-- ----------------------------

DROP TABLE IF EXISTS `hospital_set`;

CREATE TABLE `hospital_set`  (

  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `hosname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '医院名称',

  `hoscode` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '医院编号',

  `api_url` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'api基础路径',

  `sign_key` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '签名秘钥',

  `contacts_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系人',

  `contacts_phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系人手机',

  `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '状态',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_hoscode`(`hoscode`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '医院设置表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of hospital_set

-- ----------------------------

INSERT INTO `hospital_set` VALUES (10, '北京协和医院', '1000_0', 'http://localhost:8201', '888', '测试', '120', 1, '2022-09-06 07:56:10', '2022-09-08 11:59:37', 0);



-- ----------------------------

-- Table structure for order_info

-- ----------------------------

DROP TABLE IF EXISTS `order_info`;

CREATE TABLE `order_info`  (

  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `schedule_id` bigint(0) NULL DEFAULT NULL COMMENT '排班id',

  `patient_id` bigint(0) NULL DEFAULT NULL COMMENT '就诊人id',

  `number` int(0) NULL DEFAULT NULL COMMENT '预约号序',

  `fetch_time` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '建议取号时间',

  `fetch_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '取号地点',

  `amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '医事服务费',

  `pay_time` datetime(0) NULL DEFAULT NULL COMMENT '支付时间',

  `quit_time` datetime(0) NULL DEFAULT NULL COMMENT '退号时间',

  `order_status` tinyint(0) NULL DEFAULT NULL COMMENT '订单状态',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of order_info

-- ----------------------------

INSERT INTO `order_info` VALUES (23, 1, 1, 24, '1 14:00前', '一楼9号窗口', 100, NULL, '2022-09-10 10:18:44', -1, '2022-09-10 02:10:42', '2022-09-10 02:10:42', 0);

INSERT INTO `order_info` VALUES (24, 1, 1, 25, '1 14:00前', '一楼9号窗口', 100, '2022-09-10 10:22:44', '2022-09-10 10:22:54', -1, '2022-09-10 02:22:17', '2022-09-10 02:22:17', 0);

INSERT INTO `order_info` VALUES (25, 1, 1, 26, '1 14:00前', '一楼9号窗口', 100, '2022-09-10 10:28:00', '2022-09-10 10:28:13', -1, '2022-09-10 02:27:30', '2022-09-10 02:27:30', 0);

INSERT INTO `order_info` VALUES (26, 1, 1, 27, '1 14:00前', '一楼9号窗口', 100, NULL, '2022-09-10 22:35:01', -1, '2022-09-10 02:28:57', '2022-09-10 02:28:57', 0);

INSERT INTO `order_info` VALUES (27, 1, 1, 28, '1 14:00前', '一楼9号窗口', 100, '2022-09-10 18:00:02', NULL, 1, '2022-09-10 09:59:43', '2022-09-10 09:59:43', 0);

INSERT INTO `order_info` VALUES (28, 1, 1, 29, '1 14:00前', '一楼9号窗口', 100, '2022-09-10 20:48:55', NULL, 1, '2022-09-10 12:48:40', '2022-09-10 12:48:40', 0);

INSERT INTO `order_info` VALUES (29, 1, 1, 30, '1 14:00前', '一楼9号窗口', 100, '2022-09-11 13:38:53', NULL, 1, '2022-09-11 05:38:35', '2022-09-11 05:38:35', 0);



-- ----------------------------

-- Table structure for patient

-- ----------------------------

DROP TABLE IF EXISTS `patient`;

CREATE TABLE `patient`  (

  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(0) NULL DEFAULT NULL COMMENT '用户id',

  `name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '姓名',

  `certificates_type` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '证件类型',

  `certificates_no` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '证件编号',

  `sex` tinyint(0) NULL DEFAULT NULL COMMENT '性别',

  `birthdate` date NULL DEFAULT NULL COMMENT '出生年月',

  `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机',

  `is_marry` tinyint(0) NULL DEFAULT NULL COMMENT '是否结婚',

  `province_code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '省code',

  `city_code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '市code',

  `district_code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '区code',

  `address` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '详情地址',

  `contacts_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系人姓名',

  `contacts_certificates_type` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系人证件类型',

  `contacts_certificates_no` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系人证件号',

  `contacts_phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系人手机',

  `card_no` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '就诊卡号',

  `is_insure` tinyint(0) NULL DEFAULT 0 COMMENT '是否有医保',

  `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '状态（0：默认 1：已认证）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '就诊人表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of patient

-- ----------------------------

INSERT INTO `patient` VALUES (1, 14, '刘川', '10', '510181200010146733', 1, '2022-08-01', '15828145845', 0, '110000', '110100', '110105', '北京市市辖区朝阳区111号', '刘川', '10', '510181200010146733', '15828145845', '63453453453453453', 0, 0, '2022-08-24 23:32:28', '2022-08-25 12:23:00', 1);

INSERT INTO `patient` VALUES (8, 14, '刘川', '10', '510181200010146733', 1, '2022-08-01', '15828145845', 0, '130000', '130100', '130101', '66街道22社区', '', '', '', '', NULL, 0, 0, '2022-08-25 12:22:30', '2022-08-25 13:58:35', 0);

INSERT INTO `patient` VALUES (9, 14, '测试2', '10', '510181200010113333', 1, '2022-08-08', '15828145555', 0, '110000', '110100', '110105', '66街道22社区', '测试', '10', '510181200010113333', '15821845845', NULL, 0, 0, '2022-08-25 12:36:24', '2022-08-25 23:40:34', 1);

INSERT INTO `patient` VALUES (10, 14, '测试2', '20', '510181200012222222', 1, '2022-07-31', '15872184222', 0, '110000', '110100', '110105', '红牌楼666号 ', '', '', '', '', NULL, 0, 0, '2022-08-25 12:40:36', '2022-08-25 23:40:36', 1);

INSERT INTO `patient` VALUES (11, 14, '测试3', '10', '510181200011323333', 0, '2022-08-08', '15828145845', 0, '110000', '110100', '110105', '东街2号院', '', '', '', '', NULL, 0, 0, '2022-08-25 12:42:24', '2022-08-25 23:40:39', 1);

INSERT INTO `patient` VALUES (12, 14, '111', '10', '1231112312321', 1, '2022-07-31', '123131', 0, '110000', '110100', '110118', '666号', '', '', '', '', NULL, 0, 0, '2022-08-25 17:21:20', '2022-08-25 23:40:31', 1);

INSERT INTO `patient` VALUES (13, 16, '张三', '10', '5101812131213123123', 1, '2022-07-31', '12312312312', 0, '130000', '130300', '130303', '11111号街区', '', '', '', '', NULL, 0, 0, '2022-08-25 20:22:31', '2022-08-25 20:22:31', 0);



-- ----------------------------

-- Table structure for payment_info

-- ----------------------------

DROP TABLE IF EXISTS `payment_info`;

CREATE TABLE `payment_info`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `out_trade_no` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '对外业务编号',

  `order_id` bigint(0) NULL DEFAULT NULL COMMENT '订单id',

  `payment_type` tinyint(1) NULL DEFAULT NULL COMMENT '支付类型（微信 支付宝）',

  `trade_no` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '交易编号',

  `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',

  `subject` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '交易内容',

  `payment_status` tinyint(0) NULL DEFAULT NULL COMMENT '支付状态',

  `callback_time` datetime(0) NULL DEFAULT NULL COMMENT '回调时间',

  `callback_content` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '回调信息',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_out_trade_no`(`out_trade_no`) USING BTREE,

  INDEX `idx_order_id`(`order_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '支付信息表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Table structure for refund_info

-- ----------------------------

DROP TABLE IF EXISTS `refund_info`;

CREATE TABLE `refund_info`  (

  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `out_trade_no` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '对外业务编号',

  `order_id` bigint(0) NULL DEFAULT NULL COMMENT '订单编号',

  `payment_type` tinyint(0) NULL DEFAULT NULL COMMENT '支付类型（微信 支付宝）',

  `trade_no` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '交易编号',

  `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '退款金额',

  `subject` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '交易内容',

  `refund_status` tinyint(0) NULL DEFAULT NULL COMMENT '退款状态',

  `callback_content` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '回调信息',

  `callback_time` datetime(0) NULL DEFAULT NULL,

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_out_trade_no`(`out_trade_no`) USING BTREE,

  INDEX `idx_order_id`(`order_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '退款信息表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of refund_info

-- ----------------------------

INSERT INTO `refund_info` VALUES (1, '166277653713657', 73, 2, '50301903082022091024734822526', 100.00, '2022-09-10|北京协和医院|多发性硬化专科门诊|副主任医师', 2, '{\"transaction_id\":\"4200001569202209101083700360\",\"nonce_str\":\"FUfbT45tigY7Y5ba\",\"out_refund_no\":\"tk166277653713657\",\"sign\":\"98F14A3C70E944D1915FE324D529D79D\",\"return_msg\":\"OK\",\"mch_id\":\"1558950191\",\"refund_id\":\"50301903082022091024734822526\",\"cash_fee\":\"1\",\"out_trade_no\":\"166277653713657\",\"coupon_refund_fee\":\"0\",\"refund_channel\":\"\",\"appid\":\"wx74862e0dfcf69954\",\"refund_fee\":\"1\",\"total_fee\":\"1\",\"result_code\":\"SUCCESS\",\"coupon_refund_count\":\"0\",\"cash_refund_fee\":\"1\",\"return_code\":\"SUCCESS\"}', '2022-09-10 10:22:55', '2022-09-10 10:22:54', '2022-09-10 02:22:55', 0);

INSERT INTO `refund_info` VALUES (2, '166277685023688', 74, 2, '50301702892022091024737182890', 100.00, '2022-09-10|北京协和医院|多发性硬化专科门诊|副主任医师', 2, '{\"transaction_id\":\"4200001580202209105082263057\",\"nonce_str\":\"kywQqfxi5fOVMS1D\",\"out_refund_no\":\"tk166277685023688\",\"sign\":\"8D1D09951E207BD9DD6755D19851BAAB\",\"return_msg\":\"OK\",\"mch_id\":\"1558950191\",\"refund_id\":\"50301702892022091024737182890\",\"cash_fee\":\"1\",\"out_trade_no\":\"166277685023688\",\"coupon_refund_fee\":\"0\",\"refund_channel\":\"\",\"appid\":\"wx74862e0dfcf69954\",\"refund_fee\":\"1\",\"total_fee\":\"1\",\"result_code\":\"SUCCESS\",\"coupon_refund_count\":\"0\",\"cash_refund_fee\":\"1\",\"return_code\":\"SUCCESS\"}', '2022-09-10 10:28:14', '2022-09-10 10:28:13', '2022-09-10 02:28:13', 0);



-- ----------------------------

-- Table structure for schedule

-- ----------------------------

DROP TABLE IF EXISTS `schedule`;

CREATE TABLE `schedule`  (

  `id` bigint(0) NOT NULL DEFAULT 0 COMMENT '编号',

  `hoscode` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '医院编号',

  `depcode` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '科室编号',

  `title` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职称',

  `docname` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '医生名称',

  `skill` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '擅长技能',

  `work_date` date NULL DEFAULT NULL COMMENT '安排日期',

  `work_time` tinyint(0) NULL DEFAULT 0 COMMENT '安排时间（0：上午 1：下午）',

  `reserved_number` int(0) NULL DEFAULT 0 COMMENT '可预约数',

  `available_number` int(0) NULL DEFAULT 0 COMMENT '剩余预约数',

  `amount` decimal(10, 0) NULL DEFAULT NULL COMMENT '挂号费',

  `status` tinyint(0) NULL DEFAULT NULL COMMENT '排班状态（-1：停诊 0：停约 1：可约）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '医生日程安排表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of schedule

-- ----------------------------

INSERT INTO `schedule` VALUES (1, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-13', 0, 33, 3, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:49', 0);

INSERT INTO `schedule` VALUES (2, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-22', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:51', 0);

INSERT INTO `schedule` VALUES (3, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-22', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:57', 0);

INSERT INTO `schedule` VALUES (4, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-14', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:57', 0);

INSERT INTO `schedule` VALUES (5, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-23', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:57', 0);

INSERT INTO `schedule` VALUES (6, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-23', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:57', 0);

INSERT INTO `schedule` VALUES (7, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-15', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:57', 0);

INSERT INTO `schedule` VALUES (8, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-24', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:57', 0);

INSERT INTO `schedule` VALUES (9, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-24', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:01:57', 0);

INSERT INTO `schedule` VALUES (10, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-16', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (11, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-25', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (12, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-25', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (13, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-17', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (14, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-26', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (15, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-26', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (16, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-18', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (17, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-27', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (18, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-27', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (19, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-19', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (20, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-28', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (21, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-28', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (22, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-20', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (23, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-29', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (24, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-29', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (25, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2020-12-21', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (26, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-30', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (27, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-30', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (29, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2020-12-30', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (30, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2020-12-30', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (31, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-01', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (32, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-01', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (33, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-01', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (34, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-02', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (35, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-02', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (36, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-02', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (37, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-03', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (38, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-03', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (39, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-03', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (40, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-04', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (41, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-04', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (42, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-04', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (43, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-05', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (44, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-05', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (45, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-05', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (46, '1000_0', '200040878', '医师', '邵迎红', '内分泌科常见病。', '2021-01-06', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-05 12:03:26', 0);

INSERT INTO `schedule` VALUES (47, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-06', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (48, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-06', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (49, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-07', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (50, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-07', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (51, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-07', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (52, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-08', 0, 33, 22, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (53, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-08', 0, 40, 6, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (54, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-08', 1, 27, 10, 100, 1, '2022-09-04 15:16:12', '2022-09-04 15:16:12', 0);

INSERT INTO `schedule` VALUES (55, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-09', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (56, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-09', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (57, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-09', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (58, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-10', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (59, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-10', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (60, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-10', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (61, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-11', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (62, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-11', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (63, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-11', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (64, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-12', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (65, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-12', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (66, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-12', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (67, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-13', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (68, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-13', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (69, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-13', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (70, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-14', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (71, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-14', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (72, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-14', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (73, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-15', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (74, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-15', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (75, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-15', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (76, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-16', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (77, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-16', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (78, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-16', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (79, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-17', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (80, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-17', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (81, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-17', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (82, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-18', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (83, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-18', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (84, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-18', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (85, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-19', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (86, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-19', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (87, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-19', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (88, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-20', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (89, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-20', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (90, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-20', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (91, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-21', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (92, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-21', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (93, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-21', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (94, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-22', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (95, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-22', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (96, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-22', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (97, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-23', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (98, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-23', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (99, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-23', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (100, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-24', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (101, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-24', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (102, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-24', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (103, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-25', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (104, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-25', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (105, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-25', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (106, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-26', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (107, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-26', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (108, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-26', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (109, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-27', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (110, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-27', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (111, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-27', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (112, '1000_0', '200040878', '医师', '', '内分泌科常见病。', '2021-01-28', 0, 33, 22, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (113, '1000_0', '200040878', '副主任医师', '裴育', '骨质疏松和骨代谢疾病、糖尿病、甲状腺疾病。', '2021-01-28', 0, 40, 6, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);

INSERT INTO `schedule` VALUES (114, '1000_0', '200040878', '副主任医师', '邵迎红', '内分泌与代谢性疾病。', '2021-01-28', 1, 27, 10, 100, 1, '2022-09-04 15:16:13', '2022-09-04 15:16:13', 0);



-- ----------------------------

-- Table structure for user_info

-- ----------------------------

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info`  (

  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `openid` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '微信openid',

  `nick_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '昵称',

  `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '手机号',

  `name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户姓名',

  `certificates_type` varchar(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '证件类型',

  `certificates_no` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '证件编号',

  `certificates_url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '证件路径',

  `auth_status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '认证状态（0：未认证 1：认证中 2：认证成功 -1：认证失败）',

  `status` tinyint(0) NOT NULL DEFAULT 1 COMMENT '状态（0：锁定 1：正常）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `uk_mobile`(`phone`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of user_info

-- ----------------------------

INSERT INTO `user_info` VALUES (8, NULL, NULL, '15828145555', '', NULL, NULL, NULL, 0, 0, '2022-07-19 07:08:32', '2022-07-19 07:08:32', 0);

INSERT INTO `user_info` VALUES (9, NULL, NULL, '15828145846', '', NULL, NULL, NULL, 0, 0, '2022-07-19 14:57:15', '2022-07-21 18:44:50', 0);

INSERT INTO `user_info` VALUES (10, NULL, NULL, '18354353454', '', NULL, NULL, NULL, 0, 1, '2022-07-19 15:30:12', '2022-07-21 18:44:55', 0);

INSERT INTO `user_info` VALUES (14, 'o3_SC5216sBPWfeSBem-VdUKznwE', 'noob', '15828145845', '刘川', '身份证', '510181200010146733', NULL, 2, 1, '2022-07-21 19:36:50', '2022-08-25 15:21:58', 0);

INSERT INTO `user_info` VALUES (15, NULL, NULL, '', NULL, NULL, NULL, NULL, 0, 0, '2022-08-25 03:49:32', '2022-08-25 03:49:32', 0);

INSERT INTO `user_info` VALUES (16, NULL, NULL, '18881622272', '张三', '身份证', '510181200010146733', 'https://yygh-liuchuan.oss-cn-chengdu.aliyuncs.com/2022/08/30/125ca752cfef439d9e16e64a72e9b4a82.png', 2, 1, '2022-08-25 18:14:32', '2022-08-25 18:14:32', 0);



-- ----------------------------

-- Table structure for user_login_record

-- ----------------------------

DROP TABLE IF EXISTS `user_login_record`;

CREATE TABLE `user_login_record`  (

  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(0) NULL DEFAULT NULL COMMENT '用户id',

  `ip` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'ip',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户登录记录表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of user_login_record

-- ----------------------------

INSERT INTO `user_login_record` VALUES (40, 11, '0:0:0:0:0:0:0:1', '2022-07-21 18:44:03', '2022-07-21 18:44:03', 0);

INSERT INTO `user_login_record` VALUES (41, 12, '0:0:0:0:0:0:0:1', '2022-07-21 18:52:06', '2022-07-21 18:52:06', 0);

INSERT INTO `user_login_record` VALUES (42, 13, '0:0:0:0:0:0:0:1', '2022-07-21 19:05:23', '2022-07-21 19:05:23', 0);

INSERT INTO `user_login_record` VALUES (43, 13, '0:0:0:0:0:0:0:1', '2022-07-21 19:21:55', '2022-07-21 19:21:55', 0);

INSERT INTO `user_login_record` VALUES (44, 13, '0:0:0:0:0:0:0:1', '2022-07-21 19:26:22', '2022-07-21 19:26:22', 0);

INSERT INTO `user_login_record` VALUES (45, 13, '0:0:0:0:0:0:0:1', '2022-07-21 19:29:33', '2022-07-21 19:29:33', 0);

INSERT INTO `user_login_record` VALUES (46, 13, '0:0:0:0:0:0:0:1', '2022-07-21 19:33:26', '2022-07-21 19:33:26', 0);

INSERT INTO `user_login_record` VALUES (47, 14, '0:0:0:0:0:0:0:1', '2022-07-21 19:37:19', '2022-07-21 19:37:19', 0);

INSERT INTO `user_login_record` VALUES (48, 14, '0:0:0:0:0:0:0:1', '2022-08-17 17:32:53', '2022-08-17 17:32:53', 0);

INSERT INTO `user_login_record` VALUES (49, 14, '0:0:0:0:0:0:0:1', '2022-08-17 17:32:53', '2022-08-17 17:32:53', 0);

INSERT INTO `user_login_record` VALUES (50, 14, '0:0:0:0:0:0:0:1', '2022-08-24 16:23:05', '2022-08-24 16:23:05', 0);

INSERT INTO `user_login_record` VALUES (51, 14, '0:0:0:0:0:0:0:1', '2022-08-25 03:08:51', '2022-08-25 03:08:51', 0);

INSERT INTO `user_login_record` VALUES (52, 14, '0:0:0:0:0:0:0:1', '2022-08-25 03:08:54', '2022-08-25 03:08:54', 0);

INSERT INTO `user_login_record` VALUES (53, NULL, '0:0:0:0:0:0:0:1', '2022-08-25 03:11:22', '2022-08-25 03:11:22', 0);

INSERT INTO `user_login_record` VALUES (54, 14, '0:0:0:0:0:0:0:1', '2022-08-25 03:11:56', '2022-08-25 03:11:56', 0);

INSERT INTO `user_login_record` VALUES (55, 14, '0:0:0:0:0:0:0:1', '2022-08-25 03:50:22', '2022-08-25 03:50:22', 0);

INSERT INTO `user_login_record` VALUES (56, 14, '0:0:0:0:0:0:0:1', '2022-08-25 11:10:30', '2022-08-25 11:10:30', 0);

INSERT INTO `user_login_record` VALUES (57, 14, '0:0:0:0:0:0:0:1', '2022-08-25 11:12:56', '2022-08-25 11:12:56', 0);

INSERT INTO `user_login_record` VALUES (58, 14, '0:0:0:0:0:0:0:1', '2022-08-25 16:13:59', '2022-08-25 16:13:59', 0);

INSERT INTO `user_login_record` VALUES (59, 14, '0:0:0:0:0:0:0:1', '2022-08-25 17:20:12', '2022-08-25 17:20:12', 0);

INSERT INTO `user_login_record` VALUES (60, 16, '0:0:0:0:0:0:0:1', '2022-08-25 18:14:32', '2022-08-25 18:14:32', 0);

INSERT INTO `user_login_record` VALUES (61, 14, '0:0:0:0:0:0:0:1', '2022-08-25 23:33:58', '2022-08-25 23:33:58', 0);

INSERT INTO `user_login_record` VALUES (62, 14, '0:0:0:0:0:0:0:1', '2022-09-02 15:03:52', '2022-09-02 15:03:52', 0);

INSERT INTO `user_login_record` VALUES (63, 14, '0:0:0:0:0:0:0:1', '2022-09-04 13:52:30', '2022-09-04 13:52:30', 0);

INSERT INTO `user_login_record` VALUES (64, 14, '0:0:0:0:0:0:0:1', '2022-09-05 14:15:00', '2022-09-05 14:15:00', 0);

INSERT INTO `user_login_record` VALUES (65, 16, '0:0:0:0:0:0:0:1', '2022-09-05 14:24:38', '2022-09-05 14:24:38', 0);

INSERT INTO `user_login_record` VALUES (66, 16, '0:0:0:0:0:0:0:1', '2022-09-05 15:16:27', '2022-09-05 15:16:27', 0);

INSERT INTO `user_login_record` VALUES (67, 14, '0:0:0:0:0:0:0:1', '2022-09-06 07:38:59', '2022-09-06 07:38:59', 0);

INSERT INTO `user_login_record` VALUES (68, 14, '0:0:0:0:0:0:0:1', '2022-09-06 14:22:44', '2022-09-06 14:22:44', 0);

INSERT INTO `user_login_record` VALUES (69, 14, '0:0:0:0:0:0:0:1', '2022-09-06 16:04:27', '2022-09-06 16:04:27', 0);

INSERT INTO `user_login_record` VALUES (70, 14, '0:0:0:0:0:0:0:1', '2022-09-08 12:42:34', '2022-09-08 12:42:34', 0);

INSERT INTO `user_login_record` VALUES (71, 14, '0:0:0:0:0:0:0:1', '2022-09-09 00:50:04', '2022-09-09 00:50:04', 0);

INSERT INTO `user_login_record` VALUES (72, 14, '0:0:0:0:0:0:0:1', '2022-09-09 22:09:13', '2022-09-09 22:09:13', 0);

INSERT INTO `user_login_record` VALUES (73, 14, '0:0:0:0:0:0:0:1', '2022-09-10 00:29:25', '2022-09-10 00:29:25', 0);

INSERT INTO `user_login_record` VALUES (74, 14, '0:0:0:0:0:0:0:1', '2022-09-10 12:48:18', '2022-09-10 12:48:18', 0);

INSERT INTO `user_login_record` VALUES (75, 14, '0:0:0:0:0:0:0:1', '2022-09-11 05:38:26', '2022-09-11 05:38:26', 0);



SET FOREIGN_KEY_CHECKS = 1;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/midoucode/health.git
git@gitee.com:midoucode/health.git
midoucode
health
health
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部