pet-clinic_V2
/
petclinic-v2.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80011
 Source Host           : localhost:3306
 Source Schema         : petclinic-v2

 Target Server Type    : MySQL
 Target Server Version : 80011
 File Encoding         : 65001

 Date: 06/12/2022 15:50:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee`  (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮箱',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '账户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES ('123@qq.com', '123456');

-- ----------------------------
-- Table structure for owner
-- ----------------------------
DROP TABLE IF EXISTS `owner`;
CREATE TABLE `owner`  (
  `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '城市',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电话',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '宠物主人' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of owner
-- ----------------------------
INSERT INTO `owner` VALUES (1, '冬奥会', '北京', '北京', '110120119150');
INSERT INTO `owner` VALUES (2, '冬天的火', '西安', '陕西', '11111111');
INSERT INTO `owner` VALUES (4, '卡塔尔家主', '卡塔尔', '卡塔尔', '123456789');
INSERT INTO `owner` VALUES (5, '沙特王子', '沙特阿拉伯', '沙特阿拉伯', '12131513132');

-- ----------------------------
-- Table structure for pets
-- ----------------------------
DROP TABLE IF EXISTS `pets`;
CREATE TABLE `pets`  (
  `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '宠物名',
  `birthDate` datetime(0) DEFAULT NULL COMMENT '出生日期',
  `ownerId` bigint(32) DEFAULT NULL COMMENT '外键:关联owner表',
  `typeId` bigint(32) DEFAULT NULL COMMENT '外键:关联type表',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '宠物' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pets
-- ----------------------------
INSERT INTO `pets` VALUES (1, '冰墩墩', '2021-07-10 10:25:31', 1, 1);
INSERT INTO `pets` VALUES (2, '雪融融', '2021-07-17 10:58:12', 1, 1);
INSERT INTO `pets` VALUES (3, '凤凰', '2022-12-06 11:01:52', 2, 2);
INSERT INTO `pets` VALUES (4, '凤涅', '2022-12-06 11:08:49', 1, 2);
INSERT INTO `pets` VALUES (5, '年兽来啦', '2022-12-06 12:05:00', 2, 2);
INSERT INTO `pets` VALUES (7, '饺子皮', '2022-12-01 12:10:00', 4, 2);
INSERT INTO `pets` VALUES (10, '芒果皮', '2022-12-06 13:51:00', 5, 2);
INSERT INTO `pets` VALUES (11, '游龙', '2022-11-03 14:21:00', 5, 3);
INSERT INTO `pets` VALUES (12, '西施', '2031-02-07 14:23:00', 4, 1);
INSERT INTO `pets` VALUES (13, '瞎猫', '2022-12-04 14:25:00', 2, 2);
INSERT INTO `pets` VALUES (14, '魔鬼', '2022-12-03 14:26:00', 4, 1);

-- ----------------------------
-- Table structure for specialties
-- ----------------------------
DROP TABLE IF EXISTS `specialties`;
CREATE TABLE `specialties`  (
  `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '科室名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '科室' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of specialties
-- ----------------------------
INSERT INTO `specialties` VALUES (1, '专长一');
INSERT INTO `specialties` VALUES (2, '专长二');
INSERT INTO `specialties` VALUES (3, '专长三');

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type`  (
  `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '宠物类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of type
-- ----------------------------
INSERT INTO `type` VALUES (1, '犬');
INSERT INTO `type` VALUES (2, '猫');
INSERT INTO `type` VALUES (3, '蛇');
INSERT INTO `type` VALUES (4, '熊');
INSERT INTO `type` VALUES (5, '昆虫');
INSERT INTO `type` VALUES (6, '其他');

-- ----------------------------
-- Table structure for vets
-- ----------------------------
DROP TABLE IF EXISTS `vets`;
CREATE TABLE `vets`  (
  `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '医师名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '兽医' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of vets
-- ----------------------------
INSERT INTO `vets` VALUES (1, '兽医一号');
INSERT INTO `vets` VALUES (2, '兽医二号');
INSERT INTO `vets` VALUES (3, '兽医三号');
INSERT INTO `vets` VALUES (6, '兽医四号');
INSERT INTO `vets` VALUES (7, '兽医五号');

-- ----------------------------
-- Table structure for vetspecialties
-- ----------------------------
DROP TABLE IF EXISTS `vetspecialties`;
CREATE TABLE `vetspecialties`  (
  `vetId` bigint(32) DEFAULT NULL COMMENT '兽医id',
  `specialtyId` bigint(32) DEFAULT NULL COMMENT '科室id'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '兽医科室关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of vetspecialties
-- ----------------------------
INSERT INTO `vetspecialties` VALUES (1, 1);
INSERT INTO `vetspecialties` VALUES (1, 2);
INSERT INTO `vetspecialties` VALUES (2, 2);
INSERT INTO `vetspecialties` VALUES (2, 3);
INSERT INTO `vetspecialties` VALUES (3, 2);
INSERT INTO `vetspecialties` VALUES (6, 1);
INSERT INTO `vetspecialties` VALUES (6, 2);
INSERT INTO `vetspecialties` VALUES (6, 3);
INSERT INTO `vetspecialties` VALUES (7, 1);

-- ----------------------------
-- Table structure for visits
-- ----------------------------
DROP TABLE IF EXISTS `visits`;
CREATE TABLE `visits`  (
  `id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `petId` bigint(32) DEFAULT NULL COMMENT '宠物id',
  `visitDate` datetime(0) DEFAULT NULL COMMENT '访问日期',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '访客' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of visits
-- ----------------------------
INSERT INTO `visits` VALUES (1, 1, '2022-12-06 14:53:00', '疫情');
INSERT INTO `visits` VALUES (2, 1, '2022-12-01 15:28:00', '腹泻');
INSERT INTO `visits` VALUES (3, 2, '2022-12-01 15:47:00', '鼠疫');

SET FOREIGN_KEY_CHECKS = 1;