/*
SQLyog Ultimate v11.27 (32 bit)
MySQL - 5.6.24 : Database - clinicalmanagement
*********************************************************************
*/

/*!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*/`clinicalmanagement` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `clinicalmanagement`;

/*Table structure for table `docs_eval_report_detail` */

DROP TABLE IF EXISTS `docs_eval_report_detail`;

CREATE TABLE `docs_eval_report_detail` (
  `rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `creator_unit` varchar(255) DEFAULT NULL,
  `enable_value` varchar(255) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_value` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `updater` varchar(255) DEFAULT NULL,
  `updater_unit` varchar(255) DEFAULT NULL,
  `report_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`rec_id`),
  KEY `FKbdlnglkkld39ufxj924j6173n` (`report_id`),
  CONSTRAINT `FKbdlnglkkld39ufxj924j6173n` FOREIGN KEY (`report_id`) REFERENCES `docs_eval_report_rec` (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `docs_eval_report_detail` */

/*Table structure for table `docs_eval_report_rec` */

DROP TABLE IF EXISTS `docs_eval_report_rec`;

CREATE TABLE `docs_eval_report_rec` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `creator_unit` varchar(255) DEFAULT NULL,
  `enable_value` varchar(255) DEFAULT NULL,
  `patient_id` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `report_date` date DEFAULT NULL,
  `theme_code` varchar(255) DEFAULT NULL,
  `time_point` datetime DEFAULT NULL,
  `visit_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `docs_eval_report_rec` */

/*Table structure for table `docs_normal_report_detail` */

DROP TABLE IF EXISTS `docs_normal_report_detail`;

CREATE TABLE `docs_normal_report_detail` (
  `rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `creator_unit` varchar(255) DEFAULT NULL,
  `enable_value` varchar(255) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_value` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `updater` varchar(255) DEFAULT NULL,
  `updater_unit` varchar(255) DEFAULT NULL,
  `report_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`rec_id`),
  KEY `FKt2n6jpytkrj1k7ar9q7fi75lt` (`report_id`),
  CONSTRAINT `FKt2n6jpytkrj1k7ar9q7fi75lt` FOREIGN KEY (`report_id`) REFERENCES `docs_normal_report_rec` (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `docs_normal_report_detail` */

/*Table structure for table `docs_normal_report_rec` */

DROP TABLE IF EXISTS `docs_normal_report_rec`;

CREATE TABLE `docs_normal_report_rec` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `creator_unit` varchar(255) DEFAULT NULL,
  `enable_value` varchar(255) DEFAULT NULL,
  `patient_id` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `report_date` date DEFAULT NULL,
  `theme_code` varchar(255) DEFAULT NULL,
  `time_point` datetime DEFAULT NULL,
  `visit_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `docs_normal_report_rec` */

/*Table structure for table `docs_report_detail` */

DROP TABLE IF EXISTS `docs_report_detail`;

CREATE TABLE `docs_report_detail` (
  `rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `creator_unit` varchar(255) DEFAULT NULL,
  `enable_value` varchar(255) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_value` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `updater` varchar(255) DEFAULT NULL,
  `updater_unit` varchar(255) DEFAULT NULL,
  `report_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`rec_id`),
  KEY `FKqkxtujqsxmniigntumlvho44g` (`report_id`),
  CONSTRAINT `FKqkxtujqsxmniigntumlvho44g` FOREIGN KEY (`report_id`) REFERENCES `docs_report_rec` (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `docs_report_detail` */

/*Table structure for table `docs_report_rec` */

DROP TABLE IF EXISTS `docs_report_rec`;

CREATE TABLE `docs_report_rec` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `creator_unit` varchar(255) DEFAULT NULL,
  `enable_value` varchar(255) DEFAULT NULL,
  `patient_id` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `report_date` date DEFAULT NULL,
  `theme_code` varchar(255) DEFAULT NULL,
  `time_point` datetime DEFAULT NULL,
  `visit_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `docs_report_rec` */

/*Table structure for table `docs_risk_report_detail` */

DROP TABLE IF EXISTS `docs_risk_report_detail`;

CREATE TABLE `docs_risk_report_detail` (
  `rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `creator_unit` varchar(255) DEFAULT NULL,
  `enable_value` varchar(255) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_value` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `updater` varchar(255) DEFAULT NULL,
  `updater_unit` varchar(255) DEFAULT NULL,
  `report_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`rec_id`),
  KEY `FKjirukots9a04nbjkpyo1jsjsi` (`report_id`),
  CONSTRAINT `FKjirukots9a04nbjkpyo1jsjsi` FOREIGN KEY (`report_id`) REFERENCES `docs_risk_report_rec` (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `docs_risk_report_detail` */

/*Table structure for table `docs_risk_report_rec` */

DROP TABLE IF EXISTS `docs_risk_report_rec`;

CREATE TABLE `docs_risk_report_rec` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `creator_unit` varchar(255) DEFAULT NULL,
  `enable_value` varchar(255) DEFAULT NULL,
  `patient_id` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `report_date` date DEFAULT NULL,
  `theme_code` varchar(255) DEFAULT NULL,
  `time_point` datetime DEFAULT NULL,
  `visit_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `docs_risk_report_rec` */

/*Table structure for table `his_pat_in_hospital` */

DROP TABLE IF EXISTS `his_pat_in_hospital`;

CREATE TABLE `his_pat_in_hospital` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adm_dept_time` datetime DEFAULT NULL,
  `admission_time` datetime DEFAULT NULL,
  `bed_label` varchar(255) DEFAULT NULL,
  `bed_no` int(11) DEFAULT NULL,
  `dept_code` varchar(255) DEFAULT NULL,
  `dept_name` varchar(255) DEFAULT NULL,
  `doctor_id` varchar(255) DEFAULT NULL,
  `doctor_name` varchar(255) DEFAULT NULL,
  `inp_no` varchar(255) DEFAULT NULL,
  `nurse_class` varchar(255) DEFAULT NULL,
  `nurse_id` varchar(255) DEFAULT NULL,
  `nurse_name` varchar(255) DEFAULT NULL,
  `patient_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `visit_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `his_pat_in_hospital` */

insert  into `his_pat_in_hospital`(`id`,`adm_dept_time`,`admission_time`,`bed_label`,`bed_no`,`dept_code`,`dept_name`,`doctor_id`,`doctor_name`,`inp_no`,`nurse_class`,`nurse_id`,`nurse_name`,`patient_id`,`status`,`visit_id`) values (1,'2018-05-06 16:03:13','2018-05-06 16:03:18','001',1,'1001','神经内科一病区',NULL,NULL,'345231','1',NULL,NULL,'345231','2','1'),(2,'2018-05-06 16:03:13','2018-05-06 16:03:18','002',2,'1001','神经内科一病区',NULL,NULL,'345232','3',NULL,NULL,'345232','2','1'),(3,'2018-05-06 16:03:13','2018-05-06 16:03:18','003',3,'1001','神经内科一病区',NULL,NULL,'345233','2',NULL,NULL,'345233','1','1'),(4,'2018-05-06 16:03:13','2018-05-06 16:03:18','001',1,'1002','神经内科二病区',NULL,NULL,'345234','2',NULL,NULL,'345234','3','1');

/*Table structure for table `his_pat_master_info` */

DROP TABLE IF EXISTS `his_pat_master_info`;

CREATE TABLE `his_pat_master_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `patient_id` varchar(255) DEFAULT NULL,
  `patient_name` varchar(255) DEFAULT NULL,
  `patient_sex` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `his_pat_master_info` */

insert  into `his_pat_master_info`(`id`,`address`,`birth_date`,`patient_id`,`patient_name`,`patient_sex`,`phone`) values (1,'广东省广州市海珠区','1989-07-14','345231','张安','女','027-123456'),(2,'广东省广州市海珠区','1979-07-14','345232','王望海','男','027-123456'),(3,'广东省广州市海珠区','1979-10-24','345233','张海萍','女','027-123456'),(4,'广东省广州市海珠区','1979-10-24','345234','朱涛','男','027-123456');

/*Table structure for table `his_pat_no_in_hospital` */

DROP TABLE IF EXISTS `his_pat_no_in_hospital`;

CREATE TABLE `his_pat_no_in_hospital` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adm_dept_time` datetime DEFAULT NULL,
  `admission_time` datetime DEFAULT NULL,
  `bed_label` varchar(255) DEFAULT NULL,
  `bed_no` int(11) DEFAULT NULL,
  `dept_code` varchar(255) DEFAULT NULL,
  `dept_name` varchar(255) DEFAULT NULL,
  `doctor_id` varchar(255) DEFAULT NULL,
  `doctor_name` varchar(255) DEFAULT NULL,
  `inp_no` varchar(255) DEFAULT NULL,
  `level_time` datetime DEFAULT NULL,
  `nurse_class` varchar(255) DEFAULT NULL,
  `nurse_id` varchar(255) DEFAULT NULL,
  `nurse_name` varchar(255) DEFAULT NULL,
  `patient_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `visit_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `his_pat_no_in_hospital` */

/*Table structure for table `sys_depts` */

DROP TABLE IF EXISTS `sys_depts`;

CREATE TABLE `sys_depts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` int(11) DEFAULT NULL,
  `dept_code` varchar(255) DEFAULT NULL,
  `dept_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

/*Data for the table `sys_depts` */

insert  into `sys_depts`(`id`,`active`,`dept_code`,`dept_name`) values (1,1,'1001','神经内科一病区'),(2,1,'1002','神经内科二病区'),(3,1,'1003','神经内科三病区'),(5,1,'2001','骨外一科'),(6,1,'2002','骨外二科'),(7,1,'2003','骨外三科');

/*Table structure for table `sys_operations` */

DROP TABLE IF EXISTS `sys_operations`;

CREATE TABLE `sys_operations` (
  `operation_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `dept_show` int(11) DEFAULT NULL,
  `operation_name` varchar(255) DEFAULT NULL,
  `operation_url` varchar(255) DEFAULT NULL,
  `p_operation_id` int(11) DEFAULT NULL,
  `pat_show` int(11) DEFAULT NULL,
  `sort_index` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `updater` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`operation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

/*Data for the table `sys_operations` */

insert  into `sys_operations`(`operation_id`,`active`,`create_time`,`creator`,`dept_show`,`operation_name`,`operation_url`,`p_operation_id`,`pat_show`,`sort_index`,`update_time`,`updater`) values (1,1,'2018-04-21 11:19:16','admin',NULL,'系统管理',NULL,-1,NULL,0,NULL,NULL),(2,1,'2018-04-21 11:19:52','admin',0,'用户设置','pages/admin/user/user-list',1,0,1,'2018-05-06 21:36:51',NULL),(3,1,'2018-04-21 11:19:52','admin',0,'角色设置','pages/admin/role/role-list',1,0,2,'2018-05-06 21:37:18',NULL),(4,1,'2018-04-21 11:19:52','admin',0,'菜单设置','pages/admin/operation/operation-list',1,0,3,'2018-05-06 21:37:22',NULL),(5,1,'2018-04-21 11:19:52','admin',NULL,'病区管理',NULL,-1,NULL,100,NULL,NULL),(6,1,'2018-04-21 11:19:52','admin',1,'交班报告','',5,0,101,'2018-05-06 21:39:27',NULL),(7,1,'2018-04-21 11:19:52','admin',1,'病人出院信息查询','',5,0,102,'2018-05-06 21:39:23',NULL),(8,1,'2018-04-21 11:19:52','admin',NULL,'体征管理',NULL,-1,NULL,1000,NULL,NULL),(9,1,'2018-04-21 11:19:52','admin',1,'体温单','',8,1,1001,'2018-05-06 21:38:22',NULL),(10,1,'2018-04-21 11:19:52','admin',1,'全科体征','',8,0,1002,'2018-05-06 21:39:09',NULL),(14,1,'2018-04-27 15:21:19','admin',0,'科室设置','pages/admin/dept/dept-list',1,0,4,'2018-05-06 21:37:31',NULL),(15,1,'2018-06-13 16:04:42','admin',NULL,'记录管理',NULL,-1,NULL,2000,NULL,NULL),(16,1,'2018-06-13 16:10:48','admin',1,'一般科室入院评估单','pages/records/AdmissionRecords/index',15,1,1,NULL,NULL),(17,1,'2018-06-13 16:11:24','admin',1,'压疮评估单','',15,1,2,NULL,NULL),(18,1,'2018-06-13 16:11:48','admin',1,'护理记录单','pages/records/BaseRecord',15,1,5,'2018-06-13 16:35:20',NULL),(19,1,'2018-06-13 16:14:39','admin',1,'非手术护理记录单','',15,1,6,NULL,NULL);

/*Table structure for table `sys_role_vs_operation` */

DROP TABLE IF EXISTS `sys_role_vs_operation`;

CREATE TABLE `sys_role_vs_operation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operation_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

/*Data for the table `sys_role_vs_operation` */

insert  into `sys_role_vs_operation`(`id`,`operation_id`,`role_id`) values (1,6,1),(2,7,1),(3,9,1),(4,10,1),(5,2,2),(6,6,2),(7,7,2),(8,9,2),(9,10,2),(10,2,6),(11,3,6),(12,4,6),(13,14,6),(14,6,6),(15,7,6),(16,9,6),(17,10,6),(18,2,3),(19,3,3),(20,6,3),(21,7,3),(22,9,3),(23,10,3),(24,16,1),(25,17,1),(26,18,1),(27,19,1),(28,16,2),(29,17,2),(30,18,2),(31,19,2),(32,16,3),(33,17,3),(34,18,3),(35,19,3),(36,16,6),(37,17,6),(38,18,6),(39,19,6);

/*Table structure for table `sys_roles` */

DROP TABLE IF EXISTS `sys_roles`;

CREATE TABLE `sys_roles` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` int(11) DEFAULT NULL,
  `role_desc` varchar(255) DEFAULT NULL,
  `role_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*Data for the table `sys_roles` */

insert  into `sys_roles`(`role_id`,`active`,`role_desc`,`role_name`) values (1,1,'临床护士','护士'),(2,1,'临床科室护士长','护士长'),(3,1,'每个专科的大护士长','专科护士长'),(4,1,'譬如：内科、外科、门诊等','大科护士长'),(5,1,'护理最高管理层','护理部'),(6,1,'系统最高权限','管理员');

/*Table structure for table `sys_user_vs_dept` */

DROP TABLE IF EXISTS `sys_user_vs_dept`;

CREATE TABLE `sys_user_vs_dept` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_code` varchar(255) DEFAULT NULL,
  `login_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

/*Data for the table `sys_user_vs_dept` */

insert  into `sys_user_vs_dept`(`id`,`dept_code`,`login_name`) values (1,'1001','1001'),(2,'1002','1001'),(3,'1003','1001'),(4,'1001','admin'),(5,'1002','admin'),(6,'1003','admin'),(7,'2001','admin'),(8,'2002','admin'),(9,'2003','admin');

/*Table structure for table `sys_user_vs_role` */

DROP TABLE IF EXISTS `sys_user_vs_role`;

CREATE TABLE `sys_user_vs_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login_name` varchar(255) DEFAULT NULL,
  `role_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `sys_user_vs_role` */

insert  into `sys_user_vs_role`(`id`,`login_name`,`role_id`) values (1,'1001','1'),(2,'admin','6');

/*Table structure for table `sys_users` */

DROP TABLE IF EXISTS `sys_users`;

CREATE TABLE `sys_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` int(11) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `dept_code` varchar(255) DEFAULT NULL,
  `dept_name` varchar(255) DEFAULT NULL,
  `login_name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `sys_users` */

insert  into `sys_users`(`id`,`active`,`birth_date`,`create_time`,`dept_code`,`dept_name`,`login_name`,`password`,`phone`,`sex`,`title`,`user_name`) values (1,1,'1994-01-05','2018-04-24 15:56:42','1001','神经内科二病区','1001','D�l�t���\Z����XL','13554512727','男','护士','测试护士'),(2,1,'1985-02-11','2018-04-24 16:08:37','1001','神经内科一病区','1002','D�l�t���\Z����XL','027-1002001','女','主管护师','测试护士长'),(3,1,'1985-02-11','2018-04-24 16:08:37','','','admin','D�l�t���\Z����XL','027-1002001','女','超级用户','超级管理员');

/*!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 */;