/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 8.0.19 : Database - my-hospital
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`my-hospital` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `my-hospital`;

/*Table structure for table `ho_advice_record` */

DROP TABLE IF EXISTS `ho_advice_record`;

CREATE TABLE `ho_advice_record` (
  `ar_id` int NOT NULL AUTO_INCREMENT COMMENT '配药记录id',
  `da_id` int NOT NULL COMMENT '医嘱ID',
  `ar_price` decimal(10,2) NOT NULL COMMENT '药品价格',
  `da_num` int NOT NULL COMMENT '药品数量',
  `ar_create_time` datetime NOT NULL COMMENT '创建时间',
  `w_id` int NOT NULL COMMENT '创建该条记录的人',
  `ar_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`ar_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_advice_record` */

insert  into `ho_advice_record`(`ar_id`,`da_id`,`ar_price`,`da_num`,`ar_create_time`,`w_id`,`ar_status`) values (1,1,'40.00',2,'2021-03-12 13:36:05',1,'y'),(2,1,'80.00',2,'2021-03-12 14:20:09',1,'y'),(3,3,'520.00',4,'2021-03-12 14:48:03',1,'y'),(4,2,'300.00',3,'2021-03-13 10:12:24',1,'y'),(5,1,'80.00',2,'2021-03-13 15:51:14',1,'y'),(6,1,'80.00',2,'2021-03-13 15:51:29',1,'y'),(7,4,'335.00',5,'2021-03-15 15:20:40',12,'y'),(8,5,'1116.00',6,'2021-03-15 21:29:52',3,'y'),(9,27,'400.00',4,'2021-03-16 11:54:40',4,'y'),(10,28,'40.00',1,'2021-03-16 11:54:43',4,'y'),(11,29,'650.00',5,'2021-03-16 11:54:45',4,'y'),(12,7,'182.00',7,'2021-03-16 12:03:00',7,'y'),(13,9,'130.00',1,'2021-03-16 12:03:04',7,'y'),(14,10,'63.00',3,'2021-03-16 12:03:23',7,'y'),(15,12,'243.00',9,'2021-03-16 12:03:26',7,'y'),(16,6,'300.00',3,'2021-03-16 19:00:48',7,'y'),(17,8,'243.00',9,'2021-03-16 19:01:32',1,'y'),(18,30,'930.00',5,'2021-03-16 19:14:21',1,'y'),(19,27,'400.00',4,'2021-03-16 19:14:57',1,'y'),(20,26,'804.00',12,'2021-03-16 19:15:20',1,'y'),(21,23,'182.00',7,'2021-03-16 20:56:06',7,'y'),(22,14,'182.00',7,'2021-03-16 20:57:20',7,'y'),(23,38,'52.00',2,'2021-03-16 21:00:58',7,'y'),(24,37,'1116.00',6,'2021-03-16 21:03:42',7,'y'),(25,15,'1650.00',30,'2021-03-16 21:06:15',7,'y'),(26,40,'275.00',5,'2021-03-16 21:15:46',7,'y'),(27,35,'120.00',3,'2021-03-16 21:24:05',7,'y'),(28,33,'200.00',2,'2021-03-16 21:25:24',7,'y'),(29,13,'114.00',3,'2021-03-17 17:26:30',1,'y'),(30,17,'1200.00',30,'2021-03-17 17:27:37',3,'y'),(31,11,'130.00',1,'2021-03-17 17:27:44',3,'y'),(32,21,'402.00',6,'2021-03-17 17:28:12',3,'y'),(33,76,'40.00',1,'2021-03-17 20:48:06',3,'y'),(34,75,'400.00',4,'2021-03-17 20:48:08',3,'y'),(35,74,'40.00',1,'2021-03-17 20:48:10',3,'y'),(36,72,'40.00',1,'2021-03-17 20:48:13',3,'y'),(37,71,'390.00',3,'2021-03-17 20:48:14',3,'y'),(38,70,'201.00',3,'2021-03-17 20:48:17',3,'y'),(39,69,'201.00',3,'2021-03-17 20:48:19',3,'y'),(40,43,'400.00',4,'2021-03-17 20:48:50',3,'y'),(41,45,'266.00',7,'2021-03-17 20:48:52',3,'y'),(42,46,'1005.00',15,'2021-03-17 20:49:04',3,'y'),(43,48,'80.00',2,'2021-03-17 20:49:05',3,'y'),(44,50,'390.00',3,'2021-03-17 20:50:01',3,'y'),(45,52,'390.00',3,'2021-03-17 20:50:03',3,'y'),(46,51,'520.00',4,'2021-03-17 20:50:05',3,'y'),(47,53,'520.00',4,'2021-03-17 20:50:07',3,'y'),(48,54,'520.00',4,'2021-03-17 20:50:09',3,'y'),(49,55,'390.00',3,'2021-03-17 20:50:10',3,'y'),(50,56,'390.00',3,'2021-03-17 20:50:12',3,'y'),(51,57,'520.00',4,'2021-03-17 20:50:14',3,'y'),(52,59,'520.00',4,'2021-03-17 20:50:15',3,'y'),(53,20,'1064.00',28,'2021-03-17 20:50:25',3,'y'),(54,18,'335.00',5,'2021-03-17 20:50:28',3,'y'),(55,96,'268.00',4,'2021-03-18 10:48:45',3,'y'),(56,94,'400.00',4,'2021-03-18 10:48:51',3,'y'),(57,92,'222.00',6,'2021-03-18 10:48:55',3,'y'),(58,91,'38.00',1,'2021-03-18 10:48:57',3,'y'),(59,84,'2700.00',27,'2021-03-18 10:49:04',3,'y'),(60,83,'266.00',7,'2021-03-18 10:49:06',3,'y'),(61,86,'190.00',5,'2021-03-18 10:49:08',3,'y'),(62,81,'40.00',1,'2021-03-18 10:49:14',3,'y'),(63,88,'228.00',6,'2021-03-18 10:49:17',3,'y'),(64,89,'335.00',5,'2021-03-18 10:49:19',3,'y'),(65,90,'228.00',6,'2021-03-18 10:49:21',3,'y'),(67,22,'5872.00',16,'2021-03-18 11:32:07',12,'y'),(68,44,'335.00',5,'2021-03-19 11:25:45',12,'y'),(69,42,'134.00',2,'2021-03-19 11:25:52',12,'y'),(70,120,'152.00',4,'2021-03-19 11:27:59',12,'y');

/*Table structure for table `ho_department` */

DROP TABLE IF EXISTS `ho_department`;

CREATE TABLE `ho_department` (
  `dp_id` int NOT NULL AUTO_INCREMENT COMMENT '部门ID',
  `dp_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '部门名称',
  `dp_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '部门描述',
  PRIMARY KEY (`dp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_department` */

insert  into `ho_department`(`dp_id`,`dp_name`,`dp_description`) values (1,'门诊部','这是门诊部'),(2,'住院部','这是住院部'),(3,'药房部','药房部门'),(4,'财务部','财务部门');

/*Table structure for table `ho_department_class` */

DROP TABLE IF EXISTS `ho_department_class`;

CREATE TABLE `ho_department_class` (
  `dpc_id` int NOT NULL AUTO_INCREMENT COMMENT '科室ID',
  `dpc_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '科室名称',
  `dp_id` int NOT NULL COMMENT '所属部门ID',
  `dpc_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '科室描述',
  `dpc_iscure` char(2) COLLATE utf8mb4_bin NOT NULL COMMENT '是否是治疗科室',
  PRIMARY KEY (`dpc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_department_class` */

insert  into `ho_department_class`(`dpc_id`,`dpc_name`,`dp_id`,`dpc_description`,`dpc_iscure`) values (1,'呼吸科',1,'我科拥有病床48张，其中呼吸重症监护室（RICU）病床6张。设有支气管镜室、肺功能室及呼吸专科门诊。拥有多种先进仪器设备，包括美国先进的有创呼吸机6台和无创呼吸机10台，惠普多功能监护仪12台，电子及纤维支气管镜2套及全套图文处理系统，德国JAEGER公司高档肺功能仪等。','y'),(3,'消化科',1,'科室具有合理的人才团队，现有医护人员22人，副主任医师2名，主治医师3名，其中硕士研究生2名，主管护师3名，护师6名，消化内科由住院病房、内镜中心、专科门诊组成，科室现有床位25张。科室拥有Olympus、CV-260胃肠镜主机，Olympus、CV-290胃肠镜主机一台，共配备胃镜10条，肠镜5条；德国产爱尔博（ERBE）Power-420高频治疗仪；胶囊内镜；幽门螺杆菌唾液测定及13C/14C卡式幽门螺杆菌测试仪等先进设备。','y'),(5,'内分泌科',1,'主攻学科内分泌代谢病。重点是糖尿病的流行病学、肥胖、糖尿病及其并发症的发病机制和规范诊治，内分泌性的突眼、甲状腺炎的相关研究。我科糖尿病、甲状腺疾病的诊治已达三级乙等医院的水平，拥有多台胰岛素泵等设备。糖尿病酮症酸中毒、高渗性昏迷、乳酸性酸中毒及甲亢危象的抢救成功率已达到卫生部颁发的要求。垂体、肾上腺、甲状旁腺、性腺、胰岛细胞瘤等疾病均能得到合理诊治。现已开展的实验室检查项目达到三乙标准，部分达到三级甲等医院技术水平的要求。每月定期举办糖尿病教育系列讲座。每年世界糖尿病日均举办大型系列的糖尿病教育活动。','y'),(7,'心血管科',1,'心血管内科重视医疗、教学、科研的全面发展,创建胸痛分中心。目前开放床位38张，每年收治心血管疾病患者1300余人次，每年抢救危重病人300多例，开设心血管专家门诊和专科门诊，年门诊量11000余人次。现有医护人员23人，副主任医师1人，主治医师2人，住院医师6人，其中硕士研究生3人，护理人员13人。配有完善的一体化中央监护系统和急救设备，包括飞利浦心脏除颤仪、美国美敦力起搏分析仪、迈柯唯PT10临时起搏器、美国圣犹达（St. Jude Medical）起搏程控仪、无创呼吸机、大型设备西门子数字减影造影机','y'),(9,'血液科',1,'血液内科拥有一支临床经验丰富、诊疗素质高的医生团队，目前团队中有主任医师2名，主治医师4名，住院医师1名，其中大理大学硕士生导师1名、硕士研究生4名、在读硕士研究生1名。科室编制床位28张，其中无菌层流床4张，抢救床4张。同时，血液内科是四川省血液病专科联盟成员、四川省血友病诊疗分中心、四川省医学会血液学分会委员单位、四川省医师协会血液学分会委员单位，血液病诊疗水平已达省内地州级医院领先行列。','y'),(11,'风湿科',1,'科充分发挥中医药治疗风湿性疾病的优势，在防治尪痹（类风湿关节炎）、大偻（强直性脊柱炎）、阴阳毒（系统性红斑狼疮）、肌痹（多发性肌炎/皮肌炎）、痛风（痛风性关节炎）、燥痹（干燥综合征）、骨痹（骨性关节炎）等疾病中取得了很好的疗效，并建立了相应的中医诊疗方案、疗效评价和护理规范，提高了中医风湿病的临床诊治水平，获得了令患者满意的临床疗效。尤其是专科制定的肌痹（多发性肌炎/皮肌炎）诊疗方案得到全国中医风湿病同行的认可和支持，被确立为国家中医药管理局肌痹（多发性肌炎/皮肌炎）协作组牵头单位，在全国具有较大的影响力','y'),(13,'骨科',1,'近几年我院西医骨科与多家传统骨科三甲医院协作疑难病例讨论，积极开展骨科创伤、关节、脊柱手术，努力与本专业先进理念接轨，在提升科室成员业务能力同时，使临床各型骨折及骨病诊断治疗的准确率、治愈率都有极大的提高。尤其在运动医学方面开展了肩、膝、肘、踝关节疾病的关节镜微创手术，在腰椎间盘疾病治疗方面开展了射频消融微创手术，创伤小、见效快、住院时间短，广受患者好评。','y'),(31,'手术内科',1,'手麻科几历风雨，已发展成为一个拥有雄厚的技术力量和先进的医疗仪器、在无任何外院的支持下已完成胜任全院各类急、危、重病人的各种手术，和心肺复苏抢救，以及手术科室的各类临床科研任务的先进科室。\r\n\r\n  全科人员共有22人，其中麻醉师有8人，护士有14人，共有5个手术间，每间均配有先进的麻醉机以及麻醉监测仪一台，另有心电除颤仪一台,C型臂一台，电子显微镜2台，以及先进的胸腔镜、腹腔镜、宫腔镜、关节镜、前列腺电切镜个一台，手术间均配有空气消毒系统。','y'),(32,'放射科',1,' 放射科成立于1979年。在医院正确领导下，通过全科业务人员多年来努力，现已成为本地区设备先进、技术精湛、服务优良的专业科室。担负本地区及医学院校影像专业技术人员进修、实习培训，是放射影像医教研基地。专业设置：普放、CT、MRI、介入治疗专业，实行24小时值班。','y'),(33,'超声科',1,'我院超声医学学科为四川省甲级重点学科，并为专业硕士学位授权点，属国家级住院医师规范化培训基地。承担了成都医学院5年制医学影像系等不同学科本科生和研究生教育、规培生及继续教育等教学任务；所培养研究生或实习生连续多年在全国高等医学院校大学生临床技能竞赛中获奖。我科结合受援医院发展需求认真做好对口支援，向受援医院派出支援医生，开展义诊巡诊、举办学术讲座等。','y'),(34,'检验科',1,'现科下设微生物专业组、生化与免疫专业组、基础检验与细胞学、内分泌专业组、分子生物学专业组、西院综合组6个专业组。国内率先设立检验门诊，平均每天接诊超过40人次；积极参与临床查房，共计百余次。按照“准确、快捷、热情”的质量方针，根据CNAS－CL02：2012《医学实验室质量和能力认可准则》（ISO15189: 2012, IDT）及CAP的技术要求建立并运行质量管理体系，于2008年通过国家合格评定认可委员会组织的专家评审并获得ISO15189认可证书；于2014年通过美国临床病理家学会（CAP）的实验室','y'),(35,'手术外科',1,'普外科是医院重点学科，是丰台区肝胆外科治疗中心，以胃肠道肿瘤、肝胆、腺体（乳腺、甲状腺等）、腹腔镜外科为主要治疗方向的专业技术特色科室，近年来普外科取得了长足的进步，形成了以肝胆外科、肿瘤、微创治疗和创伤急救为中心的发展方向。\r\n\r\n普外科目前开放床位90张，共有医护人员60余人，其中拥有副高以上职称人员10人，主治医师、主管护师16人，硕士研究生7名，人才梯队日趋合理。','y'),(41,'药科',3,'负责药品的分配及管理','n'),(42,'内分泌科(住院)',2,'主攻学科内分泌代谢病。重点是糖尿病的流行病学、肥胖、糖尿病及其并发症的发病机制和规范诊治，内分泌性的突眼、甲状腺炎的相关研究。我科糖尿病、甲状腺疾病的诊治已达三级乙等医院的水平，拥有多台胰岛素泵等设备。糖尿病酮症酸中毒、高渗性昏迷、乳酸性酸中毒及甲亢危象的抢救成功率已达到卫生部颁发的要求。垂体、肾上腺、甲状旁腺、性腺、胰岛细胞瘤等疾病均能得到合理诊治。现已开展的实验室检查项目达到三乙标准，部分达到三级甲等医院技术水平的要求。每月定期举办糖尿病教育系列讲座。每年世界糖尿病日均举办大型系列的糖尿病教育活动。','y'),(43,'心血管科(住院)',2,'心血管内科重视医疗、教学、科研的全面发展,创建胸痛分中心。目前开放床位38张，每年收治心血管疾病患者1300余人次，每年抢救危重病人300多例，开设心血管专家门诊和专科门诊，年门诊量11000余人次。现有医护人员23人，副主任医师1人，主治医师2人，住院医师6人，其中硕士研究生3人，护理人员13人。配有完善的一体化中央监护系统和急救设备，包括飞利浦心脏除颤仪、美国美敦力起搏分析仪、迈柯唯PT10临时起搏器、美国圣犹达（St. Jude Medical）起搏程控仪、无创呼吸机、大型设备西门子数字减影造影机','y'),(44,'血液科(住院)',2,'血液内科拥有一支临床经验丰富、诊疗素质高的医生团队，目前团队中有主任医师2名，主治医师4名，住院医师1名，其中大理大学硕士生导师1名、硕士研究生4名、在读硕士研究生1名。科室编制床位28张，其中无菌层流床4张，抢救床4张。同时，血液内科是四川省血液病专科联盟成员、四川省血友病诊疗分中心、四川省医学会血液学分会委员单位、四川省医师协会血液学分会委员单位，血液病诊疗水平已达省内地州级医院领先行列。','y'),(45,'风湿科(住院)',2,'科充分发挥中医药治疗风湿性疾病的优势，在防治尪痹（类风湿关节炎）、大偻（强直性脊柱炎）、阴阳毒（系统性红斑狼疮）、肌痹（多发性肌炎/皮肌炎）、痛风（痛风性关节炎）、燥痹（干燥综合征）、骨痹（骨性关节炎）等疾病中取得了很好的疗效，并建立了相应的中医诊疗方案、疗效评价和护理规范，提高了中医风湿病的临床诊治水平，获得了令患者满意的临床疗效。尤其是专科制定的肌痹（多发性肌炎/皮肌炎）诊疗方案得到全国中医风湿病同行的认可和支持，被确立为国家中医药管理局肌痹（多发性肌炎/皮肌炎）协作组牵头单位，在全国具有较大的影响力','y'),(46,'骨科(住院)',2,'近几年我院西医骨科与多家传统骨科三甲医院协作疑难病例讨论，积极开展骨科创伤、关节、脊柱手术，努力与本专业先进理念接轨，在提升科室成员业务能力同时，使临床各型骨折及骨病诊断治疗的准确率、治愈率都有极大的提高。尤其在运动医学方面开展了肩、膝、肘、踝关节疾病的关节镜微创手术，在腰椎间盘疾病治疗方面开展了射频消融微创手术，创伤小、见效快、住院时间短，广受患者好评。','y'),(47,'手术内科(住院)',2,'手麻科几历风雨，已发展成为一个拥有雄厚的技术力量和先进的医疗仪器、在无任何外院的支持下已完成胜任全院各类急、危、重病人的各种手术，和心肺复苏抢救，以及手术科室的各类临床科研任务的先进科室。\r\n\r\n  全科人员共有22人，其中麻醉师有8人，护士有14人，共有5个手术间，每间均配有先进的麻醉机以及麻醉监测仪一台，另有心电除颤仪一台,C型臂一台，电子显微镜2台，以及先进的胸腔镜、腹腔镜、宫腔镜、关节镜、前列腺电切镜个一台，手术间均配有空气消毒系统。','y'),(48,'放射科(住院)',2,' 放射科成立于1979年。在医院正确领导下，通过全科业务人员多年来努力，现已成为本地区设备先进、技术精湛、服务优良的专业科室。担负本地区及医学院校影像专业技术人员进修、实习培训，是放射影像医教研基地。专业设置：普放、CT、MRI、介入治疗专业，实行24小时值班。','y'),(49,'超声科(住院)',2,'我院超声医学学科为四川省甲级重点学科，并为专业硕士学位授权点，属国家级住院医师规范化培训基地。承担了成都医学院5年制医学影像系等不同学科本科生和研究生教育、规培生及继续教育等教学任务；所培养研究生或实习生连续多年在全国高等医学院校大学生临床技能竞赛中获奖。我科结合受援医院发展需求认真做好对口支援，向受援医院派出支援医生，开展义诊巡诊、举办学术讲座等。','y'),(50,'检验科(住院)',2,'现科下设微生物专业组、生化与免疫专业组、基础检验与细胞学、内分泌专业组、分子生物学专业组、西院综合组6个专业组。国内率先设立检验门诊，平均每天接诊超过40人次；积极参与临床查房，共计百余次。按照“准确、快捷、热情”的质量方针，根据CNAS－CL02：2012《医学实验室质量和能力认可准则》（ISO15189: 2012, IDT）及CAP的技术要求建立并运行质量管理体系，于2008年通过国家合格评定认可委员会组织的专家评审并获得ISO15189认可证书；于2014年通过美国临床病理家学会（CAP）的实验室','y'),(51,'付费科',4,'负责费用管理','n'),(52,'手术外科(住院)',2,'普外科是医院重点学科，是丰台区肝胆外科治疗中心，以胃肠道肿瘤、肝胆、腺体（乳腺、甲状腺等）、腹腔镜外科为主要治疗方向的专业技术特色科室，近年来普外科取得了长足的进步，形成了以肝胆外科、肿瘤、微创治疗和创伤急救为中心的发展方向。\r\n\r\n普外科目前开放床位90张，共有医护人员60余人，其中拥有副高以上职称人员10人，主治医师、主管护师16人，硕士研究生7名，人才梯队日趋合理。','y'),(61,'资产科',4,'负责固定资产的管理','n');

/*Table structure for table `ho_doctor_advice` */

DROP TABLE IF EXISTS `ho_doctor_advice`;

CREATE TABLE `ho_doctor_advice` (
  `da_id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pt_id` int NOT NULL COMMENT '病人ID',
  `d_id` int DEFAULT NULL COMMENT '药品ID',
  `da_item` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '医嘱条陈',
  `da_create_time` datetime DEFAULT NULL COMMENT '开医嘱的时间',
  `w_id` int NOT NULL COMMENT '医师ID',
  `d_num` int DEFAULT NULL COMMENT '开药的数量',
  `d_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '当前医嘱是否付费y-已付',
  PRIMARY KEY (`da_id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_doctor_advice` */

insert  into `ho_doctor_advice`(`da_id`,`pt_id`,`d_id`,`da_item`,`da_create_time`,`w_id`,`d_num`,`d_status`) values (1,1,1,NULL,NULL,2,2,'y'),(2,2,2,NULL,NULL,5,3,'y'),(3,3,3,NULL,NULL,3,4,'y'),(4,4,4,NULL,NULL,4,5,'y'),(5,6,5,'可以出院了',NULL,3,6,'y'),(6,6,2,'呜呜呜呜呜呜','2021-03-15 21:16:58',3,3,'y'),(7,26,7,'','2021-03-15 21:30:23',3,7,'y'),(8,26,12,'','2021-03-15 21:30:23',3,9,'y'),(9,26,3,'','2021-03-15 21:30:23',3,1,'y'),(10,26,6,'','2021-03-15 21:30:23',3,3,'y'),(11,26,3,'多吃药','2021-03-15 21:30:42',3,1,'y'),(12,26,12,'多吃药','2021-03-15 21:30:42',3,9,'y'),(13,26,6,'多吃药','2021-03-15 21:30:42',3,3,'y'),(14,26,7,'多吃药','2021-03-15 21:30:42',3,7,'y'),(15,26,25,'','2021-03-15 21:58:06',3,30,'y'),(16,26,23,'','2021-03-15 21:58:06',3,1,'n'),(17,26,1,'','2021-03-15 21:58:06',3,30,'y'),(18,26,4,'','2021-03-15 21:58:06',3,5,'y'),(19,26,21,'','2021-03-15 21:58:06',3,24,'y'),(20,26,6,'','2021-03-15 21:58:06',3,28,'y'),(21,26,4,'啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊阿','2021-03-15 22:01:23',3,6,'y'),(22,26,23,'啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊阿','2021-03-15 22:01:23',3,16,'y'),(23,26,7,'啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊阿','2021-03-15 22:01:23',3,7,'y'),(24,3,1,'','2021-03-16 09:41:52',3,4,'n'),(25,3,5,'','2021-03-16 10:39:30',3,3,'n'),(26,3,4,'','2021-03-16 10:39:30',3,12,'y'),(27,22,2,'多吃药','2021-03-16 11:52:32',4,4,'y'),(28,22,1,'多吃药','2021-03-16 11:52:32',4,1,'y'),(29,22,3,'多吃药','2021-03-16 11:52:32',4,5,'y'),(30,3,5,'','2021-03-16 17:16:04',3,5,'y'),(31,3,1,'','2021-03-16 17:16:04',3,1,'n'),(32,31,1,'多吃药666','2021-03-16 19:04:41',4,1,'n'),(33,3,5,'多吃药多吃药','2021-03-16 19:29:41',3,2,'y'),(34,3,4,'多吃药多吃药','2021-03-16 19:29:41',3,5,'n'),(35,31,1,'888888','2021-03-16 19:30:19',4,3,'y'),(37,22,5,NULL,'2021-03-16 20:49:04',7,6,'y'),(38,22,7,NULL,'2021-03-16 20:49:04',7,2,'y'),(40,22,25,NULL,'2021-03-16 21:02:23',7,5,'y'),(41,31,1,'3657345663','2021-03-17 11:01:44',4,30,'n'),(42,3,4,'','2021-03-17 11:11:51',3,2,'y'),(43,3,5,'','2021-03-17 11:11:51',3,4,'y'),(44,3,4,'','2021-03-17 14:31:34',3,5,'y'),(45,3,6,'','2021-03-17 14:31:34',3,7,'y'),(46,3,4,'吃药了孩子','2021-03-17 14:33:54',3,15,'y'),(47,3,7,'吃药了孩子','2021-03-17 14:33:54',3,7,'n'),(48,3,1,'吃吃吃','2021-03-17 15:32:32',3,2,'y'),(49,3,25,'吃吃吃','2021-03-17 15:32:32',3,7,'n'),(50,3,3,'','2021-03-17 18:30:05',3,3,'y'),(51,3,3,'','2021-03-17 18:30:05',3,4,'y'),(52,3,3,'','2021-03-17 18:30:07',3,3,'y'),(53,3,3,'','2021-03-17 18:30:07',3,4,'y'),(54,3,3,'','2021-03-17 18:30:08',3,4,'y'),(55,3,3,'','2021-03-17 18:30:08',3,3,'y'),(56,3,3,'','2021-03-17 18:30:09',3,3,'y'),(57,3,3,'','2021-03-17 18:30:09',3,4,'y'),(58,3,3,'','2021-03-17 18:30:09',3,3,'n'),(59,3,3,'','2021-03-17 18:30:09',3,4,'y'),(60,3,5,'','2021-03-17 18:50:29',3,5,'n'),(61,3,7,'','2021-03-17 18:52:24',3,7,'n'),(62,3,6,'','2021-03-17 18:52:24',3,6,'n'),(63,3,7,'','2021-03-17 18:53:45',3,6,'n'),(64,3,4,'','2021-03-17 18:55:32',3,6,'n'),(65,3,3,'','2021-03-17 18:57:48',3,4,'n'),(66,3,3,'','2021-03-17 18:58:03',3,4,'n'),(67,3,3,'','2021-03-17 19:00:35',3,4,'n'),(68,3,3,'','2021-03-17 19:00:44',3,4,'n'),(69,3,4,'','2021-03-17 19:01:28',3,3,'y'),(70,3,4,'','2021-03-17 19:01:35',3,3,'y'),(71,3,3,'','2021-03-17 19:03:29',3,3,'y'),(72,3,1,'没你你你','2021-03-17 19:04:19',3,1,'y'),(73,3,4,'','2021-03-17 19:07:56',3,3,'n'),(74,3,1,'好好吃药','2021-03-17 19:32:49',3,1,'y'),(75,3,5,'麦麦好','2021-03-17 20:14:55',3,4,'y'),(76,3,1,'','2021-03-17 20:46:45',3,1,'y'),(77,3,7,'','2021-03-17 20:46:45',3,7,'n'),(78,29,13,'多吃药就会好','2021-03-18 09:34:02',3,4,'n'),(79,29,19,'多吃药就会好','2021-03-18 09:34:02',3,11,'n'),(80,29,5,'多吃药就会好','2021-03-18 09:34:02',3,4,'n'),(81,29,1,'多吃药就会好','2021-03-18 09:34:02',3,1,'y'),(82,29,15,'多吃药就会好','2021-03-18 09:34:02',3,3,'n'),(83,29,6,'多吃药就会好','2021-03-18 09:34:02',3,7,'y'),(84,29,2,'多吃药就会好','2021-03-18 09:34:02',3,27,'y'),(85,29,16,'多吃药就会好','2021-03-18 09:34:02',3,1,'n'),(86,29,6,'','2021-03-18 09:34:47',3,5,'y'),(87,29,7,'','2021-03-18 09:40:37',3,6,'n'),(88,29,6,'','2021-03-18 09:40:37',3,6,'y'),(89,29,4,'','2021-03-18 09:41:22',3,5,'y'),(90,29,6,'','2021-03-18 09:41:22',3,6,'y'),(91,29,6,'','2021-03-18 09:44:01',3,1,'y'),(92,29,10,'','2021-03-18 09:44:01',3,6,'y'),(93,29,7,'','2021-03-18 09:44:30',3,1,'n'),(94,29,2,'','2021-03-18 09:44:30',3,4,'y'),(95,29,3,'每天吃三次药','2021-03-18 09:45:56',3,2,'n'),(96,29,4,'每次吃两颗','2021-03-18 09:46:24',3,4,'y'),(97,29,7,'饭后吃','2021-03-18 09:47:33',3,2,'n'),(98,3,7,'','2021-03-18 12:03:27',3,7,'n'),(99,19,4,'','2021-03-18 17:22:27',12,4,'n'),(100,19,5,'','2021-03-18 18:37:17',12,4,'n'),(101,19,2,'','2021-03-18 18:37:17',12,5,'n'),(102,19,3,'','2021-03-18 18:37:17',12,4,'n'),(103,19,5,'','2021-03-18 18:37:17',12,5,'n'),(104,19,3,'','2021-03-18 18:37:17',12,3,'n'),(105,19,6,'','2021-03-18 18:37:17',12,6,'n'),(106,19,4,'','2021-03-18 18:37:17',12,5,'n'),(107,19,4,'','2021-03-18 18:37:17',12,4,'n'),(108,19,4,'','2021-03-18 18:37:17',12,4,'n'),(109,19,4,'','2021-03-18 18:37:17',12,30,'n'),(110,19,4,'','2021-03-18 18:37:17',12,5,'n'),(111,19,5,'','2021-03-18 18:37:17',12,30,'n'),(112,26,4,'','2021-03-19 10:23:55',3,6,'n'),(113,26,26,'','2021-03-19 10:23:55',3,2,'n'),(114,26,6,'','2021-03-19 10:23:55',3,14,'n'),(115,26,6,'','2021-03-19 10:23:55',3,6,'n'),(116,26,1,'','2021-03-19 10:23:55',3,2,'n'),(117,26,19,'','2021-03-19 10:23:55',3,6,'n'),(118,33,3,'','2021-03-19 10:31:50',3,3,'n'),(119,39,4,NULL,'2021-03-19 11:08:15',12,3,'n'),(120,45,6,NULL,'2021-03-19 11:27:50',12,4,'y');

/*Table structure for table `ho_drug` */

DROP TABLE IF EXISTS `ho_drug`;

CREATE TABLE `ho_drug` (
  `d_id` int NOT NULL AUTO_INCREMENT COMMENT '药品ID',
  `d_card` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '药品编号',
  `d_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '药品名称',
  `d_brand` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '药品品牌',
  `d_prescription` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '是否处方药',
  `d_in_price` decimal(10,0) NOT NULL COMMENT '进价',
  `d_out_price` decimal(10,0) NOT NULL COMMENT '售价',
  `d_stock` int DEFAULT NULL COMMENT '库存',
  `d_status` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态',
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_drug` */

insert  into `ho_drug`(`d_id`,`d_card`,`d_name`,`d_brand`,`d_prescription`,`d_in_price`,`d_out_price`,`d_stock`,`d_status`) values (1,'01011','氯碳头孢','同仁堂','y','33','40',2000,'n'),(2,'01012','阿莫西林','同仁堂','n','51','100',968,'y'),(3,'01013','青霉素','同仁堂','y','70','130',964,'n'),(4,'02004','维生素K1','同仁堂','y','46','67',1951,'y'),(5,'02005','双嘧达注射液','同仁堂','y','79','100',1184,'n'),(6,'03001','果糖二磷酸钠注射液','同仁堂','n','47','38',933,'y'),(7,'02006','地高辛片','同仁堂','y','46','36',100,'n'),(8,'04001','胸腺肽注射液','同仁堂','y','47','37',111,'n'),(9,'05001','氯雷他定片','九芝堂','y','47','37',17,'y'),(10,'06010','单氯酚那酸片','九芝堂','y','47','37',194,'y'),(11,'10010','氯霉素滴眼液','九芝堂','y','70','37',16,'n'),(12,'13020','地奥司明片','九芝堂','y','7','27',14,'y'),(13,'01014','盐酸林可霉素胶囊','九芝堂','y','47','37',20,'n'),(14,'05006','碘[131I]化钠口服溶液','修正','y','47','37',121,'y'),(15,'07008','碳酸氢钠片','修正','y','47','37',1000,'n'),(16,'09023','酚酞片','修正','y','467','377',50,'y'),(19,'08012','葡萄糖','云南白药','y','487','317',24,'y'),(20,'20102','乙酰阿法甲基芬太尼','云南白药','y','47','37',15,'n'),(21,'20103','阿法甲基硫代芬太尼','云南白药','y','47','37',4,'n'),(22,'20128','氯尼他秦','哈药','y','147','317',16,'y'),(23,'20230','6-氨基己酸','哈药','y','417','367',1,'n'),(25,'1615523291897','布洛芬缓释胶囊','云南白药','n','52','55',495,'y'),(26,'1615886928816','头孢','同仁堂','n','200','400',13,'n'),(27,'1615968209763','板蓝根','云南白药','n','10','11',10000,'y'),(28,'1616123721920','乙酰半胱氨酸泡腾片','富露施','n','30','50',100,'n');

/*Table structure for table `ho_drug_record` */

DROP TABLE IF EXISTS `ho_drug_record`;

CREATE TABLE `ho_drug_record` (
  `dr_id` int NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `d_id` int NOT NULL COMMENT '药品ID',
  `dr_number` int NOT NULL COMMENT '数量',
  `dr_create_time` datetime NOT NULL COMMENT '出入库时间',
  `dr_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '出入库状态-y/n',
  PRIMARY KEY (`dr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_drug_record` */

insert  into `ho_drug_record`(`dr_id`,`d_id`,`dr_number`,`dr_create_time`,`dr_status`) values (1,1,2000,'2021-02-02 17:14:40','y'),(2,2,1000,'2021-03-09 17:15:16','y'),(3,3,1000,'2021-03-08 17:15:32','y'),(4,4,2000,'2020-12-11 17:15:43','y'),(5,5,1200,'2020-11-11 17:15:54','y'),(6,6,1000,'2021-03-03 17:16:25','y'),(7,25,500,'2021-03-12 12:28:12','y'),(8,26,20,'2021-03-16 17:28:49','y'),(9,7,102,'2021-03-16 21:05:42','y'),(10,15,1000,'2021-03-16 21:18:02','y'),(11,16,50,'2021-03-16 21:18:08','y'),(12,19,24,'2021-03-16 21:18:12','y'),(13,20,15,'2021-03-16 21:18:18','y'),(14,23,17,'2021-03-16 21:18:33','y'),(15,21,28,'2021-03-16 21:18:38','y'),(16,22,16,'2021-03-16 21:18:42','y'),(17,14,121,'2021-03-16 21:18:50','y'),(18,11,16,'2021-03-16 21:18:55','y'),(19,12,14,'2021-03-16 21:19:03','y'),(20,13,20,'2021-03-16 21:19:10','y'),(21,10,200,'2021-03-16 21:19:18','y'),(22,9,17,'2021-03-16 21:19:30','y'),(23,8,111,'2021-03-16 21:19:35','y'),(24,27,10000,'2021-03-17 16:03:30','y'),(25,28,100,'2021-03-19 11:15:22','y'),(26,1,39,'2021-03-19 12:17:24','y');

/*Table structure for table `ho_equipment` */

DROP TABLE IF EXISTS `ho_equipment`;

CREATE TABLE `ho_equipment` (
  `eq_id` int NOT NULL AUTO_INCREMENT COMMENT '设备id',
  `dpc_id` int NOT NULL COMMENT '科室id',
  `eq_name` varchar(20) DEFAULT NULL COMMENT '设备价格',
  `eq_price` decimal(20,0) DEFAULT NULL COMMENT '设备价格',
  `eq_number` int DEFAULT NULL COMMENT '设备数量',
  `eq_saplings` varchar(20) DEFAULT NULL COMMENT '设备编号',
  `eq_state` char(1) DEFAULT NULL COMMENT '设备状态:y正常,n损坏',
  PRIMARY KEY (`eq_id`),
  KEY `dpc_id` (`dpc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `ho_equipment` */

insert  into `ho_equipment`(`eq_id`,`dpc_id`,`eq_name`,`eq_price`,`eq_number`,`eq_saplings`,`eq_state`) values (1,1,'呼吸机','999',1200,'1','y'),(2,1,'吸尘器','20',50,'2','n'),(3,1,'氧气瓶','60',10,'3','n'),(5,1,'负压瓶','40',100,'5','y'),(6,3,'胃镜','1300',130,'6','y'),(8,13,'CT机','100000',20,'1615881298869','y'),(9,42,'核磁共振机','120000',10,'1615881350803','y'),(12,43,'除颤器','1000',1000,'1615885102117','y'),(13,47,'中心负压吸引设备','10000',10,'1615885175757','n'),(14,61,'抢救车','12300',10,'1615885247597','y'),(16,7,'心电图','10000',100,'1615888804809','y'),(18,1,'呼吸机','123',123,'1615954790899','n'),(38,31,'氧气袋','100',100,'1615963167218','y'),(39,32,'电子计算机断层扫描','2000',5,'1616065554007','n'),(40,34,'彩超','2000',20,'1616066020786','y'),(41,5,'快速血糖仪微量泵','7000',10,'1616123323836','y'),(42,34,'颅内压监测仪','2000',1,'1616123390836','y'),(43,7,'心电图机动态心电监测系统','10000',1,'1616123429525','y');

/*Table structure for table `ho_equipment_records` */

DROP TABLE IF EXISTS `ho_equipment_records`;

CREATE TABLE `ho_equipment_records` (
  `eqr_id` int NOT NULL AUTO_INCREMENT COMMENT '设备记录id',
  `eq_id` int NOT NULL COMMENT '设备id',
  `eq_price` decimal(20,2) DEFAULT NULL COMMENT '设备价格',
  `eq_number` int DEFAULT NULL COMMENT '设备数量',
  `eq_purchase_time` datetime DEFAULT NULL COMMENT '设备添加时间',
  PRIMARY KEY (`eqr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `ho_equipment_records` */

insert  into `ho_equipment_records`(`eqr_id`,`eq_id`,`eq_price`,`eq_number`,`eq_purchase_time`) values (2,32,'12312.00',12,'2021-03-16 13:15:33'),(3,34,'123000.00',1,'2021-03-17 14:34:53'),(4,36,'999.00',1,'2021-03-17 14:38:26'),(5,37,'9999.00',1,'2021-03-17 14:38:26'),(6,35,'9999.00',1,'2021-03-17 14:38:26'),(7,38,'100.00',100,'2021-03-17 14:39:27'),(8,39,'2000.00',5,'2021-03-18 19:05:54'),(9,40,'2000.00',20,'2021-03-18 19:13:41'),(10,41,'7000.00',10,'2021-03-19 11:08:44'),(11,42,'2000.00',1,'2021-03-19 11:09:51'),(12,43,'10000.00',1,'2021-03-19 11:10:30');

/*Table structure for table `ho_hospitalization` */

DROP TABLE IF EXISTS `ho_hospitalization`;

CREATE TABLE `ho_hospitalization` (
  `hh_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pt_card` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '患者编号',
  `w_id` int NOT NULL COMMENT '对应医生id',
  `dpc_id` int NOT NULL COMMENT '对应科室id',
  `hih_card` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '对应病房编号',
  `hib_card` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '对应病床编号',
  `hh_create_time` datetime DEFAULT NULL COMMENT '开始时间',
  `hh_over_time` datetime DEFAULT NULL COMMENT '结束时间',
  `hh_status` varchar(10) COLLATE utf8mb4_bin NOT NULL COMMENT '状态',
  PRIMARY KEY (`hh_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_hospitalization` */

insert  into `ho_hospitalization`(`hh_id`,`pt_card`,`w_id`,`dpc_id`,`hih_card`,`hib_card`,`hh_create_time`,`hh_over_time`,`hh_status`) values (1,'1615771298633',4,5,'nfm001','001','2020-08-20 14:46:19',NULL,'y'),(2,'1615711189891',2,1,'nfm001','002','2021-03-15 21:09:06',NULL,'n'),(4,'1616120069963',12,13,'nfm001','001','2021-03-19 10:31:34',NULL,'n'),(5,'1616122991282',12,13,'nfm001','004','2021-02-03 11:27:03',NULL,'n'),(7,'1616122950933',12,13,'nfm001','003','2021-03-19 11:36:38',NULL,'n'),(8,'1616122909186',12,13,'nfm001','004','2021-03-19 12:08:35',NULL,'y');

/*Table structure for table `ho_ill_bed` */

DROP TABLE IF EXISTS `ho_ill_bed`;

CREATE TABLE `ho_ill_bed` (
  `hib_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `hib_card` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '病床编号',
  `hih_card` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '对应的病房编号',
  `hib_price` decimal(10,0) NOT NULL COMMENT '病床的价格',
  `hib_status` varchar(10) COLLATE utf8mb4_bin NOT NULL COMMENT '病床的状态',
  PRIMARY KEY (`hib_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_ill_bed` */

insert  into `ho_ill_bed`(`hib_id`,`hib_card`,`hih_card`,`hib_price`,`hib_status`) values (1,'001','nfm001','100','n'),(2,'002','nfm001','100','y'),(3,'003','nfm001','100','y'),(4,'004','nfm001','100','n');

/*Table structure for table `ho_ill_house` */

DROP TABLE IF EXISTS `ho_ill_house`;

CREATE TABLE `ho_ill_house` (
  `hih_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `hih_card` varchar(30) COLLATE utf8mb4_bin NOT NULL COMMENT '病房编号',
  `dpc_id` int NOT NULL COMMENT '对应的科室id',
  `patient_num` int NOT NULL COMMENT '已住的患者数量',
  `hih_status` varchar(10) COLLATE utf8mb4_bin NOT NULL COMMENT '病房状态',
  PRIMARY KEY (`hih_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_ill_house` */

insert  into `ho_ill_house`(`hih_id`,`hih_card`,`dpc_id`,`patient_num`,`hih_status`) values (1,'nfm001',42,4,'y');

/*Table structure for table `ho_inspect_items` */

DROP TABLE IF EXISTS `ho_inspect_items`;

CREATE TABLE `ho_inspect_items` (
  `hit_id` int NOT NULL AUTO_INCREMENT,
  `hit_name` char(30) DEFAULT NULL,
  `hdc_id` int DEFAULT NULL,
  `hit_price` decimal(10,2) DEFAULT NULL,
  `hit_status` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`hit_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `ho_inspect_items` */

insert  into `ho_inspect_items`(`hit_id`,`hit_name`,`hdc_id`,`hit_price`,`hit_status`) values (1,'普通体检',3,'88.00','y'),(2,'B超',32,'200.00','n'),(3,'核磁共振',33,'200.00','y'),(4,'肝胆功能检查',31,'100.00','n'),(5,'血液检查',9,'75.00','y'),(6,'X光检查',31,'200.00','y'),(8,'普通体检1',34,'164.00','n'),(9,'胃镜检查',3,'88.88','y'),(10,'肿瘤标记物检测',32,'258.00','n'),(11,'胸透',32,'280.00','y'),(12,'割痔疮',35,'1800.00','n'),(13,'尿检',34,'1000.00','y');

/*Table structure for table `ho_inspect_record` */

DROP TABLE IF EXISTS `ho_inspect_record`;

CREATE TABLE `ho_inspect_record` (
  `hir_id` int NOT NULL AUTO_INCREMENT COMMENT '检查申请ID',
  `hir_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '检查申请编号',
  `hit_id` int NOT NULL COMMENT '检查项目ID',
  `hit_price` decimal(10,2) NOT NULL COMMENT '检查项目价格',
  `pt_id` int NOT NULL COMMENT '检查病人ID',
  `hir_date` datetime NOT NULL COMMENT '检查(申请时间/支付时间)',
  `hir_status` char(1) COLLATE utf8mb4_bin NOT NULL COMMENT '付费状态(y/n)',
  `w_card` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '医师编号',
  PRIMARY KEY (`hir_id`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_inspect_record` */

insert  into `ho_inspect_record`(`hir_id`,`hir_card`,`hit_id`,`hit_price`,`pt_id`,`hir_date`,`hir_status`,`w_card`) values (1,'1000001',1,'88.00',1,'2021-03-13 10:46:37','y','YS001'),(2,'1000002',2,'200.00',2,'2021-03-13 11:22:02','y','YS002'),(3,'1000003',3,'200.00',3,'2021-03-15 10:47:20','y','YS003'),(4,'1615798958349',1,'88.00',3,'2021-03-15 17:02:38','y','YS002'),(5,'1615798958349',2,'200.00',3,'2021-03-15 17:02:38','y','YS002'),(6,'1615812986009',1,'88.00',6,'2021-03-15 20:56:26','y','YS002'),(7,'1615812986009',2,'200.00',6,'2021-03-15 20:56:26','y','YS002'),(8,'1615812986009',4,'100.00',6,'2021-03-15 20:56:26','y','YS002'),(9,'1615812986009',5,'75.00',6,'2021-03-15 20:56:26','y','YS002'),(10,'1615816819373',1,'88.00',26,'2021-03-15 22:00:19','y','YS002'),(11,'1615816819373',2,'200.00',26,'2021-03-15 22:00:19','y','YS002'),(12,'1615816819373',3,'200.00',26,'2021-03-15 22:00:19','y','YS002'),(13,'1615816819373',10,'258.00',26,'2021-03-15 22:00:19','y','YS002'),(14,'1615816857532',2,'200.00',26,'2021-03-15 22:00:58','y','YS002'),(15,'1615816857532',3,'200.00',26,'2021-03-15 22:00:58','y','YS002'),(16,'1615816857532',4,'100.00',26,'2021-03-15 22:00:58','y','YS002'),(17,'1615816857532',8,'164.00',26,'2021-03-15 22:00:58','y','YS002'),(18,'1615816857532',10,'258.00',26,'2021-03-15 22:00:58','y','YS002'),(19,'1615816857532',11,'280.00',26,'2021-03-15 22:00:58','y','YS002'),(20,'1615866843824',1,'88.00',22,'2021-03-16 17:19:49','y','YS003'),(21,'1615866843824',2,'200.00',22,'2021-03-16 17:19:53','y','YS003'),(22,'1615876274557',1,'88.00',29,'2021-03-16 14:31:15','n','YS002'),(23,'1615876274617',2,'200.00',29,'2021-03-16 14:31:15','n','YS002'),(24,'1615876274653',3,'200.00',29,'2021-03-16 21:04:13','y','YS002'),(25,'1615896809948',2,'200.00',22,'2021-03-08 20:13:29','n','YZ001'),(26,'1615896825668',12,'1800.00',22,'2021-03-08 20:13:45','n','YZ001'),(27,'1615899839099',3,'200.00',22,'2021-03-09 21:03:59','n','YZ001'),(28,'1615950659201',1,'88.00',3,'2021-03-17 11:10:59','n','YS002'),(29,'1615950659255',2,'200.00',3,'2021-03-17 11:10:59','n','YS002'),(30,'1615950659309',3,'200.00',3,'2021-03-17 11:10:59','n','YS002'),(31,'1615950733077',2,'20000.00',3,'2021-03-17 11:12:13','y','YS002'),(32,'1615950733126',3,'200.00',3,'2021-03-17 20:53:11','y','YS002'),(33,'1615950733174',4,'100.00',3,'2021-03-17 11:12:13','n','YS002'),(34,'1615962855912',1,'88.00',3,'2021-03-17 20:53:13','y','YS002'),(35,'1615962855958',2,'200.00',3,'2021-03-17 20:53:08','y','YS002'),(36,'1615962856003',3,'200.00',3,'2021-03-17 14:34:16','n','YS002'),(37,'1615966365462',1,'88.00',3,'2021-03-17 15:32:45','n','YS002'),(38,'1615966365531',11,'280.00',3,'2021-03-17 15:32:45','n','YS002'),(39,'1615966365562',12,'1800.00',3,'2021-03-17 15:32:45','n','YS002'),(40,'1615966365600',13,'1000.00',3,'2021-03-17 15:32:45','n','YS002'),(41,'1615975914716',3,'200.00',22,'2021-03-06 18:11:54','n','YZ001'),(42,'1615976533958',1,'88.00',3,'2021-03-17 18:22:14','n','YS002'),(43,'1615976534031',2,'200.00',3,'2021-03-17 18:22:14','n','YS002'),(44,'1615976534069',3,'200.00',3,'2021-03-17 18:22:14','n','YS002'),(45,'1615976639651',1,'88.00',3,'2021-03-17 18:24:00','n','YS002'),(46,'1615976639709',2,'200.00',3,'2021-03-17 18:24:00','n','YS002'),(47,'1615976668170',2,'200.00',3,'2021-03-17 18:24:28','n','YS002'),(48,'1615976668203',4,'100.00',3,'2021-03-17 18:24:28','n','YS002'),(49,'1615976679663',1,'88.00',3,'2021-03-17 18:24:40','n','YS002'),(50,'1615976679760',3,'200.00',3,'2021-03-17 18:24:40','n','YS002'),(51,'1615976713938',3,'200.00',3,'2021-03-17 18:25:14','n','YS002'),(52,'1615976714041',5,'75.00',3,'2021-03-17 18:25:14','n','YS002'),(53,'1615980880481',1,'88.00',3,'2021-03-17 19:34:40','n','YS002'),(54,'1615980880582',2,'200.00',3,'2021-03-17 19:34:40','n','YS002'),(55,'1615983531370',1,'88.00',3,'2021-03-17 20:18:51','n','YS002'),(56,'1615983531417',2,'200.00',3,'2021-03-17 20:18:51','n','YS002'),(57,'1615983531451',3,'200.00',3,'2021-03-17 20:18:51','n','YS002'),(58,'1615986028495',3,'200.00',22,'2021-03-09 21:00:28','n','YS003'),(59,'1616031168542',1,'88.00',29,'2021-03-18 09:32:49','n','YS002'),(60,'1616031168592',2,'200.00',29,'2021-03-18 09:32:49','n','YS002'),(61,'1616031168643',3,'200.00',29,'2021-03-18 09:32:49','n','YS002'),(62,'1616031168701',4,'100.00',29,'2021-03-18 09:32:49','n','YS002'),(63,'1616031168748',5,'75.00',29,'2021-03-18 09:32:49','n','YS002'),(64,'1616031168795',6,'200.00',29,'2021-03-18 09:32:49','n','YS002'),(65,'1616031168852',8,'164.00',29,'2021-03-18 09:32:49','n','YS002'),(66,'1616031168908',9,'88.88',29,'2021-03-18 09:32:49','n','YS002'),(67,'1616031168965',10,'258.00',29,'2021-03-18 09:32:49','n','YS002'),(68,'1616031169014',11,'280.00',29,'2021-03-18 09:32:49','n','YS002'),(69,'1616031169071',13,'1000.00',29,'2021-03-18 09:32:49','n','YS002'),(70,'1616032073292',1,'88.00',29,'2021-03-18 11:36:49','y','YS002'),(71,'1616032073335',2,'200.00',29,'2021-03-18 11:34:25','y','YS002'),(72,'1616040199130',4,'100.00',3,'2021-03-18 12:03:19','n','YS002'),(73,'1616040199214',5,'75.00',3,'2021-03-18 12:03:19','n','YS002'),(74,'1616120662570',1,'88.00',3,'2021-03-19 11:24:11','y','YS002'),(75,'1616120662624',2,'200.00',3,'2021-03-19 10:24:23','n','YS002'),(76,'1616120662655',3,'200.00',3,'2021-03-19 10:24:23','n','YS002'),(77,'1616120662686',4,'100.00',3,'2021-03-19 10:24:23','n','YS002'),(78,'1616120662771',5,'75.00',3,'2021-03-19 10:24:23','n','YS002'),(79,'1616120662809',6,'200.00',3,'2021-03-19 10:24:23','n','YS002'),(80,'1616120662856',8,'164.00',3,'2021-03-19 10:24:23','n','YS002'),(81,'1616121120275',1,'88.00',3,'2021-03-19 10:32:00','n','YS002'),(82,'1616121120307',2,'200.00',3,'2021-03-19 10:32:00','n','YS002'),(83,'1616121120344',3,'200.00',3,'2021-03-19 10:32:00','n','YS002'),(84,'1616121144071',2,'200.00',3,'2021-03-19 10:32:24','n','YS002'),(85,'1616121144103',3,'200.00',3,'2021-03-19 10:32:24','n','YS002'),(86,'1616121144249',4,'100.00',3,'2021-03-19 10:32:24','n','YS002'),(87,'1616121144287',5,'75.00',3,'2021-03-19 10:32:24','n','YS002'),(88,'1616123304039',2,'200.00',39,'2021-03-11 11:08:24','n','YS89427052'),(89,'1616123434502',1,'88.00',39,'2021-03-11 11:10:34','n','YS89427052'),(90,'1616123787291',12,'1800.00',39,'2021-03-19 11:16:27','n','YS89427052'),(91,'1616124496782',11,'280.00',45,'2021-03-19 11:28:25','y','YS89427052');

/*Table structure for table `ho_operation_record` */

DROP TABLE IF EXISTS `ho_operation_record`;

CREATE TABLE `ho_operation_record` (
  `hor_id` int NOT NULL AUTO_INCREMENT COMMENT '手术记录表id',
  `hor_card` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '记录编号',
  `hoy_id` int DEFAULT NULL COMMENT '手术类型id',
  `pt_id` int DEFAULT NULL COMMENT '病人id',
  `w_id` int DEFAULT NULL COMMENT '医生id',
  `hor_price` decimal(10,2) DEFAULT NULL COMMENT '总费用',
  `hor_create_time` datetime DEFAULT NULL COMMENT '手术时间',
  `hor_status` varchar(2) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`hor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_operation_record` */

insert  into `ho_operation_record`(`hor_id`,`hor_card`,`hoy_id`,`pt_id`,`w_id`,`hor_price`,`hor_create_time`,`hor_status`) values (1,'123456789',1,22,4,'35000.00','2021-03-12 17:18:44','y'),(2,'1615897864453',1,7,2,'35000.00','2021-03-16 20:31:04','y'),(3,'1615901291657',2,7,4,'23000.00','2021-03-16 21:28:12','y'),(4,'1615901723711',4,22,7,'204000.00','2021-03-16 21:35:24','y'),(5,'1615986038774',10,22,4,'110000.00','2021-03-17 21:00:39','n'),(6,'1616123310199',5,39,12,'15000.00','2021-03-19 11:08:30','y'),(7,'1616124524453',3,45,12,'12000.00','2021-03-19 11:28:44','y');

/*Table structure for table `ho_operation_type` */

DROP TABLE IF EXISTS `ho_operation_type`;

CREATE TABLE `ho_operation_type` (
  `hoy_id` int NOT NULL AUTO_INCREMENT,
  `hoy_name` char(25) DEFAULT NULL,
  `hdc_id` int DEFAULT NULL COMMENT '科室id',
  `hoy_price` decimal(10,2) DEFAULT NULL COMMENT '手术费',
  `hoy_price_worker` decimal(10,2) DEFAULT NULL COMMENT '人工费',
  `hoy_status` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`hoy_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `ho_operation_type` */

insert  into `ho_operation_type`(`hoy_id`,`hoy_name`,`hdc_id`,`hoy_price`,`hoy_price_worker`,`hoy_status`) values (1,'心脏搭桥',31,'30000.00','5000.00','n'),(2,'肝脏移植',31,'20000.00','3000.00','y'),(3,'接骨手术',35,'10000.00','2000.00','n'),(4,'整形手术',35,'200000.00','4000.00','y'),(5,'截肢手术',35,'10000.00','5000.00','n'),(6,'外科手术1',35,'8000.00','2000.00','y'),(7,'截肢手术2',31,'10000.00','6000.00','y'),(8,'大肠移植',31,'1000.00','1000.00','y'),(9,'小肠移植',31,'2000.00','1200.00','y'),(10,'心脏移植',31,'100000.00','10000.00','y'),(11,'换头手术',1,'1000000.00','12000.00','y');

/*Table structure for table `ho_patients` */

DROP TABLE IF EXISTS `ho_patients`;

CREATE TABLE `ho_patients` (
  `pt_id` int NOT NULL AUTO_INCREMENT COMMENT '病人ID',
  `pt_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '病人编号',
  `pt_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '病人姓名',
  `pt_gender` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '病人性别',
  `pt_age` int NOT NULL COMMENT '病人年龄',
  `pt_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '病人电话',
  `rt_id` int NOT NULL COMMENT '挂号类型ID',
  `rc_id` int NOT NULL COMMENT '挂号费ID',
  `dpc_id` int NOT NULL COMMENT '科室ID',
  `w_id` int NOT NULL COMMENT '所属医师ID',
  `ts_id` int NOT NULL COMMENT '就诊状态ID',
  `pt_create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`pt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_patients` */

insert  into `ho_patients`(`pt_id`,`pt_card`,`pt_name`,`pt_gender`,`pt_age`,`pt_phone`,`rt_id`,`rc_id`,`dpc_id`,`w_id`,`ts_id`,`pt_create_time`) values (1,'100001','黄锐','男',21,'17200000000',1,1,1,2,1,'2020-02-25 11:09:38'),(2,'100002','张三','女',20,'14500000000',1,2,7,5,1,'2020-12-10 08:42:18'),(3,'100003','李四','男',35,'14500000000',3,1,3,3,1,'2020-12-15 22:43:44'),(4,'100004','王五','男',28,'12000000000',1,1,5,4,1,'2021-03-10 15:45:55'),(6,'100005','afafs','女',15,'4455445',2,1,3,3,1,'2021-03-10 18:49:07'),(7,'100006','dgbxf','男',50,'5434534',3,1,3,3,2,'2021-03-10 18:49:32'),(8,'100007','lklklj','女',55,'46446',1,1,3,3,3,'2021-03-10 18:49:56'),(9,'100008','ooewufv','男',80,'55555',1,1,7,5,1,'2021-03-10 13:50:31'),(10,'100009','asdfsfa','女',50,'33333',1,1,7,5,1,'2021-03-10 23:51:02'),(11,'100010','asdf','男',90,'sssss',1,1,7,5,1,'2021-03-10 06:51:36'),(12,'1615386508671','廖庆舜','女',21,'13800000000',3,2,3,3,1,'2021-03-10 22:28:29'),(13,'1615386749510','丽丽花','女',64,'15122222222',1,1,1,2,1,'2021-03-10 22:32:30'),(14,'1615386932519','尚悦','女',28,'15288888888',1,1,1,2,1,'2021-03-10 22:35:33'),(15,'1615534932842','林翠','男',28,'13827179783',3,2,3,3,1,'2021-03-12 15:42:13'),(16,'1615535117698','张欣','女',50,'5000000000',2,1,1,2,1,'2021-03-12 15:45:18'),(17,'1615535120877','唐秋','女',21,'13382891721',2,1,1,2,1,'2021-03-12 15:45:21'),(18,'1615535470496','楚曦','女',24,'13727281818',1,2,5,4,1,'2021-03-12 15:51:10'),(19,'1615625263427','姜独','男',50,'13800000000',1,1,1,12,1,'2021-03-13 16:47:43'),(20,'1615711189891','王老板','男',30,'15071317704',3,1,1,2,1,'2021-03-15 16:39:50'),(22,'1615771298633','李老板','男',40,'15071317704',3,2,5,4,1,'2021-03-15 09:21:39'),(23,'1615782389156','阿道灵','女',18,'15200000000',1,2,7,5,1,'2021-03-15 12:26:29'),(24,'1615791078333','闫半山','女',20,'12311111111',1,1,1,12,1,'2021-03-15 14:51:18'),(25,'1615812127194','李静','女',18,'13382919752',3,1,1,12,1,'2021-03-18 20:42:07'),(26,'1615814967293','李云龙','女',20,'17351828101',3,2,3,3,1,'2021-03-15 21:29:27'),(27,'1615858272165','许三多','女',12,'123123123',1,2,3,3,1,'2021-03-16 09:31:12'),(28,'1615858295220','张杰','女',34,'123453213',1,2,3,3,1,'2021-03-16 09:31:35'),(29,'1615858391302','王继伟','男',60,'65452131',1,2,3,3,1,'2021-03-16 09:33:11'),(31,'1615885491748','肖半天','女',25,'12345678900',3,2,5,4,2,'2021-03-16 17:04:52'),(32,'1615964116741','达克','男',40,'15129902',3,2,3,3,1,'2021-03-17 14:55:17'),(33,'1615964189939','樱岛麻衣','女',20,'921202112',3,2,3,3,1,'2021-03-17 14:56:30'),(34,'1615964359904','张三','男',30,'134920242',1,2,3,3,1,'2021-03-17 14:59:20'),(35,'1615972382334','安连云','男',13,'123103201',1,1,3,3,3,'2021-03-17 17:13:02'),(36,'1615972852838','张虎','女',12,'13383102111',1,2,1,2,3,'2021-03-17 17:20:53'),(38,'1616060234979','玛利亚','女',22,'15288888888',3,2,1,12,2,'2021-03-18 17:37:15'),(39,'1616120069963','万鑫','男',13,'15369856321',3,2,13,12,2,'2021-03-19 10:14:30'),(40,'1616122168963','薇姿','女',24,'123193',1,1,3,3,1,'2021-03-19 10:49:29'),(41,'1616122207237','吴强','男',45,'1329823',1,2,5,7,1,'2021-03-19 10:50:07'),(42,'1616122840881','燕池','女',26,'192313453',1,1,3,3,1,'2021-03-19 11:00:41'),(43,'1616122909186','古段','男',40,'1313213',3,2,13,12,2,'2021-03-19 11:01:49'),(44,'1616122950933','潘安','男',22,'2131324432',3,2,13,12,2,'2021-03-19 11:02:31'),(45,'1616122991282','潘峰','男',40,'532421231',3,2,13,12,1,'2021-03-19 11:03:11'),(46,'1616133608612','王磊','男',26,'15698569632',1,2,13,12,1,'2021-03-19 14:00:09');

/*Table structure for table `ho_pay` */

DROP TABLE IF EXISTS `ho_pay`;

CREATE TABLE `ho_pay` (
  `hp_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pt_id` int NOT NULL COMMENT '患者id',
  `hp_type` varchar(10) COLLATE utf8mb4_bin NOT NULL COMMENT '消费类型',
  `hp_price` decimal(10,0) NOT NULL COMMENT '消费金额',
  `hp_status` varchar(10) COLLATE utf8mb4_bin NOT NULL COMMENT '状态',
  `hp_create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`hp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_pay` */

insert  into `ho_pay`(`hp_id`,`pt_id`,`hp_type`,`hp_price`,`hp_status`,`hp_create_time`) values (4,22,'住院费','22800','y','2021-03-16 20:35:27'),(5,20,'住院费','2200','y','2021-03-17 11:25:43'),(6,26,'药品','5872','y','2021-03-18 11:32:07'),(7,29,'检查','88','y','2021-03-18 11:36:49'),(8,22,'手术','204000','y','2021-03-18 11:37:11'),(9,3,'检查','88','y','2021-03-19 11:24:11'),(10,39,'手术','15000','y','2021-03-19 11:24:49'),(11,3,'药品','335','y','2021-03-19 11:25:45'),(12,3,'药品','134','y','2021-03-19 11:25:52'),(13,45,'药品','152','y','2021-03-19 11:27:59'),(14,45,'检查','280','y','2021-03-19 11:28:26'),(15,45,'手术','12000','y','2021-03-19 11:28:53'),(16,45,'住院费','4400','y','2021-03-19 11:32:12'),(17,44,'住院费','0','y','2021-03-19 11:37:48'),(18,39,'住院费','0','y','2021-03-19 12:06:43');

/*Table structure for table `ho_perms` */

DROP TABLE IF EXISTS `ho_perms`;

CREATE TABLE `ho_perms` (
  `p_id` int NOT NULL AUTO_INCREMENT COMMENT '权限id',
  `p_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '权限名',
  `p_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '权限路径',
  `p_parentid` int DEFAULT NULL COMMENT '父权限id',
  `p_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '菜单级别',
  `p_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态',
  `p_percode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限码(controller方法上标记的)',
  `p_icon` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `p_component` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组件名',
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_perms` */

insert  into `ho_perms`(`p_id`,`p_name`,`p_code`,`p_parentid`,`p_type`,`p_status`,`p_percode`,`p_icon`,`p_component`) values (1,'挂号管理','register/manager',NULL,'x','y','register:manager','el-icon-notebook-2',''),(2,'挂号登记','/register/add',1,'y','y','register:add',NULL,'AddRegister'),(3,'退号登记','/register/move',1,'y','y','register:delete',NULL,'FindRegister'),(4,'挂号查询','/register/list',1,'y','y','register:select',NULL,'MoveRegister'),(5,'医生站','doctor/manager',NULL,'x','y','doctor:manager','el-icon-suitcase',NULL),(6,'病人查询','/patient/list',5,'y','y','doctor:select',NULL,NULL),(7,'部门管理','department/manager',NULL,'x','y','department:manager','el-icon-office-building',NULL),(8,'部门介绍','/department',7,'y','y','department:see',NULL,NULL),(9,'人员概览','/department/worker',7,'y','y','department:select',NULL,NULL),(10,'百草园','drug/manager',NULL,'x','y','drug:manager','el-icon-sugar',NULL),(11,'药品管理','/drug/manage',10,'y','y','drug:list',NULL,NULL),(12,'医嘱配药','/drug/config',10,'y','y','drug:add',NULL,NULL),(13,'财务部','finance/manager',NULL,'x','y','finance:manager','el-icon-coin',NULL),(14,'价目表管理','finance/price',13,'y','y','finance:price',NULL,NULL),(15,'药品价目表','/finance/drugList',14,'z','y','drug:price',NULL,NULL),(16,'手术项目记录','/finance/operationRecordList',14,'z','y','operation:record',NULL,NULL),(17,'检查项目记录','/finance/inspectHistory',14,'z','y','inspect:record',NULL,NULL),(18,'费用管理','salary/management',13,'y','y','salary:management',NULL,NULL),(19,'薪酬管理','/finance/salaryList',18,'z','y','salary:list',NULL,NULL),(20,'财务报表','financial/statements',13,'y','y','financial:statements',NULL,NULL),(21,'收支统计图','/finance/statements',20,'z','y','statistical:chart',NULL,NULL),(22,'技术部','technology/manager',NULL,'x','y','technology:manager','el-icon-scissors',NULL),(23,'检查项目','inspection/items',22,'y','y','inspection:items',NULL,NULL),(24,'检查项目管理','/inspect/manage',23,'z','y','inspection:project',NULL,NULL),(25,'检查申请处理','/finance/inspectList',23,'z','y','inspection:application',NULL,NULL),(26,'手术项目','operation/items',22,'y','y','operation:items',NULL,NULL),(27,'手术项目管理','/operation/manage',26,'z','y','operation:project',NULL,NULL),(28,'手术申请处理','/operation/operationRecord',26,'z','y','operation:application',NULL,NULL),(29,'住院部','inpatient/manager',NULL,'x','y','inpatient:manager','el-icon-school',NULL),(30,'住/出院手续办理','inpatient/procedures',29,'y','y','inpatient:procedures',NULL,NULL),(31,'住院办理','/hospitalization/hospitalizationprocedures',30,'z','y','inpatient:in',NULL,NULL),(32,'出院办理','/hospitalization/leavehospital',30,'z','y','inpatient:out',NULL,NULL),(33,'患者查看','inpatient/select',29,'y','y','inpatients:select',NULL,NULL),(34,'患者列表','/hospitalization/manage',33,'z','y','inpatients:in',NULL,NULL),(35,'查看出院患者','/hospitalization/DischargedPatients',33,'z','y','inpatient:out',NULL,NULL),(36,'固定资产管理','equipment/manager',NULL,'x','y','equipment:manager','el-icon-setting',NULL),(37,'医疗设备管理','medical/equipment',36,'y','y','medical:equipment',NULL,NULL),(38,'设备类型管理','/medicalequipment/administration',37,'z','y','medicalequipment:administration',NULL,NULL);

/*Table structure for table `ho_register_cost` */

DROP TABLE IF EXISTS `ho_register_cost`;

CREATE TABLE `ho_register_cost` (
  `rc_id` int NOT NULL AUTO_INCREMENT COMMENT '挂号费ID',
  `rc_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '挂号费-名称',
  `rc_money` decimal(10,0) NOT NULL COMMENT '挂号费用',
  PRIMARY KEY (`rc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_register_cost` */

insert  into `ho_register_cost`(`rc_id`,`rc_name`,`rc_money`) values (1,'普通号','10'),(2,'专家号','50');

/*Table structure for table `ho_register_type` */

DROP TABLE IF EXISTS `ho_register_type`;

CREATE TABLE `ho_register_type` (
  `rt_id` int NOT NULL AUTO_INCREMENT COMMENT '挂号类型ID',
  `rt_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '挂号类型名称',
  PRIMARY KEY (`rt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_register_type` */

insert  into `ho_register_type`(`rt_id`,`rt_name`) values (1,'门诊'),(2,'急诊'),(3,'住院');

/*Table structure for table `ho_require_drug` */

DROP TABLE IF EXISTS `ho_require_drug`;

CREATE TABLE `ho_require_drug` (
  `hrd_id` int NOT NULL AUTO_INCREMENT COMMENT '手术所需药物表',
  `d_id` int DEFAULT NULL COMMENT '药物id',
  `hoy_id` int DEFAULT NULL COMMENT '手术类型id',
  `hrd_status` varchar(2) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '配药状态',
  `w_id` int DEFAULT NULL COMMENT '当前登录人(配药人id)',
  PRIMARY KEY (`hrd_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_require_drug` */

/*Table structure for table `ho_role` */

DROP TABLE IF EXISTS `ho_role`;

CREATE TABLE `ho_role` (
  `r_id` int NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `r_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '角色名称',
  `rc_id` int DEFAULT NULL COMMENT '挂号等级',
  PRIMARY KEY (`r_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_role` */

insert  into `ho_role`(`r_id`,`r_name`,`rc_id`) values (1,'挂号员',0),(2,'专家',2),(3,'护士',0),(4,'院长',2),(5,'财务部主任',0),(6,'设备部员工',0),(7,'药剂师',0),(8,'科主任',2),(9,'普通医师',1),(10,'药剂科主任',0),(11,'设备部主任',0),(12,'财务部员工',0),(13,'技术部员工',0),(14,'技术部主任',0);

/*Table structure for table `ho_role_perms` */

DROP TABLE IF EXISTS `ho_role_perms`;

CREATE TABLE `ho_role_perms` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '角色-权限关系对应表id',
  `p_id` int DEFAULT NULL COMMENT '权限id',
  `r_id` int DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_role_perms` */

insert  into `ho_role_perms`(`id`,`p_id`,`r_id`) values (1,1,1),(2,2,1),(3,3,1),(4,4,1),(5,7,1),(6,8,1),(7,5,2),(8,6,2),(9,7,2),(10,8,2),(11,29,2),(12,33,2),(13,34,2),(14,29,1),(15,30,1),(16,31,1),(17,32,1),(18,5,3),(19,6,3),(20,7,3),(21,8,3),(22,29,3),(23,33,3),(25,34,3),(26,1,4),(27,2,4),(28,3,4),(29,4,4),(30,5,4),(31,6,4),(32,7,4),(33,8,4),(34,9,4),(35,10,4),(36,11,4),(37,12,4),(38,13,4),(39,14,4),(40,15,4),(41,16,4),(42,17,4),(43,18,4),(44,19,4),(45,20,4),(46,21,4),(47,22,4),(48,23,4),(49,24,4),(50,25,4),(51,26,4),(52,27,4),(53,28,4),(54,29,4),(55,30,4),(56,31,4),(57,32,4),(58,33,4),(59,34,4),(60,35,4),(61,36,4),(62,37,4),(64,7,5),(65,8,5),(66,9,5),(67,13,5),(68,14,5),(69,15,5),(70,16,5),(71,17,5),(72,18,5),(73,19,5),(74,20,5),(75,21,5),(76,36,5),(77,38,4),(78,37,5),(79,38,5),(80,7,6),(81,8,6),(82,36,6),(83,37,6),(84,38,6),(85,7,7),(86,8,7),(87,10,7),(88,11,7),(89,12,7),(90,5,8),(91,6,8),(92,7,8),(93,8,8),(94,9,8),(96,29,8),(97,33,8),(98,34,8),(99,35,8),(100,5,9),(101,6,9),(102,7,9),(103,8,9),(104,29,9),(105,33,9),(106,34,9),(107,7,10),(108,8,10),(109,9,10),(110,10,10),(111,11,10),(112,12,10),(113,7,11),(114,8,11),(115,36,11),(116,37,11),(117,38,11),(118,7,12),(119,8,12),(120,9,12),(121,13,12),(122,14,12),(123,15,12),(124,16,12),(125,17,12),(126,18,12),(127,19,12),(128,7,13),(129,8,13),(130,22,13),(131,23,13),(132,24,13),(133,25,13),(134,26,13),(135,27,13),(136,7,14),(137,8,14),(138,22,14),(139,23,14),(140,24,14),(141,25,14),(142,26,14),(143,27,14),(144,28,14);

/*Table structure for table `ho_treat_result` */

DROP TABLE IF EXISTS `ho_treat_result`;

CREATE TABLE `ho_treat_result` (
  `tr_id` int NOT NULL AUTO_INCREMENT COMMENT '就诊结果ID',
  `pt_id` int NOT NULL COMMENT '病人ID',
  `dpc_id` int NOT NULL COMMENT '所属科室ID',
  `w_id` int NOT NULL COMMENT '所属医师ID',
  `tr_complaint` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '病人主诉',
  `tr_temperature` double(10,2) DEFAULT NULL COMMENT '体温',
  `tr_pulse` int DEFAULT NULL COMMENT '脉搏',
  `tr_pressure` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '血压(70/100)',
  `tr_family_history` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '家属病史',
  `tr_result` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '诊断结果',
  `tr_opinion` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '医生建议',
  `tr_create_time` datetime NOT NULL COMMENT '就诊时间',
  PRIMARY KEY (`tr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_treat_result` */

insert  into `ho_treat_result`(`tr_id`,`pt_id`,`dpc_id`,`w_id`,`tr_complaint`,`tr_temperature`,`tr_pulse`,`tr_pressure`,`tr_family_history`,`tr_result`,`tr_opinion`,`tr_create_time`) values (1,1,1,2,'医生我快死了',NULL,NULL,NULL,NULL,'挺好的','多喝热水','2020-02-25 16:00:08'),(2,2,7,5,'医生救我',NULL,NULL,NULL,NULL,'好好活','多喝热水','2020-12-10 11:13:00'),(3,3,3,3,NULL,NULL,NULL,NULL,NULL,'加油','多喝热水','2020-12-15 23:05:37'),(4,4,5,4,NULL,NULL,NULL,NULL,NULL,'活下来','多喝热水','2021-01-01 17:07:44'),(5,5,3,3,NULL,NULL,NULL,NULL,NULL,'慢慢来','多喝热水','2021-01-02 19:08:37'),(6,3,3,3,'aa',12.00,21,'21','aa','aaa','aa','2021-03-12 21:50:10'),(7,3,3,3,'没有',35.00,45,'120','没有','还有机会','多吃菜','2021-03-13 10:20:56'),(8,3,3,3,'',NULL,NULL,NULL,'','','','2021-03-13 11:27:02'),(9,3,3,3,'',NULL,NULL,NULL,'','aaa','','2021-03-13 11:41:52'),(10,3,3,3,'',NULL,NULL,NULL,'','','','2021-03-13 11:48:21'),(11,3,3,3,'',NULL,NULL,NULL,'','快没了','','2021-03-13 13:39:44'),(12,3,3,3,'汉字',38.00,70,'90/100','糖尿病','准备后事吧','下辈子注意点','2021-03-15 16:04:50'),(13,3,3,3,'肚子疼',38.00,89,'90/120','没有','没事','没事','2021-03-15 16:06:40'),(14,3,3,3,'没得',12.00,123,'12','没得','很好','没得','2021-03-15 17:49:12'),(15,3,3,3,'',NULL,NULL,NULL,'','好好好','','2021-03-15 18:06:49'),(16,6,3,3,'没得',123.00,123,'123','没有','没得妹妹','快快快','2021-03-15 18:35:43'),(17,3,3,3,'波灵盖疼',25.00,25,'56','没有','炎症','多泡脚','2021-03-15 19:30:24'),(18,3,3,3,'没有',34.00,321,'321','没有','没有','没有','2021-03-15 19:32:48'),(19,3,3,3,'没有',23.00,133,'132','没有','没有','没有','2021-03-15 19:38:07'),(20,6,3,3,'大出血',23.00,23,'23','没有','立即抢救','b型血浆','2021-03-15 19:39:39'),(21,12,3,3,'不来大姨妈',26.00,80,'60','没有','绝经','多喝开水','2021-03-15 19:40:38'),(22,15,3,3,'想要变性',26.00,69,'70','没有','可以变性','切了','2021-03-15 21:28:02'),(23,30,5,4,'66666',66.00,666,'666','666','66666','6666','2021-03-16 17:02:44'),(24,31,5,4,'666',666.00,666,'666','666','666','666','2021-03-16 17:05:34'),(25,31,5,4,'342534',3453.00,452435,'32452345','345234','3245234','3245','2021-03-17 11:08:35'),(26,3,3,3,'没有没有',35.60,234,'2432','没有','没有','没有','2021-03-17 11:30:05'),(27,3,3,3,'没有',34.50,43,'65','没有','眼红','注意休息','2021-03-17 14:31:22'),(28,19,1,12,'',NULL,777,'','','7777','555','2021-03-17 17:48:30'),(29,3,3,3,'手疼疼....',34.50,23,'23','没有','断手','可以加上','2021-03-17 18:28:37'),(30,3,3,3,'建议多吃粗粮',34.50,45,'45','没有','消化不良','多吃蔬菜','2021-03-17 19:31:11'),(31,3,3,3,'静养',35.60,34,'34','没有','骨裂','多喝骨头汤','2021-03-17 20:18:12'),(32,3,3,3,'不太想去啊',35.60,23,'35/34','无家族史','烟瘾重度','去戒烟所','2021-03-18 10:03:02'),(33,33,3,3,'全身酸痛',35.60,34,'34/34','无家族史','全身疼','吃点止疼片','2021-03-18 10:35:24'),(34,33,3,3,'多切几次',34.50,67,'45/56','没有家族史','人体无用副组织过多','切除','2021-03-18 10:56:20'),(35,29,3,3,'没有',36.50,45,'56/45','没有','测试','没有','2021-03-18 11:04:57'),(36,32,3,3,'没有',36.70,40,'34/45','没有','测试','没有','2021-03-18 11:07:16'),(37,32,3,3,'想要修养',36.50,46,'34/56','没有','手疼','少剧烈运动','2021-03-18 11:30:27'),(38,33,3,3,'好痛',36.50,35,'34/34','没有','腰疼','多运动','2021-03-18 11:33:47'),(39,25,1,12,'想要有人类的一条腿',35.60,34,'45/45','妈妈是人鱼','有鱼尾','切尾手术','2021-03-18 12:18:07'),(40,37,1,12,'6666666',36.50,70,'90','6666','66','66666','2021-03-18 12:21:15'),(41,37,1,12,'没啥大事',36.50,80,'80','无病史','没事','多喝开水','2021-03-18 12:28:52'),(42,25,1,12,'没事',36.50,80,'80','无病史','没事','没事','2021-03-18 18:12:58'),(43,38,46,12,'55',43.00,52,'55','55','55','55','2021-03-19 09:43:43'),(44,39,13,12,'头晕',37.50,80,'70/100','无家族史','住院几天就好','没啥大事','2021-03-19 10:15:18'),(45,26,3,3,'好虚弱,好热',39.60,46,'64/80','没有家族史','发烧','多喝水,多吃水果','2021-03-19 10:23:03'),(46,3,3,3,'想吃火锅\n',35.60,34,'56/78','没有家族史','嗓子疼','多喝水','2021-03-19 10:36:15'),(47,45,13,12,'没事',38.60,90,'80/120','无历史记录','有点严重','没事','2021-03-19 11:26:35'),(48,44,13,12,'没啥大事',36.50,90,'90','无家族史','休息几天就好','没啥大事','2021-03-19 11:36:25'),(49,43,13,12,'没啥大事',37.50,90,'90','无家族史','没啥大事','没啥大事','2021-03-19 12:08:21');

/*Table structure for table `ho_treat_status` */

DROP TABLE IF EXISTS `ho_treat_status`;

CREATE TABLE `ho_treat_status` (
  `ts_id` int NOT NULL AUTO_INCREMENT COMMENT '就诊状态ID',
  `ts_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '就诊状态名称',
  PRIMARY KEY (`ts_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_treat_status` */

insert  into `ho_treat_status`(`ts_id`,`ts_name`) values (1,'初诊'),(2,'复诊'),(3,'出诊');

/*Table structure for table `ho_use_drug` */

DROP TABLE IF EXISTS `ho_use_drug`;

CREATE TABLE `ho_use_drug` (
  `hud_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pt_card` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '患者编号',
  `w_id` int NOT NULL COMMENT '对应医生id',
  `d_id` int NOT NULL COMMENT '对应药品id',
  `d_num` int NOT NULL COMMENT '对应药品数量',
  `hud_create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`hud_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_use_drug` */

insert  into `ho_use_drug`(`hud_id`,`pt_card`,`w_id`,`d_id`,`d_num`,`hud_create_time`) values (1,'1615771298633',7,1,1,'2021-03-16 18:15:31'),(2,'1615771298633',7,2,2,'2021-03-16 18:15:31'),(3,'1615771298633',7,1,1,'2021-03-16 18:16:55'),(4,'1615771298633',7,2,1,'2021-03-16 20:06:49'),(5,'1615771298633',7,26,7,'2021-03-16 20:14:57'),(6,'1615771298633',7,4,1,'2021-03-16 20:48:49'),(7,'1615771298633',7,5,6,'2021-03-16 20:49:04'),(8,'1615771298633',7,7,2,'2021-03-16 20:49:04'),(9,'1615771298633',7,7,12,'2021-03-16 21:02:23'),(10,'1615771298633',7,25,5,'2021-03-16 21:02:23'),(11,'1616120069963',12,4,3,'2021-03-19 11:08:15'),(12,'1616122991282',12,6,4,'2021-03-19 11:27:50');

/*Table structure for table `ho_workers` */

DROP TABLE IF EXISTS `ho_workers`;

CREATE TABLE `ho_workers` (
  `w_id` int NOT NULL AUTO_INCREMENT COMMENT '员工ID',
  `w_account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '员工账号',
  `w_password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '员工密码',
  `w_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '员工编号',
  `dp_id` int NOT NULL COMMENT '所属部门ID',
  `dpc_id` int NOT NULL COMMENT '所属科室ID',
  `r_id` int NOT NULL COMMENT '角色ID',
  `w_age` int NOT NULL COMMENT '员工年龄',
  `w_gender` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '员工性别',
  `w_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '员工姓名',
  `w_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '员工电话',
  `w_email` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '员工邮箱',
  `w_salary` decimal(10,2) NOT NULL COMMENT '员工薪资',
  `w_salt` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '盐',
  `w_status` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '员工状态',
  PRIMARY KEY (`w_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_workers` */

insert  into `ho_workers`(`w_id`,`w_account`,`w_password`,`w_card`,`dp_id`,`dpc_id`,`r_id`,`w_age`,`w_gender`,`w_name`,`w_phone`,`w_email`,`w_salary`,`w_salt`,`w_status`) values (1,'admin','4e67cc251d046e943dca62e264b7d41b','GLY001',0,0,0,0,'男','admin','15200000000','admin@163.com','0.00','aaa','y'),(2,'wangys','4e67cc251d046e943dca62e264b7d41b','YS001',1,1,9,25,'男','王医师','15012314564','wangys@163.com','6000.00','aaa','y'),(3,'liys','4e67cc251d046e943dca62e264b7d41b','YS002',1,3,9,30,'女','李医师','15000000000','li@163.com','8000.00','aaa','y'),(4,'zhangys','4e67cc251d046e943dca62e264b7d41b','YS003',1,5,9,35,'男','张医师','14900000000','zhang@163.com','7000.00','aaa','y'),(5,'zhaoys','4e67cc251d046e943dca62e264b7d41b','YS004',1,7,9,40,'男','赵医师','14800000000','zhao@163.com','9000.00','aaa','y'),(6,'hs01','4e67cc251d046e943dca62e264b7d41b','HS001',2,13,5,22,'女','赵ge','14700000000','ad@163.com','3888.00','aaa','n'),(7,'yz01','4e67cc251d046e943dca62e264b7d41b','YZ001',1,5,4,45,'女','吴院长','14600000000','sd@163.com','20000.00','aaa','y'),(12,'fudong','d0eaaf86f8b08138ff6ae707ca50eeac','YS89427052',1,13,4,25,'男','傅院长','15071317777','123456@qq.com','50000.50','aaa','y'),(13,'dacongming','4598b75e7974c338282696e5b51c503b','HXYY67973270',1,1,9,25,'男','大聪明','15071317705','qwe@qq.com','5000.00','aaa','s'),(14,'xiaozhang','29100f5d40e0ddc3c37ba0ce4018f5ef','HXYY41956065',1,61,1,25,'女','小张','15077778888','123@qq.com','8000.00','aaa','y'),(15,'hushijiejie','1a08a19dc660f08c18f5763953ec3d1f','HXYY53623377',2,46,3,21,'女','护士小姐姐','13977778888','234@qq.com','7000.00','aaa','y'),(16,'xiaoli','2f6fc1e89d848c06438140aaa19305a9','HXYY40217776',2,61,6,28,'男','设备部小李','13988889999','345@qq.com','9000.00','aaa','y'),(17,'xiaosong','f6eb791fc0c31b1218c293df7cb4d7ae','HXYY29410793',3,41,7,29,'男','药剂师小宋','13599996666','456@qq.com','8000.00','aaa','y'),(18,'laoli','50e016a3fe642504548ea81f6c0a0101','HXYY10122255',1,5,8,56,'男','内分泌科主任','15899993333','567@qq.com','20000.00','aaa','y'),(19,'laozhao','2c244cdd6fc6b5ed4c0451163901c7e1','HXYY13075493',1,5,8,45,'女','骨科科主任','13695483218','678@qq.com','15000.00','aaa','y'),(20,'huda','e979da4374e5601af99e240ade9b386c','HXYY10687896',3,41,10,40,'男','药剂科主任','15063256985','789@qq.com','21000.00','aaa','y'),(21,'pengheng','f340e1e71333da28a0af130de56979ac','HXYY64050783',2,61,11,20,'男','彭恒','16599887456','45234@qq.com','40000.00','aaa','y'),(22,'yanganli','667bcd2b998b712d9bb1ca6f05b43912','HXYY12564301',4,61,5,26,'男','海文樱','13566968564','43123@qq.com','40000.00','aaa','y'),(23,'maiwenxi','1c53fd4b1ff41d090ff5cc0529a1e9b1','HXYY33236580',3,41,10,29,'男','Checkio','13658961258','wcx6829@163.com','45000.00','aaa','y'),(24,'qianqian','db00dfb720147a04b634a388db612130','HXYY52330264',4,61,12,20,'女','小钱钱','13069852356','73546@qq.com','10000.00','aaa','y'),(25,'maiwenxi2','6764210b4687137df29be5ac0e218f8e','HXYY12593727',2,35,14,20,'男','Checkio','13696215635','2342345@qq.com','40000.00','aaa','y'),(26,'panghu','d1f85342c7f9c9d4905edc9067b81e57','HXYY27796432',2,35,13,16,'男','胖虎','15798563652','42365433@qq.com','15000.00','aaa','y');

/*Table structure for table `ho_workers_pay` */

DROP TABLE IF EXISTS `ho_workers_pay`;

CREATE TABLE `ho_workers_pay` (
  `wp_id` int NOT NULL AUTO_INCREMENT COMMENT '发薪记录ID',
  `w_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '员工编号',
  `w_name` varchar(10) COLLATE utf8mb4_bin NOT NULL COMMENT '员工姓名',
  `wp_salary` decimal(10,2) NOT NULL COMMENT '发薪数量',
  `wp_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '发薪类型',
  `wp_time` datetime NOT NULL COMMENT '发薪时间',
  `wp_describe` text COLLATE utf8mb4_bin COMMENT '用途备注(离职,月薪,奖金...)',
  PRIMARY KEY (`wp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

/*Data for the table `ho_workers_pay` */

insert  into `ho_workers_pay`(`wp_id`,`w_card`,`w_name`,`wp_salary`,`wp_type`,`wp_time`,`wp_describe`) values (6,'YS89427052','fudong','2000.20','月结','2021-03-15 15:29:38','月薪'),(7,'afdasfd','ssssss','1562.00','sdfasd','2021-03-15 22:02:51','sdfasdfdas'),(8,'ssssss','ddddd','5000.50','sssss','2021-03-10 22:03:31','ssssss'),(9,'fgsdfg','fsad','95155.00','ssss','2021-03-02 22:04:22','fgsgs'),(10,'YS89427052','fudong','4800.00','月结','2021-03-17 19:24:24','月薪'),(11,'HS001','赵ge','5000.20','离职','2021-03-18 19:04:37','离职'),(12,'HXYY12564301','海文樱','1000.20','其它','2021-03-19 10:33:51','简单发个奖金'),(13,'HXYY64050783','彭恒','100.20','离职','2021-03-19 12:07:37','离职');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;