You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
196 lines
6.9 KiB
196 lines
6.9 KiB
/*
|
|
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');
|