基于SpringBoot的宠物管理系统
发布时间
阅读量：
阅读量
介绍
系统主要支撑功能实现, 包括系统层面的管理与操作, 具体涉及用户管理模块, 页面管理模块, 角色管理模块等核心业务功能. 系统还包含宠物档案列表, 宠物健康记录, 医疗安排时间表等相关服务. 整个系统的开发基于Springoot mybatis框架完成.
数据库
只展现部分数据表
DROP TABLE IF EXISTS `appointment`;
CREATE TABLE `appointment` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`pet_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`doctor_id` bigint(20) DEFAULT NULL,
`app_time` datetime(0) DEFAULT NULL,
`info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`create_time` datetime(0) DEFAULT NULL,
`status` int(5) DEFAULT NULL,
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `diagnosis`;
CREATE TABLE `diagnosis` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`pet_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`doctor_id` bigint(20) DEFAULT NULL,
`info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`type` int(5) DEFAULT NULL,
`status` int(5) DEFAULT NULL,
`create_time` datetime(0) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`view_count` bigint(20) DEFAULT NULL,
`create_time` datetime(0) DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;运行效果
全部评论 (0)
还没有任何评论哟~