JavaEE+医院管理系统免费下载!

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50527 Source Host : localhost:3306 Source Database : hospital Target Server Type : MYSQL Target Server Version : 50527 File Encoding : 65001 Date: 2021-04-04 16:58:40 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for bu_dept -- ---------------------------- DROP TABLE IF EXISTS `bu_dept`; CREATE TABLE `bu_dept` ( `department_id` int(11) NOT NULL AUTO_INCREMENT, `department` varchar(300) NOT NULL, PRIMARY KEY (`department_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='科室表'; -- ---------------------------- -- Records of bu_dept -- ---------------------------- INSERT INTO `bu_dept` VALUES ('7', '普通内科'); INSERT INTO `bu_dept` VALUES ('8', '普通外科'); INSERT INTO `bu_dept` VALUES ('11', '男科'); INSERT INTO `bu_dept` VALUES ('13', '急诊科'); INSERT INTO `bu_dept` VALUES ('15', '呼吸科'); -- ---------------------------- -- Table structure for bu_doctor -- ---------------------------- DROP TABLE IF EXISTS `bu_doctor`; CREATE TABLE `bu_doctor` ( `doctor_id` int(11) NOT NULL AUTO_INCREMENT, `doctor_name` varchar(300) NOT NULL, `department_id` int(11) NOT NULL, `registered_id` int(11) NOT NULL, `dstate` int(11) DEFAULT NULL, `am_Start_Time` varchar(10) DEFAULT '8:00', `am_End_Time` varchar(10) DEFAULT '12:00', `pm_Start_Time` varchar(10) DEFAULT '14:00', `pm_End_Time` varchar(10) DEFAULT '18:00', PRIMARY KEY (`doctor_id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='医生表'; -- ---------------------------- -- Records of bu_doctor -- ---------------------------- INSERT INTO `bu_doctor` VALUES ('13', '华佗', '7', '5', '0', '8:00', '12:00', '14:00', '18:00'); INSERT INTO `bu_doctor` VALUES ('14', '扁鹊', '7', '6', '1', '8:00', '12:00', '14:00', '18:00'); INSERT INTO `bu_doctor` VALUES ('15', '明世隐', '7', '5', '1', '8:00', '12:00', '14:00', '18:00'); INSERT INTO `bu_doctor` VALUES ('16', '蔡文姬', '8', '6', '1', '8:00', '12:00', '14:00', '18:00'); INSERT INTO `bu_doctor` VALUES ('17', '李时珍', '11', '5', '1', '8:00', '12:00', '14:00', '18:00'); INSERT INTO `bu_doctor` VALUES ('18', '孙思邈', '11', '6', '0', '8:00', '12:00', '14:00', '18:00'); INSERT INTO `bu_doctor` VALUES ('19', '宋慈', '13', '6', '0', '8:00', '12:00', '14:00', '18:00'); INSERT INTO `bu_doctor` VALUES ('20', '钟南山', '15', '6', '1', '8:00', '12:00', '14:00', '18:00'); INSERT INTO `bu_doctor` VALUES ('21', '张文宏', '15', '5', '0', '8:00', '12:00', '14:00', '18:00'); -- ---------------------------- -- Table structure for bu_paiban -- ---------------------------- DROP TABLE IF EXISTS `bu_paiban`; CREATE TABLE `bu_paiban` ( `id` int(11) NOT NULL AUTO_INCREMENT, `one` varchar(50) DEFAULT '无班', `two` varchar(50) DEFAULT '无班', `three` varchar(50) DEFAULT '无班', `four` varchar(50) DEFAULT '无班', `five` varchar(50) DEFAULT '无班', `six` varchar(50) DEFAULT '无班', `seven` varchar(50) DEFAULT '无班', `doctor_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='排班表'; -- ---------------------------- -- Records of bu_paiban -- ---------------------------- INSERT INTO `bu_paiban` VALUES ('12', '有班', '有班', '有班', '有班', '有班', '有班', '有班', '16'); INSERT INTO `bu_paiban` VALUES ('13', '有班', '有班', '有班', '有班', '有班', '有班', '有班', '15'); INSERT INTO `bu_paiban` VALUES ('14', '有班', '有班', '有班', '有班', '有班', '有班', '有班', '14'); INSERT INTO `bu_paiban` VALUES ('15', '有班', '有班', '有班', '无班', '有班', '有班', '有班', '13'); INSERT INTO `bu_paiban` VALUES ('16', '无班', '有班', '无班', '有班', '无班', '有班', '无班', '17'); INSERT INTO `bu_paiban` VALUES ('17', '有班', '无班', '有班', '无班', '无班', '无班', '有班', '18'); INSERT INTO `bu_paiban` VALUES ('18', '有班', '无班', '有班', '无班', '有班', '无班', '无班', '19'); INSERT INTO `bu_paiban` VALUES ('19', '有班', '无班', '有班', '无班', '有班', '无班', '无班', '20'); INSERT INTO `bu_paiban` VALUES ('20', '无班', '有班', '无班', '有班', '无班', '有班', '无班', '21'); -- ---------------------------- -- Table structure for bu_pharmacy -- ---------------------------- DROP TABLE IF EXISTS `bu_pharmacy`; CREATE TABLE `bu_pharmacy` ( `pharmacy_Id` int(11) NOT NULL AUTO_INCREMENT, `pharmacy_name` varchar(50) NOT NULL, `unit_id` int(11) NOT NULL, `selling_price` double NOT NULL, `c_id` int(11) NOT NULL COMMENT '药品生产公司编号', `type` int(11) NOT NULL, `produceDate` date NOT NULL, `validDate` date NOT NULL, `drugstore_num` int(11) NOT NULL, `skullbatch` varchar(200) NOT NULL, PRIMARY KEY (`pharmacy_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='处方表'; -- ---------------------------- -- Records of bu_pharmacy -- ---------------------------- INSERT INTO `bu_pharmacy` VALUES ('11', '板蓝根', '7', '30', '4', '5', '2020-12-01', '2024-12-04', '1000', '20191121'); INSERT INTO `bu_pharmacy` VALUES ('12', '阿莫西林', '7', '30', '4', '5', '2020-12-25', '2026-12-01', '900', '20191121'); INSERT INTO `bu_pharmacy` VALUES ('13', '生命之泉', '9', '998', '4', '5', '2020-12-30', '2028-12-30', '900', '20201230'); INSERT INTO `bu_pharmacy` VALUES ('14', '万年雪霜', '9', '998', '4', '5', '2020-12-30', '2027-12-30', '900', '20201230'); INSERT INTO `bu_pharmacy` VALUES ('15', '大瓶金疮药', '9', '89', '4', '5', '2020-12-30', '2027-12-30', '900', '20201230'); INSERT INTO `bu_pharmacy` VALUES ('16', '开塞露', '7', '10', '4', '5', '2020-12-30', '2026-12-30', '900', '20201230'); INSERT INTO `bu_pharmacy` VALUES ('17', '六味地黄丸', '7', '35', '4', '5', '2020-12-30', '2028-12-30', '100', '20201230'); -- ---------------------------- -- Table structure for bu_register -- ---------------------------- DROP TABLE IF EXISTS `bu_register`; CREATE TABLE `bu_register` ( `register_id` int(11) NOT NULL AUTO_INCREMENT, `register_name` varchar(100) DEFAULT NULL, `sex` varchar(10) DEFAULT NULL, `age` int(11) DEFAULT NULL, `department_id` int(11) DEFAULT NULL, `doctor_id` int(11) DEFAULT NULL, `register_type_id` int(11) DEFAULT NULL, `price` double DEFAULT NULL, `time` datetime DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `state` int(11) DEFAULT NULL, `phone` varchar(100) NOT NULL, `carid` varchar(100) NOT NULL, `zhuan` varchar(500) DEFAULT NULL, PRIMARY KEY (`register_id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='挂号信息表'; -- ---------------------------- -- Records of bu_register -- ---------------------------- INSERT INTO `bu_register` VALUES ('32', 'zhangsan', '男', '90', '7', '13', '5', '20', '2021-02-03 17:17:17', '1', '4', '18192133232', '213132432423131', '病情加重'); INSERT INTO `bu_register` VALUES ('33', 'lisi', '男', '11', '7', '13', '5', '20', '2021-02-03 08:21:26', '1', '2', '12112212112', '212212121213232', '感冒'); INSERT INTO `bu_register` VALUES ('34', '青龙', '男', '43', '7', '14', '6', '30', '2021-04-01 10:22:12', '1', '2', '13844547804', '218787459785157854', '脑子有病'); INSERT INTO `bu_register` VALUES ('35', '白虎', '女', '99', '15', '20', '6', '30', '2021-03-29 17:10:41', '1', '1', '18710101010', '110454741235789874', null); INSERT INTO `bu_register` VALUES ('36', '朱雀', '女', '87', '15', '20', '6', '30', '2021-03-29 17:11:23', '1', '1', '18755987456', '110245789412587896', null); -- ---------------------------- -- Table structure for bu_registered_type -- ---------------------------- DROP TABLE IF EXISTS `bu_registered_typ