/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50727
Source Host           : localhost:3306
Source Database       : sqhospitol

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

Date: 2021-04-25 09:53:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for diseaseinfo
-- ----------------------------
DROP TABLE IF EXISTS `diseaseinfo`;
CREATE TABLE `diseaseinfo` (
  `Email` varchar(255) DEFAULT NULL,
  `UUID` varchar(255) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `Disease` varchar(255) DEFAULT NULL,
  `AdmissionDate` varchar(255) DEFAULT NULL,
  `Health` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of diseaseinfo
-- ----------------------------
INSERT INTO `diseaseinfo` VALUES ('2606097218@qq.com', '9e096dfa-0378-4aa9-8f45-50e70063344e', '佐佳豪', '增加智商术', '2021-04-23T15:36', '已康复');
INSERT INTO `diseaseinfo` VALUES ('2891541194@qq.com', '6c7c4538-82c3-44f0-9028-3492897ff515', '彭君豪', '吐泡泡', '2021-04-23T15:37', '康复');
INSERT INTO `diseaseinfo` VALUES ('2891541194@qq.com', '0da1848e-d812-47ac-80c2-082f90c3f96b', '张三2', '吐泡泡', '2021-04-23T15:41', '康复');
INSERT INTO `diseaseinfo` VALUES ('2958384476@qq.com', 'c7cb7277-b1e7-4b05-ae94-95995c5e15c2', '张三2', '感冒', '2021-04-23T15:42', '复诊');
INSERT INTO `diseaseinfo` VALUES ('2891541194@qq.com', '22e92b21-6ab3-4032-8e4e-2857210bc6b8', '张三2', '吐泡泡', '2021-04-23T15:42', '住院观察中');
INSERT INTO `diseaseinfo` VALUES ('2958384476@qq.com', '37028c06-7083-40f2-9089-59f4f8e8241c', '佐佳豪', '吐泡泡', '2021-04-23T15:42', '康复');
INSERT INTO `diseaseinfo` VALUES ('123@qq', '5e54332f-47b3-430e-914c-4159bbaaa7a2', '彭君豪', '增加智商术', '2021-04-25T09:34', '住院观察中');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `Email` varchar(255) NOT NULL,
  `Username` varchar(255) NOT NULL,
  `Password` varchar(255) NOT NULL,
  `Gender` varchar(10) DEFAULT NULL,
  `Birth` varchar(40) DEFAULT NULL,
  `Country` varchar(20) DEFAULT NULL,
  `Address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('123@qq', '佐佳豪', '123', ' ', null, null, null);
INSERT INTO `user` VALUES ('1836353530@qq.com', 'zero', '123', '男', '', '', '');
INSERT INTO `user` VALUES ('2111606097218@qq.com', '彭君豪', '321', ' ', null, null, null);
INSERT INTO `user` VALUES ('2606097218@qq.com', '佐佳豪', '777', ' ', null, null, null);
INSERT INTO `user` VALUES ('2606097218@qq.com1', '李玮峰', '123', ' ', null, null, null);
INSERT INTO `user` VALUES ('28915411194@qq.com', 'zjh1', '123321', ' ', null, null, null);
INSERT INTO `user` VALUES ('2891541194@qq.com', '李玮峰', '321', '女', '2001.1.20', '中国', '江西抚州');


CREATE TABLE `chat` (
                        `chat_id` int(20) NOT NULL AUTO_INCREMENT,
                        `name` varchar(255) DEFAULT NULL,
                        `mes` varchar(255) DEFAULT NULL,
                        PRIMARY KEY (`chat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;