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

衬衫boy/医院挂号系统

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
boot_hospital_yuyue.sql 18.44 KB
一键复制 编辑 原始数据 按行查看 历史
衬衫boy 提交于 2021-11-20 14:43 . 医院挂号系统
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282
/*

 Navicat Premium Data Transfer



 Source Server         : chenshan

 Source Server Type    : MySQL

 Source Server Version : 50733

 Source Host           : localhost:3306

 Source Schema         : boot_hospital_yuyue



 Target Server Type    : MySQL

 Target Server Version : 50733

 File Encoding         : 65001



 Date: 20/11/2021 14:23:17

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



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

-- Table structure for appointment

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

DROP TABLE IF EXISTS `appointment`;

CREATE TABLE `appointment`  (

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `patientid` int(11) NULL DEFAULT NULL COMMENT '患者id',

  `doctorid` int(11) NULL DEFAULT NULL COMMENT '医生id',

  `time` date NULL DEFAULT NULL COMMENT '预约时间',

  `expenses` decimal(10, 2) NULL DEFAULT NULL COMMENT '门诊费',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of appointment

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

INSERT INTO `appointment` VALUES (40, 8, 8, '2021-04-25', 15.00);

INSERT INTO `appointment` VALUES (41, 8, 1, '2021-04-21', 15.00);

INSERT INTO `appointment` VALUES (42, 8, 10, '2021-04-24', 15.00);

INSERT INTO `appointment` VALUES (43, 9, 1, '2021-04-23', 15.00);

INSERT INTO `appointment` VALUES (44, 10, 4, '2021-04-23', 15.00);

INSERT INTO `appointment` VALUES (45, 8, 8, '2021-04-24', 15.00);



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

-- Table structure for doctor

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

DROP TABLE IF EXISTS `doctor`;

CREATE TABLE `doctor`  (

  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',

  `age` int(11) NULL DEFAULT NULL COMMENT '年龄',

  `certId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证',

  `sex` int(10) NULL DEFAULT NULL COMMENT '性别',

  `department` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门',

  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '家庭住址',

  `loginid` int(11) NULL DEFAULT NULL COMMENT '登录',

  `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '介绍',

  `expert` int(10) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of doctor

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

INSERT INTO `doctor` VALUES (1, '韩梅梅', 32, '320586198807191278', 1, '内科', '江苏/苏州', 11, '    药到病除', 1);

INSERT INTO `doctor` VALUES (2, '李雷', 32, '320283198802102526', 0, '呼吸内科', '江苏/无锡', 4, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2', 1);

INSERT INTO `doctor` VALUES (4, '赵志', 38, '310103198212062428', 0, '口腔科', '上海', 3, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2', 1);

INSERT INTO `doctor` VALUES (5, '杨丽娟', 45, '320283197504207624', 1, '急诊科', '江苏/无锡', 18, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2', 1);

INSERT INTO `doctor` VALUES (6, '王五', 45, '320283197508091516', 1, '神经内科', '江苏/无锡', 17, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2', 0);

INSERT INTO `doctor` VALUES (7, '王一一', 40, '320586198807191279', 1, '内科', '江苏/无锡', NULL, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2', 0);

INSERT INTO `doctor` VALUES (8, '华佗', 59, '320283197508091569', 0, '精神科', '海安', 25, NULL, 1);

INSERT INTO `doctor` VALUES (9, '小樱', 26, '74125896333333333', 1, '妇产科', '武汉', NULL, NULL, 1);

INSERT INTO `doctor` VALUES (10, '小神医', 18, '741258963369852147', 1, '外科', '上海', 26, NULL, 1);

INSERT INTO `doctor` VALUES (11, '张茜', 30, '789987789987741258', 1, '口腔科', '江西', NULL, NULL, 0);



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

-- Table structure for drugs

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

DROP TABLE IF EXISTS `drugs`;

CREATE TABLE `drugs`  (

  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '药品名称',

  `type` int(10) NULL DEFAULT NULL COMMENT '药品类型',

  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '单价',

  `number` int(11) NULL DEFAULT NULL COMMENT '数量',

  `text` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '介绍',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of drugs

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

INSERT INTO `drugs` VALUES (1, '乙酰氨基酚片', 4, 65.00, 185, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2');

INSERT INTO `drugs` VALUES (2, '复方益肝灵片', 1, 20.00, 88, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2');

INSERT INTO `drugs` VALUES (3, '胆维他片', 2, 50.00, 88, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2');

INSERT INTO `drugs` VALUES (4, '抗菌消炎胶囊', 3, 45.00, 100, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2');

INSERT INTO `drugs` VALUES (5, '健脑益气片', 4, 120.00, 88, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2');

INSERT INTO `drugs` VALUES (7, '口服液', 5, 30.00, 100, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2');

INSERT INTO `drugs` VALUES (13, '支气管舒张剂', 2, 60.00, 100, '手动阀手动阀手动阀手动阀啊JKDASJDKLADLASLDKASL1312KASDKLASDKASJFLASFJKSGFJSDAKJFSAKFJSKFJSDKFJSDKLFJSDKLFJSCMxlSKkdosadkfsd看风使舵李开复十六分就开了反射定律攻击速度老师的课反对法工地上可22插卡式西欧的靠谱的看312课程搜房参考2');

INSERT INTO `drugs` VALUES (14, '阿莫西林', 1, 25.00, 50, NULL);



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

-- Table structure for hospitalization

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

DROP TABLE IF EXISTS `hospitalization`;

CREATE TABLE `hospitalization`  (

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `floor` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '楼层',

  `bed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '床号',

  `door` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房间号',

  `medicalname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '病名称',

  `patientid` int(11) NULL DEFAULT NULL COMMENT '患者id',

  `intime` date NULL DEFAULT NULL COMMENT '住院时间',

  `outtime` date NULL DEFAULT NULL COMMENT '出院时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of hospitalization

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

INSERT INTO `hospitalization` VALUES (14, '3', '1', '301', '精神问题', 8, '2021-04-22', '2021-04-25');

INSERT INTO `hospitalization` VALUES (15, '4', '4', '414', '心脏病', 8, '2021-04-22', '2021-05-01');

INSERT INTO `hospitalization` VALUES (16, '1', '1', '101', '皮肤烧伤', 8, '2021-04-25', '2021-05-25');

INSERT INTO `hospitalization` VALUES (17, '5', '4', '501', '疑似心脏病', 9, '2021-04-23', '2021-04-30');

INSERT INTO `hospitalization` VALUES (18, '1', '1', '101', '智齿', 10, '2021-04-23', '2021-04-24');



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

-- Table structure for illness

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

DROP TABLE IF EXISTS `illness`;

CREATE TABLE `illness`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of illness

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

INSERT INTO `illness` VALUES (1, '牙疼', ' 牙痛是指牙齿因各种原因引起的疼痛，为口腔疾患中常见的症状之一，可见于龋齿、牙髓炎、根尖周炎、牙外伤、牙本质过敏、楔状缺损等。\r\n                        ');

INSERT INTO `illness` VALUES (2, '头疼', '头痛（headache） 是临床常见的症状，通常将局限于头颅上半部，包括眉弓、耳轮上缘和枕外隆突连线以上部位的疼痛统称头痛。                    ');

INSERT INTO `illness` VALUES (3, '呼吸性疾病', ' 呼吸病                     ');

INSERT INTO `illness` VALUES (4, '胆结石', '很难受                        ');



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

-- Table structure for login

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

DROP TABLE IF EXISTS `login`;

CREATE TABLE `login`  (

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',

  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',

  `role` int(255) NULL DEFAULT NULL COMMENT '权限',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of login

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

INSERT INTO `login` VALUES (1, 'admin', 'admin', 1);

INSERT INTO `login` VALUES (3, 'zhaozhi', '123456', 2);

INSERT INTO `login` VALUES (4, 'lilei', '123456', 2);

INSERT INTO `login` VALUES (5, 'haoyi', '123456', 3);

INSERT INTO `login` VALUES (6, 'liyiyi', '123456', 3);

INSERT INTO `login` VALUES (7, 'zhangxiaoxiao', '123456', 3);

INSERT INTO `login` VALUES (8, 'wumei', '123456', 3);

INSERT INTO `login` VALUES (9, 'user', '123456', 3);

INSERT INTO `login` VALUES (11, 'hanmeimei', '123456', 2);

INSERT INTO `login` VALUES (14, 'wangyiyi', '123456', 2);

INSERT INTO `login` VALUES (17, 'wangwu', '123456', 2);

INSERT INTO `login` VALUES (18, 'yanglijuan', '123456', 2);

INSERT INTO `login` VALUES (19, 'sunzhi', '123456', 3);

INSERT INTO `login` VALUES (24, 'jack', '123456', 3);

INSERT INTO `login` VALUES (25, 'huatuo', '123456', 2);

INSERT INTO `login` VALUES (26, 'xiaoshenyi', '123456', 2);

INSERT INTO `login` VALUES (27, 'mike', '123456', 3);

INSERT INTO `login` VALUES (28, 'rouse', '123456', 3);



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

-- Table structure for medicalhistory

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

DROP TABLE IF EXISTS `medicalhistory`;

CREATE TABLE `medicalhistory`  (

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `patientid` int(10) NULL DEFAULT NULL COMMENT '患者id',

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '病史名称',

  `time` date NULL DEFAULT NULL COMMENT '患病时间',

  `hospitalizationid` int(11) NULL DEFAULT NULL COMMENT '住院信息',

  `doctorid` int(11) NULL DEFAULT NULL COMMENT '确诊人',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of medicalhistory

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

INSERT INTO `medicalhistory` VALUES (10, 8, '精神', '2021-04-22', NULL, 8);

INSERT INTO `medicalhistory` VALUES (11, 8, '心脏病', '2021-04-23', NULL, 1);

INSERT INTO `medicalhistory` VALUES (12, 9, '心脏病', '2021-04-24', NULL, 1);

INSERT INTO `medicalhistory` VALUES (13, 10, '智齿', '2021-04-23', NULL, 4);



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

-- Table structure for option

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

DROP TABLE IF EXISTS `option`;

CREATE TABLE `option`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `price` decimal(10, 2) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of option

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

INSERT INTO `option` VALUES (1, '大血', '血液科室', 100.00);

INSERT INTO `option` VALUES (2, '小血', '血液科室', 200.00);

INSERT INTO `option` VALUES (3, 'B超（彩超）', '超生室', 300.00);

INSERT INTO `option` VALUES (4, '心电图', '心电图室', 200.00);

INSERT INTO `option` VALUES (5, '大便', '厕所门口自行拿管', 200.00);

INSERT INTO `option` VALUES (6, '小便', '厕所门口自行拿管', 200.00);

INSERT INTO `option` VALUES (7, 'CT', '放射科室', 200.00);

INSERT INTO `option` VALUES (8, 'X光片', '放射科室', 200.00);

INSERT INTO `option` VALUES (9, '核磁共振', '放射科室', 200.00);



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

-- Table structure for patient

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

DROP TABLE IF EXISTS `patient`;

CREATE TABLE `patient`  (

  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',

  `age` int(10) NULL DEFAULT NULL COMMENT '年龄',

  `certId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证',

  `sex` int(10) NULL DEFAULT NULL COMMENT '性别',

  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '家庭住址',

  `Hospitalizationid` int(10) NULL DEFAULT NULL COMMENT '住院信息',

  `drugsids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '药品信息',

  `isout` int(255) NULL DEFAULT NULL COMMENT '是否出院',

  `appointmentid` int(11) NULL DEFAULT NULL COMMENT '预约信息',

  `loginid` int(11) NULL DEFAULT NULL COMMENT '登录',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of patient

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

INSERT INTO `patient` VALUES (8, 'jack', 18, '111111111111111111', 0, '武汉', NULL, NULL, 0, 45, 24);

INSERT INTO `patient` VALUES (9, 'mike', 25, '741258963369632145', 0, '深圳', NULL, NULL, 1, 43, 27);

INSERT INTO `patient` VALUES (10, 'rouse', 26, '741236547896541236', 1, '武汉', NULL, NULL, 0, 44, 28);



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

-- Table structure for seek

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

DROP TABLE IF EXISTS `seek`;

CREATE TABLE `seek`  (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `describes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `illname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `drugs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `options` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `days` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `price` decimal(10, 2) NULL DEFAULT NULL,

  `patientid` int(11) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of seek

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

INSERT INTO `seek` VALUES (1, '2e3wsdasda', '1212', '1@12,2@12,3@12,5@12', '1,6', '0', 4380.00, 1);

INSERT INTO `seek` VALUES (2, 'dasdasdas', '脑膜炎', '1@12,2@12,3@12,5@12', '10', '10', 3060.00, 1);

INSERT INTO `seek` VALUES (3, '内伤', '住院观察', NULL, '8,9', '2', 400.00, 6);

INSERT INTO `seek` VALUES (4, '精神恍惚', '精神问题', NULL, '4,9', '2', 400.00, 8);

INSERT INTO `seek` VALUES (5, '精神', '精神问题', NULL, '4,9', '3', 400.00, 8);

INSERT INTO `seek` VALUES (6, '心脏疼', '心脏病', NULL, '3,7,8', '3', 700.00, 8);

INSERT INTO `seek` VALUES (7, '皮肤烧伤', '皮肤烧伤', NULL, '2,7', '30', 400.00, 8);

INSERT INTO `seek` VALUES (8, '心脏疼', '心脏病', NULL, '3,8', '5', 500.00, 9);

INSERT INTO `seek` VALUES (9, '牙疼', '智齿', NULL, '8', '1', 200.00, 10);

INSERT INTO `seek` VALUES (10, 'ff', '智齿', NULL, '8', '3', 200.00, 8);



SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/chenshanstudy/hospital-registration-system.git
git@gitee.com:chenshanstudy/hospital-registration-system.git
chenshanstudy
hospital-registration-system
医院挂号系统
master
点此查找更多帮助

搜索帮助

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