TestDataManange-backend/sql/robot.sql

/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.37-log : Database - robot
*********************************************************************
*/

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

USE `robot`;

/*Table structure for table `robot_patient` */

DROP TABLE IF EXISTS `robot_patient`;

CREATE TABLE `robot_patient` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `patient_name` varchar(255) DEFAULT NULL COMMENT '患者姓名',
  `patient_sex` varchar(255) DEFAULT NULL COMMENT '患者性别（1男2女）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='患者表';

/*Data for the table `robot_patient` */

insert  into `robot_patient`(`id`,`patient_name`,`patient_sex`) values ('0479951f8964175e624b2ca61ee0e835','侯玉宇','2'),('34ddebc05f7c9fb769fcd020028203d6','庞日成','1'),('7b137ca2d563086b9e4fadee385b50b8','','2');

/*Table structure for table `robot_symptom_part` */

DROP TABLE IF EXISTS `robot_symptom_part`;

CREATE TABLE `robot_symptom_part` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `part_name` varchar(255) DEFAULT NULL COMMENT '部位名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='部位表';

/*Data for the table `robot_symptom_part` */

insert  into `robot_symptom_part`(`id`,`part_name`) values ('3244c36870e4a47ef1fc6e2c1acf00a2','眼耳口鼻'),('4c4c0e819fc95c09dde308cc04df6256','双下肢'),('608dd4772103c7b3a198641cf842a4e1','双上肢'),('62207ec3cd713e906c461dfbfddf6504','肩部'),('6b866f5e2ee092c0d2d0ffd5d9fea78b','腰部'),('88806113c934137edd261d1e8a4f1f72','颈部'),('92edaaa5ee8d304d9f01950e7979d2ab','头部'),('96f7f70bf165d11a1161e19e2917ad65','其他'),('a43438901e6b5f56d8aff49ea0c423d6','生殖器'),('aaecbc8d28a302e5b89740e3d4ccf3b8','臀部'),('c752554d2a789e07774532201a0876d9','背部'),('c826bc719672e94482422eb355bcdee6','皮肤'),('d311f223dd97959e447bcc4e63e38c22','胸部'),('e7d8dc2171ec4f64b895b82c5d627459','排泄部'),('ea4766dfb3950d787b4fae051c525a13','腹部');

/*Table structure for table `robot_symptom_type` */

DROP TABLE IF EXISTS `robot_symptom_type`;

CREATE TABLE `robot_symptom_type` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `part_id` varchar(50) DEFAULT NULL COMMENT '所属部位',
  `type_name` varchar(255) DEFAULT NULL COMMENT '症状名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='症状表';

/*Data for the table `robot_symptom_type` */

insert  into `robot_symptom_type`(`id`,`part_id`,`type_name`) values ('314292492987dbac45618f0633ad5fba','d311f223dd97959e447bcc4e63e38c22','咳嗽'),('5e7924f1a27fc08a817dd31820fa3736','62207ec3cd713e906c461dfbfddf6504','肩关节活动受限'),('7e696f88dfec22d719b033608a21b387','62207ec3cd713e906c461dfbfddf6504','右肩背有放射痛'),('fdeee4116cd6c0a16fe15fe1bfc208ef','d311f223dd97959e447bcc4e63e38c22','咳痰');

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