爱心宠物诊所系统实训源码

/* Navicat Premium Data Transfer Source Server : Local Source Server Type : MySQL Source Server Version : 80015 Source Host : localhost:3306 Source Schema : animals Target Server Type : MySQL Target Server Version : 80015 File Encoding : 65001 Date: 05/06/2022 09:40:22 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for owner -- ---------------------------- DROP TABLE IF EXISTS `owner`; CREATE TABLE `owner` ( `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主人ID', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主人姓名', `gender` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主人性别', `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主人地址', `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主人电话', `is_deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑删除', `gmt_create` datetime NULL DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `name`(`name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for pet -- ---------------------------- DROP TABLE IF EXISTS `pet`; CREATE TABLE `pet` ( `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '宠物ID', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物姓名', `gender` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物性别', `age` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物年龄', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物头像', `is_deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑删除（1 已删除）（0 未删除）', `gmt_create` datetime NULL DEFAULT NULL COMMENT '创建日期', `gmt_modified` datetime NULL DEFAULT NULL COMMENT '更新日期', `owner` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主人姓名', `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '一级分类名称', `type_parent` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二级分类名称', `owner_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主人ID', PRIMARY KEY (`id`) USING BTREE, INDEX `pet_owner_id`(`owner_id`) USING BTREE, INDEX `pet_owner_name`(`owner`) USING BTREE, CONSTRAINT `pet_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `owner` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `pet_owner_name` FOREIGN KEY (`owner`) REFERENCES `owner` (`name`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for type -- ---------------------------- DROP TABLE IF EXISTS `type`; CREATE TABLE `type` ( `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型ID', `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类别名称', `parent_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父ID（0则为一级分类）', `gmt_create` datetime NULL DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `name`(`name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(20) NOT NULL, `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员用户名', `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员密码', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for vet -- ---------------------------- DROP TABLE IF EXISTS `vet`; CREATE TABLE `vet` ( `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '兽医ID', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '兽医姓名', `gender` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '兽医性别', `speciality` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '兽医的专业特长', `gmt_create` datetime NULL DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for visit -- ---------------------------- DROP TABLE IF EXISTS `visit`; CREATE TABLE `visit` ( `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '访问信息ID', `pet_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物ID', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物描述信息', `gmt_create` datetime NULL DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime NULL DEFAULT NULL COMMENT '修改时间', `owner_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主人ID', PRIMARY KEY (`id`) USING BTREE, INDEX `visit_pet_id`(`pet_id`) USING BTREE, INDEX `visit_owner_id`(`owner_id`) USING BTREE, CONSTRAINT `visit_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `owner` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `visit_pet_id` FOREIGN KEY (`pet_id`) REFERENCES `pet` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;