基于微信小程序的社区小区团购电商在线商城平台SSM-JAVA【数据库设计、论文、毕设源码、开题报告】

最新推荐文章于 2023-03-17 10:56:08 发布
云码资源
最新推荐文章于 2023-03-17 10:56:08 发布
阅读量291
点赞数
分类专栏：微信小程序实战项目文章标签：数据库 mysql 微信小程序
本文链接：https://blog.csdn.net/itrjxxs_2/article/details/129136575
版权
微信小程序实战项目专栏收录该内容
100 篇文章 12 订阅
订阅专栏
功能介绍

社区团购系统中的功能模块主要是实现管理员服务端；首页、个人中心、会员管理、商家管理、商品信息管理、商品分类管理、购买订单管理、退货退款管理、商品评价管理、系统管理；
商家服务端：首页、个人中心、商品信息管理、购买订单管理、退货退款管理、商品评价管理；
会员客户端：首页、商品信息、我的（会员信息、商品信息、购买订单、退货退款、商品评价、用户充值、购物车、我的订单）。
使用技术

使用框架：SSM
开发语言：Java、小程序，
前端技术：JavaScript、VUE.js（2.X）、css3
框架：ssm，JDK版本：JDK1.8 ，
服务器：tomcat9 ，
数据库：mysql 5.7，
数据库工具：Navicat11，
开发软件：eclipse/myeclipse/idea，
浏览器：谷歌浏览器，
小程序运行软件：微信开发者
项目截图

在这里插入图片描述
数据库脚本


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


/*!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*/`ssm641l4` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `ssm641l4`;

/*Table structure for table `address` */

DROP TABLE IF EXISTS `address`;

CREATE TABLE `address` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `address` varchar(200) NOT NULL COMMENT '地址',
  `name` varchar(200) NOT NULL COMMENT '收货人',
  `phone` varchar(200) NOT NULL COMMENT '电话',
  `isdefault` varchar(200) NOT NULL COMMENT '是否默认地址[是/否]',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='地址';

/*Data for the table `address` */

insert  into `address`(`id`,`addtime`,`userid`,`address`,`name`,`phone`,`isdefault`) values (1,'2022-04-03 16:44:40',1,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-04-03 16:44:40',2,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-04-03 16:44:40',3,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-04-03 16:44:40',4,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-04-03 16:44:40',5,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-04-03 16:44:40',6,'宇宙银河系月球1号','月某','13823888886','是');

/*Table structure for table `cart` */

DROP TABLE IF EXISTS `cart`;

CREATE TABLE `cart` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `tablename` varchar(200) DEFAULT 'shangpinxinxi' COMMENT '商品表名',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `goodid` bigint(20) NOT NULL COMMENT '商品id',
  `goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `picture` varchar(200) DEFAULT NULL COMMENT '图片',
  `buynumber` int(11) NOT NULL COMMENT '购买数量',
  `price` float DEFAULT NULL COMMENT '单价',
  `discountprice` float DEFAULT NULL COMMENT '会员价',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='购物车表';

/*Data for the table `cart` */

/*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=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';

/*Data for the table `config` */

insert  into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/ssm641l4/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssm641l4/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssm641l4/upload/picture3.jpg'),(6,'homepage',NULL);

/*Table structure for table `goumaidingdan` */

DROP TABLE IF EXISTS `goumaidingdan`;

CREATE TABLE `goumaidingdan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `dingdanhao` varchar(200) DEFAULT NULL COMMENT '订单号',
  `shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `shangpintupian` varchar(200) DEFAULT NULL COMMENT '商品图片',
  `shangpinxianjia` varchar(200) DEFAULT NULL COMMENT '商品现价',
  `goumaishijian` datetime DEFAULT NULL COMMENT '购买时间',
  `huiyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '会员账号',
  `huiyuanxingming` varchar(200) DEFAULT NULL COMMENT '会员姓名',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `ziqushijian` datetime DEFAULT NULL COMMENT '自取时间',
  `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  `longitude` float DEFAULT NULL COMMENT '经度',
  `latitude` float DEFAULT NULL COMMENT '纬度',
  `fulladdress` varchar(200) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dingdanhao` (`dingdanhao`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='购买订单';

/*Data for the table `goumaidingdan` */

insert  into `goumaidingdan`(`id`,`addtime`,`dingdanhao`,`shangpinmingcheng`,`shangpintupian`,`shangpinxianjia`,`goumaishijian`,`huiyuanzhanghao`,`huiyuanxingming`,`shouji`,`ziqushijian`,`ispay`,`clicknum`,`userid`,`longitude`,`latitude`,`fulladdress`) values (51,'2022-04-03 16:44:40','订单号1','商品名称1','http://localhost:8080/ssm641l4/upload/goumaidingdan_shangpintupian1.jpg','商品现价1','2022-04-03 16:44:40','会员账号1','会员姓名1','手机1','2022-04-03 16:44:40','未支付',1,1,1,1,'宇宙银河系地球1号'),(52,'2022-04-03 16:44:40','订单号2','商品名称2','http://localhost:8080/ssm641l4/upload/goumaidingdan_shangpintupian2.jpg','商品现价2','2022-04-03 16:44:40','会员账号2','会员姓名2','手机2','2022-04-03 16:44:40','未支付',2,2,2,2,'宇宙银河系地球2号'),(53,'2022-04-03 16:44:40','订单号3','商品名称3','http://localhost:8080/ssm641l4/upload/goumaidingdan_shangpintupian3.jpg','商品现价3','2022-04-03 16:44:40','会员账号3','会员姓名3','手机3','2022-04-03 16:44:40','未支付',3,3,3,3,'宇宙银河系地球3号'),(54,'2022-04-03 16:44:40','订单号4','商品名称4','http://localhost:8080/ssm641l4/upload/goumaidingdan_shangpintupian4.jpg','商品现价4','2022-04-03 16:44:40','会员账号4','会员姓名4','手机4','2022-04-03 16:44:40','未支付',4,4,4,4,'宇宙银河系地球4号'),(55,'2022-04-03 16:44:40','订单号5','商品名称5','http://localhost:8080/ssm641l4/upload/goumaidingdan_shangpintupian5.jpg','商品现价5','2022-04-03 16:44:40','会员账号5','会员姓名5','手机5','2022-04-03 16:44:40','未支付',5,5,5,5,'宇宙银河系地球5号'),(56,'2022-04-03 16:44:40','订单号6','商品名称6','http://localhost:8080/ssm641l4/upload/goumaidingdan_shangpintupian6.jpg','商品现价6','2022-04-03 16:44:40','会员账号6','会员姓名6','手机6','2022-04-03 16:44:40','未支付',6,6,6,6,'宇宙银河系地球6号');

/*Table structure for table `huiyuan` */

DROP TABLE IF EXISTS `huiyuan`;

CREATE TABLE `huiyuan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `huiyuanzhanghao` varchar(200) NOT NULL COMMENT '会员账号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `huiyuanxingming` varchar(200) DEFAULT NULL COMMENT '会员姓名',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  `jifen` float DEFAULT '0' COMMENT '积分',
  `money` float DEFAULT '0' COMMENT '余额',
  PRIMARY KEY (`id`),
  UNIQUE KEY `huiyuanzhanghao` (`huiyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='会员';

/*Data for the table `huiyuan` */

insert  into `huiyuan`(`id`,`addtime`,`huiyuanzhanghao`,`mima`,`huiyuanxingming`,`shouji`,`youxiang`,`shenfenzheng`,`touxiang`,`jifen`,`money`) values (11,'2022-04-03 16:44:40','会员1','123456','会员姓名1','13823888881','773890001@qq.com','440300199101010001','http://localhost:8080/ssm641l4/upload/huiyuan_touxiang1.jpg',10000,100),(12,'2022-04-03 16:44:40','会员2','123456','会员姓名2','13823888882','773890002@qq.com','440300199202020002','http://localhost:8080/ssm641l4/upload/huiyuan_touxiang2.jpg',10000,100),(13,'2022-04-03 16:44:40','会员3','123456','会员姓名3','13823888883','773890003@qq.com','440300199303030003','http://localhost:8080/ssm641l4/upload/huiyuan_touxiang3.jpg',10000,100),(14,'2022-04-03 16:44:40','会员4','123456','会员姓名4','13823888884','773890004@qq.com','440300199404040004','http://localhost:8080/ssm641l4/upload/huiyuan_touxiang4.jpg',10000,100),(15,'2022-04-03 16:44:40','会员5','123456','会员姓名5','13823888885','773890005@qq.com','440300199505050005','http://localhost:8080/ssm641l4/upload/huiyuan_touxiang5.jpg',10000,100),(16,'2022-04-03 16:44:40','会员6','123456','会员姓名6','13823888886','773890006@qq.com','440300199606060006','http://localhost:8080/ssm641l4/upload/huiyuan_touxiang6.jpg',10000,100);

/*Table structure for table `orders` */

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `orderid` varchar(200) NOT NULL COMMENT '订单编号',
  `tablename` varchar(200) DEFAULT 'shangpinxinxi' COMMENT '商品表名',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `goodid` bigint(20) NOT NULL COMMENT '商品id',
  `goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `picture` varchar(200) DEFAULT NULL COMMENT '商品图片',
  `buynumber` int(11) NOT NULL COMMENT '购买数量',
  `price` float NOT NULL DEFAULT '0' COMMENT '价格/积分',
  `discountprice` float DEFAULT '0' COMMENT '折扣价格',
  `total` float NOT NULL DEFAULT '0' COMMENT '总价格/总积分',
  `discounttotal` float DEFAULT '0' COMMENT '折扣总价格',
  `type` int(11) DEFAULT '1' COMMENT '支付类型',
  `status` varchar(200) DEFAULT NULL COMMENT '状态',
  `address` varchar(200) DEFAULT NULL COMMENT '地址',
  `tel` varchar(200) DEFAULT NULL COMMENT '电话',
  `consignee` varchar(200) DEFAULT NULL COMMENT '收货人',
  PRIMARY KEY (`id`),
  UNIQUE KEY `orderid` (`orderid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单';

/*Data for the table `orders` */

/*Table structure for table `shangjia` */

DROP TABLE IF EXISTS `shangjia`;

CREATE TABLE `shangjia` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `shangjiazhanghao` varchar(200) DEFAULT NULL COMMENT '商家账号',
  `mima` varchar(200) DEFAULT NULL COMMENT '密码',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
  `shangpumingcheng` varchar(200) DEFAULT NULL COMMENT '商铺名称',
  `shangputupian` varchar(200) DEFAULT NULL COMMENT '商铺图片',
  `shangpudizhi` varchar(200) DEFAULT NULL COMMENT '商铺地址',
  `jingyingfanwei` varchar(200) DEFAULT NULL COMMENT '经营范围',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  `jifen` float DEFAULT '0' COMMENT '积分',
  `money` float DEFAULT '0' COMMENT '余额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='商家';

/*Data for the table `shangjia` */

insert  into `shangjia`(`id`,`addtime`,`shangjiazhanghao`,`mima`,`xingming`,`shouji`,`youxiang`,`shenfenzheng`,`shangpumingcheng`,`shangputupian`,`shangpudizhi`,`jingyingfanwei`,`sfsh`,`shhf`,`jifen`,`money`) values (21,'2022-04-03 16:44:40','商家1','123456','姓名1','13823888881','773890001@qq.com','440300199101010001','商铺名称1','http://localhost:8080/ssm641l4/upload/shangjia_shangputupian1.jpg','商铺地址1','经营范围1','是','',10000,100),(22,'2022-04-03 16:44:40','商家2','123456','姓名2','13823888882','773890002@qq.com','440300199202020002','商铺名称2','http://localhost:8080/ssm641l4/upload/shangjia_shangputupian2.jpg','商铺地址2','经营范围2','是','',10000,100),(23,'2022-04-03 16:44:40','商家3','123456','姓名3','13823888883','773890003@qq.com','440300199303030003','商铺名称3','http://localhost:8080/ssm641l4/upload/shangjia_shangputupian3.jpg','商铺地址3','经营范围3','是','',10000,100),(24,'2022-04-03 16:44:40','商家4','123456','姓名4','13823888884','773890004@qq.com','440300199404040004','商铺名称4','http://localhost:8080/ssm641l4/upload/shangjia_shangputupian4.jpg','商铺地址4','经营范围4','是','',10000,100),(25,'2022-04-03 16:44:40','商家5','123456','姓名5','13823888885','773890005@qq.com','440300199505050005','商铺名称5','http://localhost:8080/ssm641l4/upload/shangjia_shangputupian5.jpg','商铺地址5','经营范围5','是','',10000,100),(26,'2022-04-03 16:44:40','商家6','123456','姓名6','13823888886','773890006@qq.com','440300199606060006','商铺名称6','http://localhost:8080/ssm641l4/upload/shangjia_shangputupian6.jpg','商铺地址6','经营范围6','是','',10000,100);

/*Table structure for table `shangpinfenlei` */

DROP TABLE IF EXISTS `shangpinfenlei`;

CREATE TABLE `shangpinfenlei` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `shangpinleixing` varchar(200) DEFAULT NULL COMMENT '商品类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='商品分类';

/*Data for the table `shangpinfenlei` */

insert  into `shangpinfenlei`(`id`,`addtime`,`shangpinleixing`) values (41,'2022-04-03 16:44:40','商品类型1'),(42,'2022-04-03 16:44:40','商品类型2'),(43,'2022-04-03 16:44:40','商品类型3'),(44,'2022-04-03 16:44:40','商品类型4'),(45,'2022-04-03 16:44:40','商品类型5'),(46,'2022-04-03 16:44:40','商品类型6');

/*Table structure for table `shangpinpingjia` */

DROP TABLE IF EXISTS `shangpinpingjia`;

CREATE TABLE `shangpinpingjia` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `pinglunbiaoti` varchar(200) DEFAULT NULL COMMENT '评论标题',
  `shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `shangpumingcheng` varchar(200) DEFAULT NULL COMMENT '商铺名称',
  `huiyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '会员账号',
  `huiyuanxingming` varchar(200) DEFAULT NULL COMMENT '会员姓名',
  `shangpinpingjia` longtext COMMENT '商品评价',
  `shangpintupian` varchar(200) DEFAULT NULL COMMENT '商品图片',
  `shangjiahuifu` longtext COMMENT '商家回复',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='商品评价';

/*Data for the table `shangpinpingjia` */

insert  into `shangpinpingjia`(`id`,`addtime`,`pinglunbiaoti`,`shangpinmingcheng`,`shangpumingcheng`,`huiyuanzhanghao`,`huiyuanxingming`,`shangpinpingjia`,`shangpintupian`,`shangjiahuifu`,`userid`) values (71,'2022-04-03 16:44:40','评论标题1','商品名称1','商铺名称1','会员账号1','会员姓名1','商品评价1','http://localhost:8080/ssm641l4/upload/shangpinpingjia_shangpintupian1.jpg','商家回复1',1),(72,'2022-04-03 16:44:40','评论标题2','商品名称2','商铺名称2','会员账号2','会员姓名2','商品评价2','http://localhost:8080/ssm641l4/upload/shangpinpingjia_shangpintupian2.jpg','商家回复2',2),(73,'2022-04-03 16:44:40','评论标题3','商品名称3','商铺名称3','会员账号3','会员姓名3','商品评价3','http://localhost:8080/ssm641l4/upload/shangpinpingjia_shangpintupian3.jpg','商家回复3',3),(74,'2022-04-03 16:44:40','评论标题4','商品名称4','商铺名称4','会员账号4','会员姓名4','商品评价4','http://localhost:8080/ssm641l4/upload/shangpinpingjia_shangpintupian4.jpg','商家回复4',4),(75,'2022-04-03 16:44:40','评论标题5','商品名称5','商铺名称5','会员账号5','会员姓名5','商品评价5','http://localhost:8080/ssm641l4/upload/shangpinpingjia_shangpintupian5.jpg','商家回复5',5),(76,'2022-04-03 16:44:40','评论标题6','商品名称6','商铺名称6','会员账号6','会员姓名6','商品评价6','http://localhost:8080/ssm641l4/upload/shangpinpingjia_shangpintupian6.jpg','商家回复6',6);

/*Table structure for table `shangpinxinxi` */

DROP TABLE IF EXISTS `shangpinxinxi`;

CREATE TABLE `shangpinxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `shangpintupian` varchar(200) DEFAULT NULL COMMENT '商品图片',
  `shangpinleixing` varchar(200) DEFAULT NULL COMMENT '商品类型',
  `shangjiazhanghao` varchar(200) DEFAULT NULL COMMENT '商家账号',
  `shangpumingcheng` varchar(200) DEFAULT NULL COMMENT '商铺名称',
  `shangpinyuanjia` int(11) DEFAULT NULL COMMENT '商品原价',
  `shangpinxianjia` int(11) DEFAULT NULL COMMENT '商品现价',
  `tuangouzuidirenshu` int(11) DEFAULT NULL COMMENT '团购最低人数',
  `shangpinzhekou` varchar(200) DEFAULT NULL COMMENT '商品折扣',
  `tuangoukaishishijian` datetime DEFAULT NULL COMMENT '团购开始时间',
  `tuangoujieshushijian` datetime DEFAULT NULL COMMENT '团购结束时间',
  `shangpinmiaoshu` longtext COMMENT '商品描述',
  `ketihuodian` varchar(200) DEFAULT NULL COMMENT '可提货点',
  `reversetime` datetime DEFAULT NULL COMMENT '倒计结束时间',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  `jifen` int(11) DEFAULT '-1' COMMENT '积分',
  `price` float NOT NULL COMMENT '价格',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='商品信息';

/*Data for the table `shangpinxinxi` */

insert  into `shangpinxinxi`(`id`,`addtime`,`shangpinmingcheng`,`shangpintupian`,`shangpinleixing`,`shangjiazhanghao`,`shangpumingcheng`,`shangpinyuanjia`,`shangpinxianjia`,`tuangouzuidirenshu`,`shangpinzhekou`,`tuangoukaishishijian`,`tuangoujieshushijian`,`shangpinmiaoshu`,`ketihuodian`,`reversetime`,`clicknum`,`jifen`,`price`) values (31,'2022-04-03 16:44:40','商品名称1','http://localhost:8080/ssm641l4/upload/shangpinxinxi_shangpintupian1.jpg','商品类型1','商家账号1','商铺名称1',1,1,1,'商品折扣1','2022-04-03 16:44:40','2022-04-03 16:44:40','商品描述1','可提货点1','2022-04-04 00:00:00',3,10000,99.9),(32,'2022-04-03 16:44:40','商品名称2','http://localhost:8080/ssm641l4/upload/shangpinxinxi_shangpintupian2.jpg','商品类型2','商家账号2','商铺名称2',2,2,2,'商品折扣2','2022-04-03 16:44:40','2022-04-03 16:44:40','商品描述2','可提货点2','2022-04-04 00:00:00',2,10000,99.9),(33,'2022-04-03 16:44:40','商品名称3','http://localhost:8080/ssm641l4/upload/shangpinxinxi_shangpintupian3.jpg','商品类型3','商家账号3','商铺名称3',3,3,3,'商品折扣3','2022-04-03 16:44:40','2022-04-03 16:44:40','商品描述3','可提货点3','2022-04-04 00:00:00',3,10000,99.9),(34,'2022-04-03 16:44:40','商品名称4','http://localhost:8080/ssm641l4/upload/shangpinxinxi_shangpintupian4.jpg','商品类型4','商家账号4','商铺名称4',4,4,4,'商品折扣4','2022-04-03 16:44:40','2022-04-03 16:44:40','商品描述4','可提货点4','2022-04-04 00:00:00',4,10000,99.9),(35,'2022-04-03 16:44:40','商品名称5','http://localhost:8080/ssm641l4/upload/shangpinxinxi_shangpintupian5.jpg','商品类型5','商家账号5','商铺名称5',5,5,5,'商品折扣5','2022-04-03 16:44:40','2022-04-03 16:44:40','商品描述5','可提货点5','2022-04-04 00:00:00',5,10000,99.9),(36,'2022-04-03 16:44:40','商品名称6','http://localhost:8080/ssm641l4/upload/shangpinxinxi_shangpintupian6.jpg','商品类型6','商家账号6','商铺名称6',6,6,6,'商品折扣6','2022-04-03 16:44:40','2022-04-03 16:44:40','商品描述6','可提货点6','2022-04-04 00:00:00',6,10000,99.9);

/*Table structure for table `shequtihuodian` */

DROP TABLE IF EXISTS `shequtihuodian`;

CREATE TABLE `shequtihuodian` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `tihuodidian` varchar(200) DEFAULT NULL COMMENT '提货地点',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='社区提货点';

/*Data for the table `shequtihuodian` */

insert  into `shequtihuodian`(`id`,`addtime`,`tihuodidian`) values (81,'2022-04-03 16:44:40','提货地点1'),(82,'2022-04-03 16:44:40','提货地点2'),(83,'2022-04-03 16:44:40','提货地点3'),(84,'2022-04-03 16:44:40','提货地点4'),(85,'2022-04-03 16:44:40','提货地点5'),(86,'2022-04-03 16:44:40','提货地点6');

/*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=2 DEFAULT CHARSET=utf8 COMMENT='token表';

/*Data for the table `token` */

insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,11,'会员1','huiyuan','会员','0dwu88xqlhnen5qw7863b4m9fmshe9h2','2022-04-03 16:46:29','2022-04-03 17:46:30');

/*Table structure for table `tuihuotuikuan` */

DROP TABLE IF EXISTS `tuihuotuikuan`;

CREATE TABLE `tuihuotuikuan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `dingdanhao` varchar(200) DEFAULT NULL COMMENT '订单号',
  `shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `shangpintupian` varchar(200) DEFAULT NULL COMMENT '商品图片',
  `tuihuoshijian` datetime DEFAULT NULL COMMENT '退货时间',
  `huiyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '会员账号',
  `huiyuanxingming` varchar(200) DEFAULT NULL COMMENT '会员姓名',
  `tuihuoliyou` longtext COMMENT '退货理由',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='退货退款';

/*Data for the table `tuihuotuikuan` */

insert  into `tuihuotuikuan`(`id`,`addtime`,`dingdanhao`,`shangpinmingcheng`,`shangpintupian`,`tuihuoshijian`,`huiyuanzhanghao`,`huiyuanxingming`,`tuihuoliyou`,`sfsh`,`shhf`,`clicknum`,`userid`) values (61,'2022-04-03 16:44:40','订单号1','商品名称1','http://localhost:8080/ssm641l4/upload/tuihuotuikuan_shangpintupian1.jpg','2022-04-03 16:44:40','会员账号1','会员姓名1','退货理由1','是','',1,1),(62,'2022-04-03 16:44:40','订单号2','商品名称2','http://localhost:8080/ssm641l4/upload/tuihuotuikuan_shangpintupian2.jpg','2022-04-03 16:44:40','会员账号2','会员姓名2','退货理由2','是','',2,2),(63,'2022-04-03 16:44:40','订单号3','商品名称3','http://localhost:8080/ssm641l4/upload/tuihuotuikuan_shangpintupian3.jpg','2022-04-03 16:44:40','会员账号3','会员姓名3','退货理由3','是','',3,3),(64,'2022-04-03 16:44:40','订单号4','商品名称4','http://localhost:8080/ssm641l4/upload/tuihuotuikuan_shangpintupian4.jpg','2022-04-03 16:44:40','会员账号4','会员姓名4','退货理由4','是','',4,4),(65,'2022-04-03 16:44:40','订单号5','商品名称5','http://localhost:8080/ssm641l4/upload/tuihuotuikuan_shangpintupian5.jpg','2022-04-03 16:44:40','会员账号5','会员姓名5','退货理由5','是','',5,5),(66,'2022-04-03 16:44:40','订单号6','商品名称6','http://localhost:8080/ssm641l4/upload/tuihuotuikuan_shangpintupian6.jpg','2022-04-03 16:44:40','会员账号6','会员姓名6','退货理由6','是','',6,6);

/*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,'abo','abo','管理员','2022-04-03 16:44:40');

/*!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
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
基于微信小程序的社区小区团购电商在线商城平台SSM-JAVA【数据库设计、论文、毕设源码、开题报告】

社区团购系统中的功能模块主要是实现管理员服务端；首页、个人中心、会员管理、商家管理、商品信息管理、商品分类管理、购买订单管理、退货退款管理、商品评价管理、系统管理；商家服务端：首页、个人中心、商品信息管理、购买订单管理、退货退款管理、商品评价管理；会员客户端：首页、商品信息、我的（会员信息、商品信息、购买订单、退货退款、商品评价、用户充值、购物车、我的订单）。
复制链接

扫一扫