Java精品项目源码第47期宠物医院管理系统.zip

/* Navicat Premium Data Transfer Source Server : wanghuan Source Server Type : MySQL Source Server Version : 80012 Source Host : localhost:3306 Source Schema : db_forest_yh_lovepet Target Server Type : MySQL Target Server Version : 80012 File Encoding : 65001 Date: 05/01/2021 15:03:08 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for forest_customer -- ---------------------------- DROP TABLE IF EXISTS `forest_customer`; CREATE TABLE `forest_customer` ( `FOREST_Customer_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户编号', `FOREST_Customer_Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户姓名', `FOREST_Customer_Sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户性别', `FOREST_Customer_Card` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户身份证', `FOREST_Customer_Phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户手机号', `FOREST_Customer_Email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户邮箱', `FOREST_Customer_Home` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户住址', `FOREST_Customer_Time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登记时间', PRIMARY KEY (`FOREST_Customer_ID`) USING BTREE, INDEX `FOREST_Customer_ID`(`FOREST_Customer_ID`) USING BTREE, INDEX `FOREST_Customer_ID_2`(`FOREST_Customer_ID`) USING BTREE, INDEX `FOREST_Customer_ID_3`(`FOREST_Customer_ID`) USING BTREE, INDEX `FOREST_Customer_ID_4`(`FOREST_Customer_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of forest_customer -- ---------------------------- INSERT INTO `forest_customer` VALUES (1, '王欢', '男', '411526195608014517', '15737626784', '508377132@qq.com', '河南省信阳市潢川县', '2020-12-29 11:05:31'); INSERT INTO `forest_customer` VALUES (2, '王欢', '男', '411529199901014517', '15736786628', '508377132@qq.com', '河南省新乡市', '2020-12-29 11:35:54'); INSERT INTO `forest_customer` VALUES (3, '豚豚', '女', '411526499987564156', '15838626593', '888888@qq.com', '河南省信阳市', '2020-12-29 13:42:54'); -- ---------------------------- -- Table structure for forest_customer_pets -- ---------------------------- DROP TABLE IF EXISTS `forest_customer_pets`; CREATE TABLE `forest_customer_pets` ( `FOREST_Customer_Pets_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '客宠编号', `FOREST_Customer_ID` int(11) NULL DEFAULT NULL COMMENT '客户编号', `FOREST_Pets_ID` int(11) NULL DEFAULT NULL COMMENT '宠物编号', `FOREST_Customer_Pets_Time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登记时间', PRIMARY KEY (`FOREST_Customer_Pets_ID`) USING BTREE, INDEX `FOREST_Customer_Pets1`(`FOREST_Customer_ID`) USING BTREE, INDEX `FOREST_Customer_Pets2`(`FOREST_Pets_ID`) USING BTREE, CONSTRAINT `FOREST_Customer_Pets1` FOREIGN KEY (`FOREST_Customer_ID`) REFERENCES `forest_customer` (`forest_customer_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FOREST_Customer_Pets2` FOREIGN KEY (`FOREST_Pets_ID`) REFERENCES `forest_pets` (`forest_pets_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of forest_customer_pets -- ---------------------------- INSERT INTO `forest_customer_pets` VALUES (1, 1, 6, '2020-12-29 16:04:49'); INSERT INTO `forest_customer_pets` VALUES (2, 1, 2, '2020-12-29 16:05:49'); INSERT INTO `forest_customer_pets` VALUES (3, 1, 1, '2020-12-29 14:04:49'); INSERT INTO `forest_customer_pets` VALUES (4, 3, 7, '2021-01-04 17:21:58'); -- ---------------------------- -- Table structure for forest_diagnosis -- ---------------------------- DROP TABLE IF EXISTS `forest_diagnosis`; CREATE TABLE `forest_diagnosis` ( `FOREST_Diagnosis_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '诊断编号', `FOREST_Diagnosis_Style` int(11) NULL DEFAULT NULL COMMENT '诊断类型\r\n1普通病例\r\n2重症病例\r\n3 无药可治', `FOREST_Diagnosis_Detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '诊断详情', `FOREST_Pets_ID` int(11) NULL DEFAULT NULL COMMENT '宠物编号', `FOREST_VetDoctor_ID` int(11) NULL DEFAULT NULL COMMENT '兽医编号', `FOREST_Diagnosis_Time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登记时间', PRIMARY KEY (`FOREST_Diagnosis_ID`) USING BTREE, INDEX `FOREST_Diagnosis1`(`FOREST_Pets_ID`) USING BTREE, INDEX `FOREST_Diagnosis2`(`FOREST_VetDoctor_ID`) USING BTREE, CONSTRAINT `FOREST_Diagnosis1` FOREIGN KEY (`FOREST_Pets_ID`) REFERENCES `forest_pets` (`forest_pets_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FOREST_Diagnosis2` FOREIGN KEY (`FOREST_VetDoctor_ID`) REFERENCES `forest_vetdoctor` (`forest_vetdoctor_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of forest_diagnosis -- ---------------------------- INSERT INTO `forest_diagnosis` VALUES (1, 1, '无药可治', 1, 1, '2020-12-30 11:01:16'); INSERT INTO `forest_diagnosis` VALUES (2, 1, ' 无病', 6, 1, '2020-12-30 15:44:09'); INSERT INTO `forest_diagnosis` VALUES (3, 2, '有病', 7, 1, '2021-01-04 17:24:14'); -- ---------------------------- -- Table structure for forest_historyrecord -- ---------------------------- DROP TABLE IF EXISTS `forest_historyrecord`; CREATE TABLE `forest_historyrecord` ( `FOREST_HistoryRecord_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '历史记录编号', `FOREST_User_ID` int(11) NULL DEFAULT NULL COMMENT '用户编号', `FOREST_Pets_ID` int(11) NULL DEFAULT NULL COMMENT '宠物编号', `FOREST_User_Pets_Time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登记时间', PRIMARY KEY (`FOREST_HistoryRecord_ID`) USING BTREE, INDEX `FOREST_HistoryRecord1`(`FOREST_User_ID`) USING BTREE, INDEX `FOREST_HistoryRecord2`(`FOREST_Pets_ID`) USING BTREE, CONSTRAINT `FOREST_HistoryRecord1` FOREIGN KEY (`FOREST_User_ID`) REFERENCES `forest_user` (`forest_user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FOREST_HistoryRecord2` FOREIGN KEY (`FOREST_Pets_ID`) REFERENCES `forest_pets` (`forest_pets_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 93 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of forest_historyrecord -- ---------------------------- INSERT INTO `forest_historyrecord` VALUES (1, 1, 1, '2020-12-30 09:16:59'); INSERT INTO `forest_historyrecord` VALUES (2, 2, 2, '2020-12-30 10:02:33'); INSERT INTO `forest_historyrecord` VALUES (3, 2, 2, '2020-12-30 10:03:33'); INSERT INTO `forest_historyrecord` VALUES (4, 2, 2, '2020-12-30 10:12:13'); INSERT INTO `forest_historyrecord` VALUES (5, 2, 2, '2020-12-30 10:41:14'); INSERT INTO `forest_historyrecord` VALUES (6, 2, 2, '2020-12-30 16:54:01'); INSERT INTO `forest_historyrecord` VALUES (7, 2, 1, '2020-12-30 16:54:05'); INSERT INTO `forest_historyrecord` VALUES (8, 2, 6, '2020-12-30 16:54:07'); INSERT INTO `forest_historyrecord` VALUES (9, 2, 1, '2020-12-30 16:54:15'); INSERT INTO `forest_historyrecord` VALUES (10, 2, 1, '2020-12-30 17:33:52'); INSERT INTO `forest_historyrecord` VALUES (11, 2, 6, '2020-12-30 17:33:54'); INSERT INTO `forest_historyrecord` VALUES (12, 2, 2, '2020-12-30 17:33:57'); INSERT INTO `for