/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : health

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2020-03-15 14:58:06
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for docpat
-- ----------------------------
DROP TABLE IF EXISTS `docpat`;
CREATE TABLE `docpat` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `docid` int(8) DEFAULT NULL,
  `patid` int(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of docpat
-- ----------------------------
INSERT INTO `docpat` VALUES ('1', '1', '1');
INSERT INTO `docpat` VALUES ('2', '2', '1');

-- ----------------------------
-- Table structure for docpingjia
-- ----------------------------
DROP TABLE IF EXISTS `docpingjia`;
CREATE TABLE `docpingjia` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `logId` int(8) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL COMMENT '评价',
  `jianyi` varchar(255) DEFAULT NULL COMMENT '建议',
  `riqi` varchar(255) DEFAULT NULL,
  `docId` int(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of docpingjia
-- ----------------------------

-- ----------------------------
-- Table structure for doctor
-- ----------------------------
DROP TABLE IF EXISTS `doctor`;
CREATE TABLE `doctor` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `docname` varchar(255) DEFAULT NULL COMMENT '真实名称',
  `tel` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `describetion` varchar(255) DEFAULT NULL COMMENT '描述',
  `times` varchar(255) DEFAULT NULL COMMENT '从业',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of doctor
-- ----------------------------
INSERT INTO `doctor` VALUES ('1', 'aa', '123', '/images/2.png', 'lisio', '1311111111', 'sfdefv@qq.com', '显示', '3');
INSERT INTO `doctor` VALUES ('2', 'aaa', '123', null, '李四', '1311111111', 'sfdefv@qq.com', null, '5');
INSERT INTO `doctor` VALUES ('3', 'asd', 'aa', null, '王五', '1311111111', 'sfdefv@qq.com', null, '6');

-- ----------------------------
-- Table structure for meirituijian
-- ----------------------------
DROP TABLE IF EXISTS `meirituijian`;
CREATE TABLE `meirituijian` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of meirituijian
-- ----------------------------
INSERT INTO `meirituijian` VALUES ('2', '今天是个好天气，适合多出去运动');
INSERT INTO `meirituijian` VALUES ('3', '今天有风大家多注意保暖');
INSERT INTO `meirituijian` VALUES ('4', '2021-05-14天气晴朗多出去锻炼');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `docId` int(8) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `riqi` varchar(255) DEFAULT NULL COMMENT '日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES ('1', '1', '张三信息', '这个是一个信息', '2021-05-20');
INSERT INTO `news` VALUES ('2', null, '讯息1', '讯息来哦了222', '2021-05-05');
INSERT INTO `news` VALUES ('3', '1', '医生信息1', '我二狗信息开始了', '2021-05-11');

-- ----------------------------
-- Table structure for patdaylog
-- ----------------------------
DROP TABLE IF EXISTS `patdaylog`;
CREATE TABLE `patdaylog` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `patid` int(8) DEFAULT NULL,
  `yinshi` varchar(255) DEFAULT NULL COMMENT '饮食',
  `shenghuofangshi` varchar(255) DEFAULT NULL COMMENT '生活方式',
  `yongyao` varchar(255) DEFAULT NULL COMMENT '用药',
  `yibanjiancha` varchar(255) DEFAULT NULL COMMENT '一般检查',
  `riqi` varchar(255) DEFAULT NULL COMMENT '日期',
  `gaoxueya` varchar(64) DEFAULT '0' COMMENT '高血压',
  `gaoxuetang` varchar(64) DEFAULT '0' COMMENT '高血糖',
  `gaoxuezhi` varchar(64) DEFAULT '0' COMMENT '高血脂',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of patdaylog
-- ----------------------------
INSERT INTO `patdaylog` VALUES ('7', '1', '吃馒头', '野外跑步', '降压药', '吃了几颗糖', '2021-05-08', '125', '5', '21');

-- ----------------------------
-- Table structure for patient
-- ----------------------------
DROP TABLE IF EXISTS `patient`;
CREATE TABLE `patient` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `loginname` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `patname` varchar(255) DEFAULT NULL COMMENT '真实名字',
  `description` varchar(255) DEFAULT NULL,
  `age` int(8) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of patient
-- ----------------------------
INSERT INTO `patient` VALUES ('1', 'zhang', '123', '13111111111', 'csd@qq.com', '张家界', '张三111', '导出', '69');
INSERT INTO `patient` VALUES ('2', 'csd', 'aa', 'csdf', 'csd', null, null, null, '76');
INSERT INTO `patient` VALUES ('3', 'sdvv', 'casc', 'csdc', 'csdc', null, null, null, '45');

-- ----------------------------
-- Table structure for uptype
-- ----------------------------
DROP TABLE IF EXISTS `uptype`;
CREATE TABLE `uptype` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `typename` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of uptype
-- ----------------------------
INSERT INTO `uptype` VALUES ('2', '高血压', '高血压222');

-- ----------------------------
-- Table structure for userfile
-- ----------------------------
DROP TABLE IF EXISTS `userfile`;
CREATE TABLE `userfile` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `docId` int(8) DEFAULT NULL COMMENT '医师主键',
  `typeId` int(8) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `upaddress` varchar(255) DEFAULT NULL,
  `upstate` int(8) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of userfile
-- ----------------------------
INSERT INTO `userfile` VALUES ('1', '1', '2', '文献', 'code.txt', '1');
INSERT INTO `userfile` VALUES ('2', '1', '2', '高血压', '高血压注意事项.txt', '1');
