基于springboot的健身房会员课程论坛管理系统(mysql)-JAVA.VUE【数据库设计、论文、源码、开题报告】

最新推荐文章于 2023-04-11 08:45:00 发布
浪工程序设计合作
最新推荐文章于 2023-04-11 08:45:00 发布
阅读量322
点赞数
分类专栏： Java项目实战文章标签： java 数据库 spring boot
本文链接：https://blog.csdn.net/laowang8/article/details/129332910
版权
Java项目实战专栏收录该内容
374 篇文章 54 订阅
订阅专栏
功能介绍

本系统用户角色有：管理员、店长、教练、学员
用户端功能有：首页、课程信息、公告信息、论坛、商品信息、个人中心、后台管理等
管理端功能有：个人信息管理、店长管理、基础数据管理、教练管理、论坛管理、课程管理、公告管理等
更多功能请看运行截图！
使用技术

开发语言：Java
使用框架：spring boot
前端技术：JavaScript、VUE.js（2.X）、css3
数据库：MySQL 5.7
数据库管理工具：Navicat或sqlyog
开发工具：IDEA或Eclipse均可
数据库脚本


/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - jianshenfanghuiyuan
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`jianshenfanghuiyuan` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `jianshenfanghuiyuan`;

/*Table structure for table `config` */

DROP TABLE IF EXISTS `config`;

CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';

/*Data for the table `config` */

insert  into `config`(`id`,`name`,`value`) values (1,'轮播图1','http://localhost:8080/jianshenfanghuiyuan/upload/config1.jpg'),(2,'轮播图2','http://localhost:8080/jianshenfanghuiyuan/upload/config2.jpg'),(3,'轮播图3','http://localhost:8080/jianshenfanghuiyuan/upload/config3.jpg');

/*Table structure for table `dianzhang` */

DROP TABLE IF EXISTS `dianzhang`;

CREATE TABLE `dianzhang` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) DEFAULT NULL COMMENT '账户',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `dianzhang_name` varchar(200) DEFAULT NULL COMMENT '店长姓名 Search111 ',
  `dianzhang_photo` varchar(255) DEFAULT NULL COMMENT '头像',
  `sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111 ',
  `dianzhang_phone` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `yonghu_email` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `yonghu_delete` int(11) DEFAULT '1' COMMENT '假删',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='店长';

/*Data for the table `dianzhang` */

insert  into `dianzhang`(`id`,`username`,`password`,`dianzhang_name`,`dianzhang_photo`,`sex_types`,`dianzhang_phone`,`yonghu_email`,`yonghu_delete`,`create_time`) values (1,'a1','123456','店长姓名1','http://localhost:8080/jianshenfanghuiyuan/upload/dianzhang1.jpg',1,'17703786901','1@qq.com',119,'2022-03-22 11:05:40'),(2,'a2','123456','店长姓名2','http://localhost:8080/jianshenfanghuiyuan/upload/dianzhang2.jpg',2,'17703786902','2@qq.com',408,'2022-03-22 11:05:40'),(3,'a3','123456','店长姓名3','http://localhost:8080/jianshenfanghuiyuan/upload/dianzhang3.jpg',2,'17703786903','3@qq.com',405,'2022-03-22 11:05:40');

/*Table structure for table `dictionary` */

DROP TABLE IF EXISTS `dictionary`;

CREATE TABLE `dictionary` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dic_code` varchar(200) DEFAULT NULL COMMENT '字段',
  `dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',
  `code_index` int(11) DEFAULT NULL COMMENT '编码',
  `index_name` varchar(200) DEFAULT NULL COMMENT '编码名字  Search111 ',
  `super_id` int(11) DEFAULT NULL COMMENT '父字段id',
  `beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='字典表';

/*Data for the table `dictionary` */

insert  into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`beizhu`,`create_time`) values (1,'shangxia_types','上下架',1,'上架',NULL,NULL,'2022-03-22 11:05:11'),(2,'shangxia_types','上下架',2,'下架',NULL,NULL,'2022-03-22 11:05:11'),(3,'shangpin_types','商品类型',1,'商品类型1',NULL,NULL,'2022-03-22 11:05:11'),(4,'shangpin_types','商品类型',2,'商品类型2',NULL,NULL,'2022-03-22 11:05:11'),(5,'shangpin_types','商品类型',3,'商品类型3',NULL,NULL,'2022-03-22 11:05:11'),(6,'kecheng_types','课程类型',1,'课程类型1',NULL,NULL,'2022-03-22 11:05:11'),(7,'kecheng_types','课程类型',2,'课程类型2',NULL,NULL,'2022-03-22 11:05:11'),(8,'kecheng_types','课程类型',3,'课程类型3',NULL,NULL,'2022-03-22 11:05:11'),(12,'news_types','公告类型',1,'公告类型1',NULL,NULL,'2022-03-22 11:05:12'),(13,'news_types','公告类型',2,'公告类型2',NULL,NULL,'2022-03-22 11:05:12'),(14,'news_types','公告类型',3,'公告类型3',NULL,NULL,'2022-03-22 11:05:12'),(15,'sex_types','性别',1,'男',NULL,NULL,'2022-03-22 11:05:12'),(16,'sex_types','性别',2,'女',NULL,NULL,'2022-03-22 11:05:12'),(17,'huanyuan_types','会员类型',1,'普通会员',NULL,NULL,'2022-03-22 11:05:12'),(18,'huanyuan_types','会员类型',2,'年费会员',NULL,NULL,'2022-03-22 11:05:12'),(19,'forum_state_types','帖子状态',1,'发帖',NULL,NULL,'2022-03-22 11:05:12'),(20,'forum_state_types','帖子状态',2,'回帖',NULL,NULL,'2022-03-22 11:05:12'),(21,'kecheng_order_types','订单类型',1,'已评价',NULL,NULL,'2022-03-22 14:05:06'),(22,'kecheng_order_types','订单类型',2,'退款',NULL,NULL,'2022-03-22 14:05:07'),(25,'kecheng_order_types','订单类型',3,'已支付',NULL,NULL,'2022-03-22 14:05:07');

/*Table structure for table `forum` */

DROP TABLE IF EXISTS `forum`;

CREATE TABLE `forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `forum_name` varchar(200) DEFAULT NULL COMMENT '帖子标题  Search111 ',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `jiaolian_id` int(11) DEFAULT NULL COMMENT '教练',
  `dianzhang_id` int(11) DEFAULT NULL COMMENT '店长',
  `users_id` int(11) DEFAULT NULL COMMENT '管理员',
  `forum_content` text COMMENT '发布内容',
  `super_ids` int(11) DEFAULT NULL COMMENT '父id',
  `forum_state_types` int(11) DEFAULT NULL COMMENT '帖子状态',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '发帖时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='论坛';

/*Data for the table `forum` */

insert  into `forum`(`id`,`forum_name`,`yonghu_id`,`jiaolian_id`,`dianzhang_id`,`users_id`,`forum_content`,`super_ids`,`forum_state_types`,`insert_time`,`update_time`,`create_time`) values (1,'帖子标题1',2,NULL,NULL,NULL,'发布内容1',NULL,1,'2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(2,'帖子标题2',1,NULL,NULL,NULL,'发布内容2',NULL,1,'2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(3,'帖子标题3',2,NULL,NULL,NULL,'发布内容3',NULL,1,'2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(4,'帖子标题4',2,NULL,NULL,NULL,'发布内容4',NULL,1,'2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(5,'帖子标题5',3,NULL,NULL,NULL,'发布内容5',NULL,1,'2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(6,NULL,1,NULL,NULL,NULL,'用户回复',5,2,'2022-03-22 14:48:46',NULL,'2022-03-22 14:48:46'),(9,NULL,NULL,1,NULL,NULL,'教练回复',5,2,'2022-03-22 15:01:40',NULL,'2022-03-22 15:01:40'),(10,NULL,NULL,NULL,1,NULL,'店长回复',5,2,'2022-03-22 15:02:17',NULL,'2022-03-22 15:02:17'),(11,NULL,NULL,NULL,NULL,1,'管理回复',5,2,'2022-03-22 15:07:22',NULL,'2022-03-22 15:07:22');

/*Table structure for table `jiaolian` */

DROP TABLE IF EXISTS `jiaolian`;

CREATE TABLE `jiaolian` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) DEFAULT NULL COMMENT '账户',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `jiaolian_name` varchar(200) DEFAULT NULL COMMENT '教练姓名 Search111 ',
  `jiaolian_photo` varchar(255) DEFAULT NULL COMMENT '头像',
  `sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111 ',
  `jiaolian_phone` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `yonghu_email` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `yonghu_delete` int(11) DEFAULT '1' COMMENT '假删',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='教练';

/*Data for the table `jiaolian` */

insert  into `jiaolian`(`id`,`username`,`password`,`jiaolian_name`,`jiaolian_photo`,`sex_types`,`jiaolian_phone`,`yonghu_email`,`yonghu_delete`,`create_time`) values (1,'a1','123456','教练姓名1','http://localhost:8080/jianshenfanghuiyuan/upload/jiaolian1.jpg',1,'17703786901','1@qq.com',350,'2022-03-22 11:05:40'),(2,'a2','123456','教练姓名2','http://localhost:8080/jianshenfanghuiyuan/upload/jiaolian2.jpg',1,'17703786902','2@qq.com',394,'2022-03-22 11:05:40'),(3,'a3','123456','教练姓名3','http://localhost:8080/jianshenfanghuiyuan/upload/jiaolian3.jpg',1,'17703786903','3@qq.com',487,'2022-03-22 11:05:40');

/*Table structure for table `kecheng` */

DROP TABLE IF EXISTS `kecheng`;

CREATE TABLE `kecheng` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
  `jiaolian_id` int(11) DEFAULT NULL COMMENT '教练',
  `kecheng_name` varchar(200) DEFAULT NULL COMMENT '课程名称  Search111 ',
  `kecheng_photo` varchar(200) DEFAULT NULL COMMENT '课程封面',
  `kecheng_price` int(11) DEFAULT NULL COMMENT '购买获得积分 ',
  `kecheng_types` int(11) DEFAULT NULL COMMENT '课程类型 Search111',
  `kecheng_kucun_number` int(11) DEFAULT NULL COMMENT '可预约人数',
  `kecheng_new_money` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `kecheng_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `kecheng_content` text COMMENT '课程简介 ',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show1 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='课程信息';

/*Data for the table `kecheng` */

insert  into `kecheng`(`id`,`jiaolian_id`,`kecheng_name`,`kecheng_photo`,`kecheng_price`,`kecheng_types`,`kecheng_kucun_number`,`kecheng_new_money`,`kecheng_delete`,`kecheng_content`,`create_time`) values (1,1,'课程名称1','http://localhost:8080/jianshenfanghuiyuan/upload/kecheng1.jpg',466,2,101,'271.75',1,'课程简介1','2022-03-22 11:05:40'),(2,2,'课程名称2','http://localhost:8080/jianshenfanghuiyuan/upload/kecheng2.jpg',250,2,102,'181.13',1,'课程简介2','2022-03-22 11:05:40'),(3,3,'课程名称3','http://localhost:8080/jianshenfanghuiyuan/upload/kecheng3.jpg',213,1,103,'181.65',1,'课程简介3','2022-03-22 11:05:40'),(4,1,'课程名称4','http://localhost:8080/jianshenfanghuiyuan/upload/kecheng4.jpg',337,1,102,'368.93',1,'<p>课程简介4</p>','2022-03-22 11:05:40'),(5,2,'课程名称5','http://localhost:8080/jianshenfanghuiyuan/upload/kecheng5.jpg',3,1,105,'460.08',1,'<p>课程简介5</p>','2022-03-22 11:05:40');

/*Table structure for table `kecheng_commentback` */

DROP TABLE IF EXISTS `kecheng_commentback`;

CREATE TABLE `kecheng_commentback` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `kecheng_id` int(11) DEFAULT NULL COMMENT '课程',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `kecheng_commentback_text` text COMMENT '评价内容',
  `reply_text` text COMMENT '回复内容',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '评价时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='课程评价';

/*Data for the table `kecheng_commentback` */

insert  into `kecheng_commentback`(`id`,`kecheng_id`,`yonghu_id`,`kecheng_commentback_text`,`reply_text`,`insert_time`,`update_time`,`create_time`) values (1,1,3,'评价内容1','回复信息1','2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(2,2,2,'评价内容2','回复信息2','2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(3,3,2,'评价内容3','回复信息3','2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(4,4,1,'评价内容4','回复信息4','2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(5,5,3,'评价内容5','回复信息5','2022-03-22 11:05:40','2022-03-22 11:05:40','2022-03-22 11:05:40'),(6,4,1,'112233','教练可以回复','2022-03-22 14:27:21','2022-03-22 15:01:59','2022-03-22 14:27:21');

/*Table structure for table `kecheng_order` */

DROP TABLE IF EXISTS `kecheng_order`;

CREATE TABLE `kecheng_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `kecheng_order_uuid_number` varchar(200) DEFAULT NULL COMMENT '订单号',
  `kecheng_id` int(11) DEFAULT NULL COMMENT '课程',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `buy_number` int(11) DEFAULT NULL COMMENT '预定数量',
  `kecheng_order_types` int(11) DEFAULT NULL COMMENT '订单类型',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '订单创建时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='课程订单';

/*Data for the table `kecheng_order` */

insert  into `kecheng_order`(`id`,`kecheng_order_uuid_number`,`kecheng_id`,`yonghu_id`,`buy_number`,`kecheng_order_types`,`insert_time`,`create_time`) values (1,'1647929843408',4,1,2,1,'2022-03-22 14:17:23','2022-03-22 14:17:23'),(2,'1647931708037',3,1,1,2,'2022-03-22 14:48:28','2022-03-22 14:48:28');

/*Table structure for table `news` */

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `news_name` varchar(200) DEFAULT NULL COMMENT '公告标题  Search111 ',
  `news_types` int(11) DEFAULT NULL COMMENT '公告类型  Search111 ',
  `news_photo` varchar(200) DEFAULT NULL COMMENT '公告图片',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '公告时间',
  `news_content` text COMMENT '公告详情',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='公告信息';

/*Data for the table `news` */

insert  into `news`(`id`,`news_name`,`news_types`,`news_photo`,`insert_time`,`news_content`,`create_time`) values (1,'公告标题1',1,'http://localhost:8080/jianshenfanghuiyuan/upload/news1.jpg','2022-03-22 11:05:40','公告详情1','2022-03-22 11:05:40'),(2,'公告标题2',3,'http://localhost:8080/jianshenfanghuiyuan/upload/news2.jpg','2022-03-22 11:05:40','公告详情2','2022-03-22 11:05:40'),(3,'公告标题3',2,'http://localhost:8080/jianshenfanghuiyuan/upload/news3.jpg','2022-03-22 11:05:40','公告详情3','2022-03-22 11:05:40'),(4,'公告标题4',3,'http://localhost:8080/jianshenfanghuiyuan/upload/news4.jpg','2022-03-22 11:05:40','公告详情4','2022-03-22 11:05:40'),(5,'公告标题5',1,'http://localhost:8080/jianshenfanghuiyuan/upload/news5.jpg','2022-03-22 11:05:40','公告详情5','2022-03-22 11:05:40');

/*Table structure for table `shangpin` */

DROP TABLE IF EXISTS `shangpin`;

CREATE TABLE `shangpin` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
  `shangpin_name` varchar(200) DEFAULT NULL COMMENT '商品名称  Search111 ',
  `shangpin_photo` varchar(200) DEFAULT NULL COMMENT '商品照片',
  `shangpin_types` int(11) DEFAULT NULL COMMENT '商品类型 Search111',
  `shangpin_kucun_number` int(11) DEFAULT NULL COMMENT '商品库存',
  `shangpin_new_money` decimal(10,2) DEFAULT NULL COMMENT '积分 ',
  `shangpin_duihuannum` int(11) DEFAULT NULL COMMENT '兑换次数 ',
  `shangxia_types` int(11) DEFAULT NULL COMMENT '是否上架 ',
  `shangpin_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `shangpin_content` text COMMENT '商品简介 ',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show1 show2 photoShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='商品';

/*Data for the table `shangpin` */

insert  into `shangpin`(`id`,`shangpin_name`,`shangpin_photo`,`shangpin_types`,`shangpin_kucun_number`,`shangpin_new_money`,`shangpin_duihuannum`,`shangxia_types`,`shangpin_delete`,`shangpin_content`,`create_time`) values (1,'商品名称1','http://localhost:8080/jianshenfanghuiyuan/upload/shangpin1.jpg',2,101,'260.92',241,1,1,'商品简介1','2022-03-22 11:05:40'),(2,'商品名称2','http://localhost:8080/jianshenfanghuiyuan/upload/shangpin2.jpg',1,102,'238.63',276,1,1,'商品简介2','2022-03-22 11:05:40'),(3,'商品名称3','http://localhost:8080/jianshenfanghuiyuan/upload/shangpin3.jpg',1,102,'438.96',160,1,1,'商品简介3','2022-03-22 11:05:40'),(4,'商品名称4','http://localhost:8080/jianshenfanghuiyuan/upload/shangpin4.jpg',2,103,'429.09',257,1,1,'商品简介4','2022-03-22 11:05:40'),(5,'商品名称5','http://localhost:8080/jianshenfanghuiyuan/upload/shangpin5.jpg',1,105,'483.20',261,1,1,'商品简介5','2022-03-22 11:05:40');

/*Table structure for table `shangpin_order` */

DROP TABLE IF EXISTS `shangpin_order`;

CREATE TABLE `shangpin_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `shangpin_order_uuid_number` varchar(200) DEFAULT NULL COMMENT '编号',
  `shangpin_id` int(11) DEFAULT NULL COMMENT '商品',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `buy_number` int(11) DEFAULT NULL COMMENT '兑换数量',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '订单创建时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='商品兑换记录';

/*Data for the table `shangpin_order` */

insert  into `shangpin_order`(`id`,`shangpin_order_uuid_number`,`shangpin_id`,`yonghu_id`,`buy_number`,`insert_time`,`create_time`) values (1,'1647930496101',4,1,1,'2022-03-22 14:28:16','2022-03-22 14:28:16'),(2,'1647931675376',3,1,1,'2022-03-22 14:47:55','2022-03-22 14:47:55');

/*Table structure for table `token` */

DROP TABLE IF EXISTS `token`;

CREATE TABLE `token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='token表';

/*Data for the table `token` */

insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,1,'admin','users','管理员','g1w1mkw0w00n1gyul6a0lvdih6r4rdxn','2022-03-22 11:14:58','2022-03-25 14:14:15'),(2,1,'a1','yonghu','用户','h2g3nwpy2upfdj2djlodjzezib3kngvx','2022-03-22 11:33:26','2022-04-02 12:14:00'),(3,2,'a2','yonghu','用户','5gqacaw9gavjgbt1gkxfn6hww15oibda','2022-03-22 14:44:19','2022-03-22 15:44:20'),(4,1,'a1','dianzhang','店长','h0k8t2pj47cdcd5b2n1kmrc9yv9tuuwo','2022-03-22 14:44:30','2022-03-25 14:14:03'),(5,1,'a1','jiaolian','教练','p3si3y0vd4312cgzyhkh01w6ahgfr6th','2022-03-22 14:45:49','2022-03-22 16:01:10'),(6,4,'a4','yonghu','用户','ge3p3wv7cf99j3m4q2ow6dav63io8xv2','2022-03-25 13:12:21','2022-03-25 14:16:14');

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

/*Data for the table `users` */

insert  into `users`(`id`,`username`,`password`,`role`,`addtime`) values (1,'admin','admin','管理员','2022-05-01 00:00:00');

/*Table structure for table `yonghu` */

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(200) DEFAULT NULL COMMENT '账户',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `yonghu_name` varchar(200) DEFAULT NULL COMMENT '用户姓名 Search111 ',
  `yonghu_photo` varchar(255) DEFAULT NULL COMMENT '头像',
  `sex_types` int(11) DEFAULT NULL COMMENT '性别 Search111 ',
  `yonghu_phone` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `yonghu_id_number` varchar(200) DEFAULT NULL COMMENT '身份证号 ',
  `yonghu_email` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `new_money` decimal(10,2) DEFAULT NULL COMMENT '余额 ',
  `yonghu_jifen` decimal(10,2) DEFAULT NULL COMMENT '现积分',
  `huanyuan_types` int(11) DEFAULT NULL COMMENT '会员类型 Search111',
  `huiyuandaoqi_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '会员到期时间',
  `yonghu_delete` int(11) DEFAULT '1' COMMENT '假删',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='用户';

/*Data for the table `yonghu` */

insert  into `yonghu`(`id`,`username`,`password`,`yonghu_name`,`yonghu_photo`,`sex_types`,`yonghu_phone`,`yonghu_id_number`,`yonghu_email`,`new_money`,`yonghu_jifen`,`huanyuan_types`,`huiyuandaoqi_time`,`yonghu_delete`,`create_time`) values (1,'a1','123456','用户姓名1','http://localhost:8080/jianshenfanghuiyuan/upload/yonghu1.jpg',2,'17703786901','410224199610232001','1@qq.com','1246.83','227.71',2,'2030-03-22 13:47:57',1,'2022-03-22 11:05:40'),(2,'a2','123456','用户姓名2','http://localhost:8080/jianshenfanghuiyuan/upload/yonghu2.jpg',2,'17703786902','410224199610232002','2@qq.com','62.06','42.42',1,NULL,1,'2022-03-22 11:05:40'),(3,'a3','123456','用户姓名3','http://localhost:8080/jianshenfanghuiyuan/upload/yonghu3.jpg',2,'17703786903','410224199610232003','3@qq.com','977.43','954.74',2,'2023-03-22 13:15:50',1,'2022-03-22 11:05:40'),(5,'a4','123456','123',NULL,2,'13311441211','432113198711231211','123@11.com','0.00','0.00',1,NULL,1,'2022-03-25 13:24:08');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
项目截图

在这里插入图片描述
浪工程序设计合作
关注
0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
基于springboot的健身房会员课程论坛管理系统(mysql)-JAVA.VUE【数据库设计、论文、源码、开题报告】

本系统用户角色有：管理员、店长、教练、学员用户端功能有：首页、课程信息、公告信息、论坛、商品信息、个人中心、后台管理等管理端功能有：个人信息管理、店长管理、基础数据管理、教练管理、论坛管理、课程管理、公告管理等更多功能请看运行截图！
复制链接

扫一扫