sql建表

 /*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 80022
Source Host           : localhost:3306
Source Database       : testgf

Target Server Type    : MYSQL
Target Server Version : 80022
File Encoding         : 65001

Date: 2026-04-14 21:10:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for jfaddress
-- ----------------------------
DROP TABLE IF EXISTS `jfaddress`;
CREATE TABLE `jfaddress` (
  `address_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `ainfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '详细地址',
  `aphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号',
  `arealname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '省',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '城市',
  `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '区',
  `user_id` int NOT NULL COMMENT '用户',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建时间',
  `is_default` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '1默认地址0初始',
  PRIMARY KEY (`address_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='地址';

-- ----------------------------
-- Records of jfaddress
-- ----------------------------

-- ----------------------------
-- Table structure for jfbanner
-- ----------------------------
DROP TABLE IF EXISTS `jfbanner`;
CREATE TABLE `jfbanner` (
  `banner_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `bimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '图片',
  `bsort` int NOT NULL COMMENT '排序字段',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建时间',
  `bhref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '连接',
  `bmsg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '描述',
  PRIMARY KEY (`banner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='轮播图';

-- ----------------------------
-- Records of jfbanner
-- ----------------------------

-- ----------------------------
-- Table structure for jfcart
-- ----------------------------
DROP TABLE IF EXISTS `jfcart`;
CREATE TABLE `jfcart` (
  `cart_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `buynum` int NOT NULL COMMENT '购买数量',
  `good_id` int NOT NULL COMMENT '商品',
  `ginfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '规格',
  `user_id` int NOT NULL COMMENT '商品',
  PRIMARY KEY (`cart_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='购物车';

-- ----------------------------
-- Records of jfcart
-- ----------------------------

-- ----------------------------
-- Table structure for jfcollectgoods
-- ----------------------------
DROP TABLE IF EXISTS `jfcollectgoods`;
CREATE TABLE `jfcollectgoods` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int NOT NULL COMMENT '用户',
  `good_id` int NOT NULL COMMENT '商品',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '收藏时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='收藏商品';

-- ----------------------------
-- Records of jfcollectgoods
-- ----------------------------

-- ----------------------------
-- Table structure for jfevaluate
-- ----------------------------
DROP TABLE IF EXISTS `jfevaluate`;
CREATE TABLE `jfevaluate` (
  `eval_id` int NOT NULL AUTO_INCREMENT,
  `buyer_id` int NOT NULL COMMENT '用户',
  `score` int NOT NULL COMMENT '评分',
  `imgs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '晒图',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '评价时间',
  `econt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '评语',
  `order_id` int NOT NULL COMMENT '订单id',
  `gname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称',
  `is_reply` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '0待回复1已回复',
  `rcont` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '回复时间',
  `seller_id` int NOT NULL COMMENT '店家',
  `rts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '回复时间',
  PRIMARY KEY (`eval_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='评价';

-- ----------------------------
-- Records of jfevaluate
-- ----------------------------

-- ----------------------------
-- Table structure for jfgoods
-- ----------------------------
DROP TABLE IF EXISTS `jfgoods`;
CREATE TABLE `jfgoods` (
  `good_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `gname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称',
  `main_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品主图',
  `gimgs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '轮播图',
  `gdesc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品详情',
  `gaudit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '0待审核1通过-1不通过',
  `audit_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审核员',
  `audit_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审核时间',
  `is_pub` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '1上架0下架',
  `total_score` int DEFAULT NULL COMMENT '总评分',
  `avg_score` int DEFAULT NULL COMMENT '评分',
  `score_num` int DEFAULT NULL COMMENT '评价人数',
  `cts` varchar(0) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建时间',
  `type_id` int NOT NULL COMMENT '分类',
  `stock` int NOT NULL COMMENT '库存',
  `sales` int NOT NULL DEFAULT '0' COMMENT '销量',
  `shop_id` int NOT NULL COMMENT '店家',
  `price` decimal(10,2) NOT NULL COMMENT '展示价格',
  `spec` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '规格',
  `audit_msg` varchar(255) DEFAULT NULL COMMENT '驳回理由',
  PRIMARY KEY (`good_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商品';

-- ----------------------------
-- Records of jfgoods
-- ----------------------------

-- ----------------------------
-- Table structure for jforder
-- ----------------------------
DROP TABLE IF EXISTS `jforder`;
CREATE TABLE `jforder` (
  `order_id` int NOT NULL AUTO_INCREMENT,
  `order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号',
  `goods_id` int NOT NULL COMMENT '商品id',
  `buyer_id` int NOT NULL COMMENT '买家id',
  `seller_id` int NOT NULL COMMENT '买家id',
  `buy_num` int NOT NULL COMMENT '购买数量',
  `price` decimal(10,2) NOT NULL COMMENT '价格',
  `gname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称',
  `money` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '总价格',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '0待支付1已支付待发货2已发货待收货3已收货待评价4已评价已完成5取消订单6申请退款7申请退货退款8已退款',
  `pay_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '支付时间',
  `apply_refund_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '申请退款时间',
  `refund_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '退款时间',
  `send_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '发货时间',
  `accept_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '收货时间',
  `address_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '收货地址',
  `ginfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品规格',
  `cts` varchar(255) DEFAULT NULL COMMENT '下单时间',
  `buyer_show` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '买家1展示0删除',
  `seller_show` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '店家1展示0删除',
  `send_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '发货单号',
  `returned_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '退货单号',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='订单';

-- ----------------------------
-- Records of jforder
-- ----------------------------

-- ----------------------------
-- Table structure for jfshop
-- ----------------------------
DROP TABLE IF EXISTS `jfshop`;
CREATE TABLE `jfshop` (
  `shop_id` int NOT NULL COMMENT 'id=user_id',
  `sname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '店铺名称',
  `slogo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'logo',
  `sdesc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主营类目',
  `audit_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审核人',
  `shop_audit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '0待审核1通过-1不通过',
  `audit_ts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审核时间',
  `audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '不通过的原因',
  `total_score` int DEFAULT NULL COMMENT '总评分',
  `avg_score` int DEFAULT NULL COMMENT '平均分',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '0关闭店铺1营业中',
  `score_num` int DEFAULT NULL COMMENT '评价人数',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建时间',
  `business_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '营业执照',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '省',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '城市',
  `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '区',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='店铺';

-- ----------------------------
-- Records of jfshop
-- ----------------------------

-- ----------------------------
-- Table structure for jfstatistics
-- ----------------------------
DROP TABLE IF EXISTS `jfstatistics`;
CREATE TABLE `jfstatistics` (
  `day` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '日期',
  `regnum` int DEFAULT NULL COMMENT '注册人数',
  `goodsnum` int DEFAULT NULL COMMENT '上新商品数量',
  `ordernum` int DEFAULT NULL COMMENT '下单数量',
  `paymoney` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '营业额',
  `refundmoney` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '退货金额',
  `refundnum` int DEFAULT NULL COMMENT '退货数量',
  PRIMARY KEY (`day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='统计';

-- ----------------------------
-- Records of jfstatistics
-- ----------------------------

-- ----------------------------
-- Table structure for jftype
-- ----------------------------
DROP TABLE IF EXISTS `jftype`;
CREATE TABLE `jftype` (
  `type_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `tname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '分类名称',
  `tsort` int NOT NULL COMMENT '排序字段',
  `cts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='分类';

-- ----------------------------
-- Records of jftype
-- ----------------------------