外链发布平台,太原百度seo排名,wordpress google字体,徐州教育平台网站建设#x1f497;博主介绍#x1f497;#xff1a;✌在职Java研发工程师、专注于程序设计、源码分享、技术交流、专注于Java技术领域和毕业设计✌ 温馨提示#xff1a;文末有 CSDN 平台官方提供的老师 Wechat / QQ 名片 :) Java精品实战案例《700套》 2025最新毕业设计选题推荐… 博主介绍✌在职Java研发工程师、专注于程序设计、源码分享、技术交流、专注于Java技术领域和毕业设计✌ 温馨提示文末有 CSDN 平台官方提供的老师 Wechat / QQ 名片 :) Java精品实战案例《700套》 2025最新毕业设计选题推荐最热的500个选题o(▽) 介绍 系统功能设计旨在满足用户需求并实现系统的核心功能。基于SpringBoot框架和微信小程序技术系统功能设计包括统计分析、用户管理、场地管理、订单管理、广告管理、项目管理、场馆管理和管理员管理等模块。通过统计分析功能管理员可以了解系统运行情况并做出有效决策。用户管理模块确保用户信息的准确性和完整性。场地管理模块使管理员能够方便地维护智能球馆信息。订单管理模块保证预约流程顺利进行。广告管理模块提高系统商业价值。项目管理模块满足用户不同需求。场馆管理模块确保场馆运营正常进行。管理员管理模块保证系统后台安全稳定运行。综上所述系统功能设计全面覆盖用户和管理员需求提供高效便捷的足球场地预约服务。 系统功能 系统截图 功能代码 /*{\gymId\:58,\status\:0,\time\:16,\price\:15.00},{\gymId\:58,\status\:0,\time\:17,\price\:15.00},{\gymId\:58,\status\:0,\time\:18,\price\:15.00},{\gymId\:58,\status\:0,\time\:19,\price\:15.00},{\gymId\:58,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:59,\gymName\:\外场3\,\price\:15.00,\timeList\:[{\gymId\:59,\status\:0,\time\:9,\price\:15.00},{\gymId\:59,\status\:0,\time\:10,\price\:15.00},{\gymId\:59,\status\:0,\time\:11,\price\:15.00},{\gymId\:59,\status\:0,\time\:12,\price\:15.00},{\gymId\:59,\status\:0,\time\:13,\price\:15.00},{\gymId\:59,\status\:0,\time\:14,\price\:15.00},{\gymId\:59,\status\:0,\time\:15,\price\:15.00},{\gymId\:59,\status\:0,\time\:16,\price\:15.00},{\gymId\:59,\status\:0,\time\:17,\price\:15.00},{\gymId\:59,\status\:0,\time\:18,\price\:15.00},{\gymId\:59,\status\:0,\time\:19,\price\:15.00},{\gymId\:59,\status\:0,\time\:20,\price\:15.00}]}]);
INSERT INTO g_gym_appoint VALUES (667, NULL, 6, [{\gymId\:52,\gymName\:\外场1-1\,\price\:15.00,\timeList\:[{\gymId\:52,\status\:0,\time\:9,\price\:15.00},{\gymId\:52,\status\:0,\time\:10,\price\:15.00},{\gymId\:52,\status\:0,\time\:11,\price\:15.00},{\gymId\:52,\status\:0,\time\:12,\price\:15.00},{\gymId\:52,\status\:0,\time\:13,\price\:15.00},{\gymId\:52,\status\:0,\time\:14,\price\:15.00},{\gymId\:52,\status\:0,\time\:15,\price\:15.00},{\gymId\:52,\status\:0,\time\:16,\price\:15.00},{\gymId\:52,\status\:0,\time\:17,\price\:15.00},{\gymId\:52,\status\:0,\time\:18,\price\:15.00},{\gymId\:52,\status\:0,\time\:19,\price\:15.00},{\gymId\:52,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:53,\gymName\:\外场1-2\,\price\:15.00,\timeList\:[{\gymId\:53,\status\:0,\time\:9,\price\:15.00},{\gymId\:53,\status\:0,\time\:10,\price\:15.00},{\gymId\:53,\status\:0,\time\:11,\price\:15.00},{\gymId\:53,\status\:0,\time\:12,\price\:15.00},{\gymId\:53,\status\:0,\time\:13,\price\:15.00},{\gymId\:53,\status\:0,\time\:14,\price\:15.00},{\gymId\:53,\status\:0,\time\:15,\price\:15.00},{\gymId\:53,\status\:0,\time\:16,\price\:15.00},{\gymId\:53,\status\:0,\time\:17,\price\:15.00},{\gymId\:53,\status\:0,\time\:18,\price\:15.00},{\gymId\:53,\status\:0,\time\:19,\price\:15.00},{\gymId\:53,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:57,\gymName\:\外场2-1\,\price\:15.00,\timeList\:[{\gymId\:57,\status\:0,\time\:9,\price\:15.00},{\gymId\:57,\status\:0,\time\:10,\price\:15.00},{\gymId\:57,\status\:0,\time\:11,\price\:15.00},{\gymId\:57,\status\:0,\time\:12,\price\:15.00},{\gymId\:57,\status\:0,\time\:13,\price\:15.00},{\gymId\:57,\status\:0,\time\:14,\price\:15.00},{\gymId\:57,\status\:0,\time\:15,\price\:15.00},{\gymId\:57,\status\:0,\time\:16,\price\:15.00},{\gymId\:57,\status\:0,\time\:17,\price\:15.00},{\gymId\:57,\status\:0,\time\:18,\price\:15.00},{\gymId\:57,\status\:0,\time\:19,\price\:15.00},{\gymId\:57,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:58,\gymName\:\外场2-2\,\price\:15.00,\timeList\:[{\gymId\:58,\status\:0,\time\:9,\price\:15.00},{\gymId\:58,\status\:0,\time\:10,\price\:15.00},{\gymId\:58,\status\:0,\time\:11,\price\:15.00},{\gymId\:58,\status\:0,\time\:12,\price\:15.00},{\gymId\:58,\status\:0,\time\:13,\price\:15.00},{\gymId\:58,\status\:0,\time\:14,\price\:15.00},{\gymId\:58,\status\:0,\time\:15,\price\:15.00},{\gymId\:58,\status\:0,\time\:16,\price\:15.00},{\gymId\:58,\status\:0,\time\:17,\price\:15.00},{\gymId\:58,\status\:0,\time\:18,\price\:15.00},{\gymId\:58,\status\:0,\time\:19,\price\:15.00},{\gymId\:58,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:59,\gymName\:\外场3\,\price\:15.00,\timeList\:[{\gymId\:59,\status\:0,\time\:9,\price\:15.00},{\gymId\:59,\status\:0,\time\:10,\price\:15.00},{\gymId\:59,\status\:0,\time\:11,\price\:15.00},{\gymId\:59,\status\:0,\time\:12,\price\:15.00},{\gymId\:59,\status\:0,\time\:13,\price\:15.00},{\gymId\:59,\status\:0,\time\:14,\price\:15.00},{\gymId\:59,\status\:0,\time\:15,\price\:15.00},{\gymId\:59,\status\:0,\time\:16,\price\:15.00},{\gymId\:59,\status\:0,\time\:17,\price\:15.00},{\gymId\:59,\status\:0,\time\:18,\price\:15.00},{\gymId\:59,\status\:0,\time\:19,\price\:15.00},{\gymId\:59,\status\:0,\time\:20,\price\:15.00}]}]);
INSERT INTO g_gym_appoint VALUES (668, NULL, 6, [{\gymId\:52,\gymName\:\外场1-1\,\price\:15.00,\timeList\:[{\gymId\:52,\status\:0,\time\:9,\price\:15.00},{\gymId\:52,\status\:0,\time\:10,\price\:15.00},{\gymId\:52,\status\:0,\time\:11,\price\:15.00},{\gymId\:52,\status\:0,\time\:12,\price\:15.00},{\gymId\:52,\status\:0,\time\:13,\price\:15.00},{\gymId\:52,\status\:0,\time\:14,\price\:15.00},{\gymId\:52,\status\:0,\time\:15,\price\:15.00},{\gymId\:52,\status\:0,\time\:16,\price\:15.00},{\gymId\:52,\status\:0,\time\:17,\price\:15.00},{\gymId\:52,\status\:0,\time\:18,\price\:15.00},{\gymId\:52,\status\:0,\time\:19,\price\:15.00},{\gymId\:52,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:53,\gymName\:\外场1-2\,\price\:15.00,\timeList\:[{\gymId\:53,\status\:0,\time\:9,\price\:15.00},{\gymId\:53,\status\:0,\time\:10,\price\:15.00},{\gymId\:53,\status\:0,\time\:11,\price\:15.00},{\gymId\:53,\status\:0,\time\:12,\price\:15.00},{\gymId\:53,\status\:0,\time\:13,\price\:15.00},{\gymId\:53,\status\:0,\time\:14,\price\:15.00},{\gymId\:53,\status\:0,\time\:15,\price\:15.00},{\gymId\:53,\status\:0,\time\:16,\price\:15.00},{\gymId\:53,\status\:0,\time\:17,\price\:15.00},{\gymId\:53,\status\:0,\time\:18,\price\:15.00},{\gymId\:53,\status\:0,\time\:19,\price\:15.00},{\gymId\:53,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:57,\gymName\:\外场2-1\,\price\:15.00,\timeList\:[{\gymId\:57,\status\:0,\time\:9,\price\:15.00},{\gymId\:57,\status\:0,\time\:10,\price\:15.00},{\gymId\:57,\status\:0,\time\:11,\price\:15.00},{\gymId\:57,\status\:0,\time\:12,\price\:15.00},{\gymId\:57,\status\:0,\time\:13,\price\:15.00},{\gymId\:57,\status\:0,\time\:14,\price\:15.00},{\gymId\:57,\status\:0,\time\:15,\price\:15.00},{\gymId\:57,\status\:0,\time\:16,\price\:15.00},{\gymId\:57,\status\:0,\time\:17,\price\:15.00},{\gymId\:57,\status\:0,\time\:18,\price\:15.00},{\gymId\:57,\status\:0,\time\:19,\price\:15.00},{\gymId\:57,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:58,\gymName\:\外场2-2\,\price\:15.00,\timeList\:[{\gymId\:58,\status\:0,\time\:9,\price\:15.00},{\gymId\:58,\status\:0,\time\:10,\price\:15.00},{\gymId\:58,\status\:0,\time\:11,\price\:15.00},{\gymId\:58,\status\:0,\time\:12,\price\:15.00},{\gymId\:58,\status\:0,\time\:13,\price\:15.00},{\gymId\:58,\status\:0,\time\:14,\price\:15.00},{\gymId\:58,\status\:0,\time\:15,\price\:15.00},{\gymId\:58,\status\:0,\time\:16,\price\:15.00},{\gymId\:58,\status\:0,\time\:17,\price\:15.00},{\gymId\:58,\status\:0,\time\:18,\price\:15.00},{\gymId\:58,\status\:0,\time\:19,\price\:15.00},{\gymId\:58,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:59,\gymName\:\外场3\,\price\:15.00,\timeList\:[{\gymId\:59,\status\:0,\time\:9,\price\:15.00},{\gymId\:59,\status\:0,\time\:10,\price\:15.00},{\gymId\:59,\status\:0,\time\:11,\price\:15.00},{\gymId\:59,\status\:0,\time\:12,\price\:15.00},{\gymId\:59,\status\:0,\time\:13,\price\:15.00},{\gymId\:59,\status\:0,\time\:14,\price\:15.00},{\gymId\:59,\status\:0,\time\:15,\price\:15.00},{\gymId\:59,\status\:0,\time\:16,\price\:15.00},{\gymId\:59,\status\:0,\time\:17,\price\:15.00},{\gymId\:59,\status\:0,\time\:18,\price\:15.00},{\gymId\:59,\status\:0,\time\:19,\price\:15.00},{\gymId\:59,\status\:0,\time\:20,\price\:15.00}]}]);
INSERT INTO g_gym_appoint VALUES (669, NULL, 6, [{\gymId\:52,\gymName\:\外场1-1\,\price\:15.00,\timeList\:[{\gymId\:52,\status\:0,\time\:9,\price\:15.00},{\gymId\:52,\status\:0,\time\:10,\price\:15.00},{\gymId\:52,\status\:0,\time\:11,\price\:15.00},{\gymId\:52,\status\:0,\time\:12,\price\:15.00},{\gymId\:52,\status\:0,\time\:13,\price\:15.00},{\gymId\:52,\status\:0,\time\:14,\price\:15.00},{\gymId\:52,\status\:0,\time\:15,\price\:15.00},{\gymId\:52,\status\:0,\time\:16,\price\:15.00},{\gymId\:52,\status\:0,\time\:17,\price\:15.00},{\gymId\:52,\status\:0,\time\:18,\price\:15.00},{\gymId\:52,\status\:0,\time\:19,\price\:15.00},{\gymId\:52,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:53,\gymName\:\外场1-2\,\price\:15.00,\timeList\:[{\gymId\:53,\status\:0,\time\:9,\price\:15.00},{\gymId\:53,\status\:0,\time\:10,\price\:15.00},{\gymId\:53,\status\:0,\time\:11,\price\:15.00},{\gymId\:53,\status\:0,\time\:12,\price\:15.00},{\gymId\:53,\status\:0,\time\:13,\price\:15.00},{\gymId\:53,\status\:0,\time\:14,\price\:15.00},{\gymId\:53,\status\:0,\time\:15,\price\:15.00},{\gymId\:53,\status\:0,\time\:16,\price\:15.00},{\gymId\:53,\status\:0,\time\:17,\price\:15.00},{\gymId\:53,\status\:0,\time\:18,\price\:15.00},{\gymId\:53,\status\:0,\time\:19,\price\:15.00},{\gymId\:53,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:57,\gymName\:\外场2-1\,\price\:15.00,\timeList\:[{\gymId\:57,\status\:0,\time\:9,\price\:15.00},{\gymId\:57,\status\:0,\time\:10,\price\:15.00},{\gymId\:57,\status\:0,\time\:11,\price\:15.00},{\gymId\:57,\status\:0,\time\:12,\price\:15.00},{\gymId\:57,\status\:0,\time\:13,\price\:15.00},{\gymId\:57,\status\:0,\time\:14,\price\:15.00},{\gymId\:57,\status\:0,\time\:15,\price\:15.00},{\gymId\:57,\status\:0,\time\:16,\price\:15.00},{\gymId\:57,\status\:0,\time\:17,\price\:15.00},{\gymId\:57,\status\:0,\time\:18,\price\:15.00},{\gymId\:57,\status\:0,\time\:19,\price\:15.00},{\gymId\:57,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:58,\gymName\:\外场2-2\,\price\:15.00,\timeList\:[{\gymId\:58,\status\:0,\time\:9,\price\:15.00},{\gymId\:58,\status\:0,\time\:10,\price\:15.00},{\gymId\:58,\status\:0,\time\:11,\price\:15.00},{\gymId\:58,\status\:0,\time\:12,\price\:15.00},{\gymId\:58,\status\:0,\time\:13,\price\:15.00},{\gymId\:58,\status\:0,\time\:14,\price\:15.00},{\gymId\:58,\status\:0,\time\:15,\price\:15.00},{\gymId\:58,\status\:0,\time\:16,\price\:15.00},{\gymId\:58,\status\:0,\time\:17,\price\:15.00},{\gymId\:58,\status\:0,\time\:18,\price\:15.00},{\gymId\:58,\status\:0,\time\:19,\price\:15.00},{\gymId\:58,\status\:0,\time\:20,\price\:15.00}]},{\gymId\:59,\gymName\:\外场3\,\price\:15.00,\timeList\:[{\gymId\:59,\status\:0,\time\:9,\price\:15.00},{\gymId\:59,\status\:0,\time\:10,\price\:15.00},{\gymId\:59,\status\:0,\time\:11,\price\:15.00},{\gymId\:59,\status\:0,\time\:12,\price\:15.00},{\gymId\:59,\status\:0,\time\:13,\price\:15.00},{\gymId\:59,\status\:0,\time\:14,\price\:15.00},{\gymId\:59,\status\:0,\time\:15,\price\:15.00},{\gymId\:59,\status\:0,\time\:16,\price\:15.00},{\gymId\:59,\status\:0,\time\:17,\price\:15.00},{\gymId\:59,\status\:0,\time\:18,\price\:15.00},{\gymId\:59,\status\:0,\time\:19,\price\:15.00},{\gymId\:59,\status\:0,\time\:20,\price\:15.00}]}]);
INSERT INTO g_gym_appoint VALUES (670, NULL, 4, [{\gymId\:36,\gymName\:\内场1-1\,\price\:80.00,\timeList\:[{\gymId\:36,\status\:0,\time\:9,\price\:80.00},{\gymId\:36,\status\:0,\time\:10,\price\:80.00},{\gymId\:36,\status\:0,\time\:11,\price\:80.00},{\gymId\:36,\status\:0,\time\:12,\price\:80.00},{\gymId\:36,\status\:0,\time\:13,\price\:80.00},{\gymId\:36,\status\:0,\time\:14,\price\:80.00},{\gymId\:36,\status\:0,\time\:15,\price\:80.00},{\gymId\:36,\status\:0,\time\:16,\price\:80.00},{\gymId\:36,\status\:0,\time\:17,\price\:80.00},{\gymId\:36,\status\:0,\time\:18,\price\:80.00},{\gymId\:36,\status\:0,\time\:19,\price\:80.00},{\gymId\:36,\status\:0,\time\:20,\price\:80.00}]},{\gymId\:37,\gymName\:\内场1-2\,\price\:80.00,\timeList\:[{\gymId\:37,\status\:1,\time\:9,\price\:80.00},{\gymId\:37,\status\:1,\time\:10,\price\:80.00},{\gymId\:37,\status\:1,\time\:11,\price\:80.00},{\gymId\:37,\status\:1,\time\:12,\price\:80.00},{\gymId\:37,\status\:1,\time\:13,\price\:80.00},{\gymId\:37,\status\:1,\time\:14,\price\:80.00},{\gymId\:37,\status\:1,\time\:15,\price\:80.00},{\gymId\:37,\status\:1,\time\:16,\price\:80.00},{\gymId\:37,\status\:1,\time\:17,\price\:80.00},{\gymId\:37,\status\:1,\time\:18,\price\:80.00},{\gymId\:37,\status\:1,\time\:19,\price\:80.00},{\gymId\:37,\status\:1,\time\:20,\price\:80.00}]}]);
INSERT INTO g_gym_appoint VALUES (671, 2024-03-19 00:00:00, 3, [{\gymId\:35,\gymName\:\三人制\,\price\:80.00,\timeList\:[{\gymId\:35,\status\:1,\time\:9,\price\:80.00},{\gymId\:35,\status\:1,\time\:10,\price\:80.00},{\gymId\:35,\status\:1,\time\:11,\price\:80.00},{\gymId\:35,\status\:1,\time\:12,\price\:80.00},{\gymId\:35,\status\:1,\time\:13,\price\:80.00},{\gymId\:35,\status\:1,\time\:14,\price\:80.00},{\gymId\:35,\status\:1,\time\:15,\price\:80.00},{\gymId\:35,\status\:1,\time\:16,\price\:80.00},{\gymId\:35,\status\:1,\time\:17,\price\:80.00},{\gymId\:35,\status\:1,\time\:18,\price\:80.00},{\gymId\:35,\status\:1,\time\:19,\price\:80.00},{\gymId\:35,\status\:1,\time\:20,\price\:80.00}]},{\gymId\:34,\gymName\:\五人制\,\price\:90.00,\timeList\:[{\gymId\:34,\status\:1,\time\:9,\price\:90.00},{\gymId\:34,\status\:1,\time\:10,\price\:90.00},{\gymId\:34,\status\:1,\time\:11,\price\:90.00},{\gymId\:34,\status\:1,\time\:12,\price\:90.00},{\gymId\:34,\status\:1,\time\:13,\price\:90.00},{\gymId\:34,\status\:1,\time\:14,\price\:90.00},{\gymId\:34,\status\:1,\time\:15,\price\:90.00},{\gymId\:34,\status\:2,\time\:16,\price\:90.00},{\gymId\:34,\status\:1,\time\:17,\price\:90.00},{\gymId\:34,\status\:1,\time\:18,\price\:90.00},{\gymId\:34,\status\:1,\time\:19,\price\:90.00},{\gymId\:34,\status\:1,\time\:20,\price\:90.00}]}]);
INSERT INTO g_gym_appoint VALUES (672, 2024-03-19 00:00:00, 4, [{\gymId\:36,\gymName\:\内场1-1\,\price\:80.00,\timeList\:[{\gymId\:36,\status\:0,\time\:9,\price\:80.00},{\gymId\:36,\status\:0,\time\:10,\price\:80.00},{\gymId\:36,\status\:0,\time\:11,\price\:80.00},{\gymId\:36,\status\:0,\time\:12,\price\:80.00},{\gymId\:36,\status\:0,\time\:13,\price\:80.00},{\gymId\:36,\status\:0,\time\:14,\price\:80.00},{\gymId\:36,\status\:0,\time\:15,\price\:80.00},{\gymId\:36,\status\:0,\time\:16,\price\:80.00},{\gymId\:36,\status\:0,\time\:17,\price\:80.00},{\gymId\:36,\status\:0,\time\:18,\price\:80.00},{\gymId\:36,\status\:0,\time\:19,\price\:80.00},{\gymId\:36,\status\:0,\time\:20,\price\:80.00}]},{\gymId\:37,\gymName\:\内场1-2\,\price\:80.00,\timeList\:[{\gymId\:37,\status\:1,\time\:9,\price\:80.00},{\gymId\:37,\status\:1,\time\:10,\price\:80.00},{\gymId\:37,\status\:1,\time\:11,\price\:80.00},{\gymId\:37,\status\:1,\time\:12,\price\:80.00},{\gymId\:37,\status\:1,\time\:13,\price\:80.00},{\gymId\:37,\status\:1,\time\:14,\price\:80.00},{\gymId\:37,\status\:1,\time\:15,\price\:80.00},{\gymId\:37,\status\:1,\time\:16,\price\:80.00},{\gymId\:37,\status\:1,\time\:17,\price\:80.00},{\gymId\:37,\status\:1,\time\:18,\price\:80.00},{\gymId\:37,\status\:1,\time\:19,\price\:80.00},{\gymId\:37,\status\:1,\time\:20,\price\:80.00}]}]);
INSERT INTO g_gym_appoint VALUES (673, 2024-04-22 00:00:00, 3, [{\gymId\:35,\gymName\:\三人制\,\price\:80.00,\timeList\:[{\gymId\:35,\status\:1,\time\:9,\price\:80.00},{\gymId\:35,\status\:1,\time\:10,\price\:80.00},{\gymId\:35,\status\:1,\time\:11,\price\:80.00},{\gymId\:35,\status\:1,\time\:12,\price\:80.00},{\gymId\:35,\status\:1,\time\:13,\price\:80.00},{\gymId\:35,\status\:1,\time\:14,\price\:80.00},{\gymId\:35,\status\:1,\time\:15,\price\:80.00},{\gymId\:35,\status\:1,\time\:16,\price\:80.00},{\gymId\:35,\status\:1,\time\:17,\price\:80.00},{\gymId\:35,\status\:1,\time\:18,\price\:80.00},{\gymId\:35,\status\:1,\time\:19,\price\:80.00},{\gymId\:35,\status\:1,\time\:20,\price\:80.00}]},{\gymId\:34,\gymName\:\五人制\,\price\:90.00,\timeList\:[{\gymId\:34,\status\:1,\time\:9,\price\:90.00},{\gymId\:34,\status\:1,\time\:10,\price\:90.00},{\gymId\:34,\status\:1,\time\:11,\price\:90.00},{\gymId\:34,\status\:1,\time\:12,\price\:90.00},{\gymId\:34,\status\:1,\time\:13,\price\:90.00},{\gymId\:34,\status\:1,\time\:14,\price\:90.00},{\gymId\:34,\status\:1,\time\:15,\price\:90.00},{\gymId\:34,\status\:1,\time\:16,\price\:90.00},{\gymId\:34,\status\:1,\time\:17,\price\:90.00},{\gymId\:34,\status\:1,\time\:18,\price\:90.00},{\gymId\:34,\status\:1,\time\:19,\price\:90.00},{\gymId\:34,\status\:1,\time\:20,\price\:90.00}]}]);-- ----------------------------
-- Table structure for g_gym_pic
-- ----------------------------
DROP TABLE IF EXISTS g_gym_pic;
CREATE TABLE g_gym_pic (id int(11) NOT NULL AUTO_INCREMENT,gym_id int(11) NULL DEFAULT NULL,pic_url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 场地图片 ROW_FORMAT DYNAMIC;-- ----------------------------
-- Records of g_gym_pic
-- ------------------------------ ----------------------------
-- Table structure for g_member_order
-- ----------------------------
DROP TABLE IF EXISTS g_member_order;
CREATE TABLE g_member_order (id int(11) NOT NULL AUTO_INCREMENT,member_id int(11) NULL DEFAULT NULL,order_id int(11) NULL DEFAULT NULL,PRIMARY KEY (id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 1 CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT DYNAMIC;-- ----------------------------
-- Records of g_member_order
-- ------------------------------ ----------------------------
-- Table structure for g_order
-- ----------------------------
DROP TABLE IF EXISTS g_order;
CREATE TABLE g_order (order_id int(11) NOT NULL AUTO_INCREMENT,member_id int(11) NULL DEFAULT NULL COMMENT 用户id,order_num varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 订单编号,total_amount decimal(10, 2) NULL DEFAULT NULL COMMENT 金额,order_status tinyint(2) NULL DEFAULT NULL COMMENT 状态,order_type tinyint(2) NULL DEFAULT NULL,appoint_date date NULL DEFAULT NULL COMMENT 预约日期,qr_code varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,pay_type varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 支付类型,start_time datetime NULL DEFAULT NULL COMMENT 开始时间,end_time datetime NULL DEFAULT NULL COMMENT 结束时间,form_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,store_id bigint(32) NULL DEFAULT NULL,remark varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 备注,create_time datetime NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (order_id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 1433 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 订单 ROW_FORMAT DYNAMIC;-- ----------------------------
-- Records of g_order
-- ----------------------------
INSERT INTO g_order VALUES (1425, 72, 20210814619867, 60.00, 2, 1, 2024-01-13, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2024-01-14 07:23:59);
INSERT INTO g_order VALUES (1426, 72, 20210814483941, 60.00, 2, 1, 2024-01-13, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2024-01-14 07:24:27);
INSERT INTO g_order VALUES (1427, 72, 20211128174258, 160.00, 2, 1, 2024-01-28, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2024-01-28 15:52:01);
INSERT INTO g_order VALUES (1428, 76, 20221214729815, 60.00, 3, 1, 2024-01-14, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2024-01-14 15:55:12);
INSERT INTO g_order VALUES (1429, 76, 20221220101441, 90.00, 2, 1, 2024-01-21, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2024-01-20 22:36:44);
INSERT INTO g_order VALUES (1430, 76, 20230324835162, 80.00, 2, 1, 2024-03-24, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2024-03-24 16:28:34);
INSERT INTO g_order VALUES (1431, 76, 20240302087014, 80.00, 2, 1, 2024-03-02, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2024-03-02 14:02:23);
INSERT INTO g_order VALUES (1432, 76, 20240319081917, 90.00, 2, 1, 2024-03-19, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2024-03-19 11:41:03);-- ----------------------------
-- Table structure for g_order_category
-- ----------------------------
DROP TABLE IF EXISTS g_order_category;
CREATE TABLE g_order_category (id int(11) NOT NULL AUTO_INCREMENT,order_id int(11) NULL DEFAULT NULL COMMENT 订单id,category_id int(11) NULL DEFAULT NULL COMMENT 项目id,category_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 项目名称,pic_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 图片,price decimal(10, 2) NULL DEFAULT NULL COMMENT 价格,PRIMARY KEY (id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 133 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT 订单项目 ROW_FORMAT DYNAMIC;-- ----------------------------
-- Records of g_order_category
-- ----------------------------
INSERT INTO g_order_category VALUES (125, 1425, 1, 羽毛球A, http://localhost:10001/img/icon-1.png, NULL);
INSERT INTO g_order_category VALUES (126, 1426, 1, 羽毛球A, http://localhost:10001/img/icon-1.png, NULL);
INSERT INTO g_order_category VALUES (127, 1427, 3, 足球, http://localhost:10001/img/icon-3.png, NULL);
INSERT INTO g_order_category VALUES (128, 1428, 1, 羽毛球A, http://localhost:10001/img/icon-1.png, NULL);
INSERT INTO g_order_category VALUES (129, 1429, 3, 足球, http://localhost:10001/img/icon-3.png, NULL);
INSERT INTO g_order_category VALUES (130, 1430, 4, 篮球内, http://localhost:10001/img/icon-3.png, NULL);
INSERT INTO g_order_category VALUES (131, 1431, 4, 篮球内, http://localhost:10001/img/icon-3.png, NULL);
INSERT INTO g_order_category VALUES (132, 1432, 3, 足球, http://localhost:10001/fileupload/20240319/bd66b0e4-39a9-4017-abaf-3fbead3f79e0.jpg, NULL);-- ----------------------------
-- Table structure for g_order_evaluation
-- ----------------------------
DROP TABLE IF EXISTS g_order_evaluation;
CREATE TABLE g_order_evaluation (id int(11) NOT NULL AUTO_INCREMENT,order_id int(11) NOT NULL COMMENT 订单id,user_id int(11) NULL DEFAULT NULL COMMENT 用户id,category_id int(11) NULL DEFAULT NULL COMMENT 项目id,star int(11) NULL DEFAULT NULL COMMENT 评分,content varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 评价内容,create_time datetime NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 6 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 订单评价 ROW_FORMAT DYNAMIC;-- ----------------------------
-- Records of g_order_evaluation
-- ----------------------------
INSERT INTO g_order_evaluation VALUES (1, 1431, 76, 4, 4, 444, 2024-03-02 15:04:08);
INSERT INTO g_order_evaluation VALUES (2, 1431, 76, 4, 3, 5555, 2024-03-02 15:05:11);
INSERT INTO g_order_evaluation VALUES (3, 1431, 76, 4, 5, 555, 2024-03-02 15:06:47);
INSERT INTO g_order_evaluation VALUES (4, 1431, 76, 4, 5, 444, 2024-03-02 15:10:50);
INSERT INTO g_order_evaluation VALUES (5, 1431, 76, 4, 4, 666, 2024-03-02 15:11:16);-- ----------------------------
-- Table structure for g_order_gym
-- ----------------------------
DROP TABLE IF EXISTS g_order_gym;
CREATE TABLE g_order_gym (id int(11) NOT NULL AUTO_INCREMENT,order_id int(11) NULL DEFAULT NULL COMMENT 订单id,gym_id int(11) NULL DEFAULT NULL COMMENT 场地id,gym_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 场地名称,buy_num int(11) NULL DEFAULT NULL,pic_url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 图片,price decimal(10, 2) NULL DEFAULT NULL COMMENT 价格,appoint_hour int(11) NULL DEFAULT NULL COMMENT 预约时间,appoint_date date NULL DEFAULT NULL COMMENT 预约日期,PRIMARY KEY (id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 218 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 订单场地 ROW_FORMAT DYNAMIC;-- ----------------------------
-- Records of g_order_gym
-- ----------------------------
INSERT INTO g_order_gym VALUES (206, 1425, 23, 内场A1, NULL, NULL, 30.00, 15, 2024-01-13);
INSERT INTO g_order_gym VALUES (207, 1425, 23, 内场A1, NULL, NULL, 30.00, 16, 2024-01-13);
INSERT INTO g_order_gym VALUES (208, 1426, 23, 内场A1, NULL, NULL, 30.00, 15, 2024-01-13);
INSERT INTO g_order_gym VALUES (209, 1426, 23, 内场A1, NULL, NULL, 30.00, 16, 2024-01-13);
INSERT INTO g_order_gym VALUES (210, 1427, 35, 三人制, NULL, NULL, 80.00, 9, 2024-01-28);
INSERT INTO g_order_gym VALUES (211, 1427, 35, 三人制, NULL, NULL, 80.00, 10, 2024-01-28);
INSERT INTO g_order_gym VALUES (212, 1428, 21, 内场A3, NULL, NULL, 30.00, 18, 2024-01-14);
INSERT INTO g_order_gym VALUES (213, 1428, 21, 内场A3, NULL, NULL, 30.00, 17, 2024-01-14);
INSERT INTO g_order_gym VALUES (214, 1429, 34, 五人制, NULL, NULL, 90.00, 13, 2024-01-21);
INSERT INTO g_order_gym VALUES (215, 1430, 37, 内场1-2, NULL, NULL, 80.00, 17, 2024-03-24);
INSERT INTO g_order_gym VALUES (216, 1431, 37, 内场1-2, NULL, NULL, 80.00, 17, 2024-03-02);
INSERT INTO g_order_gym VALUES (217, 1432, 34, 五人制, NULL, NULL, 90.00, 16, 2024-03-19);-- ----------------------------
-- Table structure for sys_store
-- ----------------------------
DROP TABLE IF EXISTS sys_store;
CREATE TABLE sys_store (id bigint(32) NOT NULL AUTO_INCREMENT,name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 名称,user_id bigint(20) NOT NULL,phone varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 联系电话,logo varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT logo,address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 地址,profile text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,business_hours varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,latitude double NULL DEFAULT NULL,longitude double NULL DEFAULT NULL,notice varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,tag varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,create_time datetime NULL DEFAULT NULL,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX sys_store_id_uindex(id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 2 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 场馆 ROW_FORMAT DYNAMIC;-- ----------------------------
-- Records of sys_store
-- ----------------------------
INSERT INTO sys_store VALUES (1, 足球场, 1, 18112907714, http://localhost:10001/img/store.jpg, 济南, , 9:00-21:00, 31.977554, 118.804093, NULL, WIFI;停车;热水沐浴;器材租赁;休息区;简餐;体育用品, 2018-03-24 22:28:21);-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (id bigint(20) NOT NULL AUTO_INCREMENT,username varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 用户名,password varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 密码,email varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 邮箱,mobile varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 手机号,status tinyint(4) NULL DEFAULT NULL COMMENT 状态 0禁用 1正常,create_time datetime NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id) USING BTREE,UNIQUE INDEX username(username) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 管理员 ROW_FORMAT DYNAMIC;-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO sys_user VALUES (1, admin, 21232f297a57a5a743894a0e4a801fc3, 2803180149qq.com, 18021418906, 1, 2024-01-14 11:11:11);
INSERT INTO sys_user VALUES (3, test, e10adc3949ba59abbe56e057f20f883e, NULL, NULL, 1, 2024-01-04 16:33:07);SET FOREIGN_KEY_CHECKS 1;文章下方名片联系我即可~ 大家点赞、收藏、关注、评论啦 、查看获取联系方式