/*
|
Navicat Premium Data Transfer
|
|
Source Server : 192.168.110.169
|
Source Server Type : MySQL
|
Source Server Version : 80036
|
Source Host : 192.168.110.169:3306
|
Source Schema : qijisheng_other
|
|
Target Server Type : MySQL
|
Target Server Version : 80036
|
File Encoding : 65001
|
|
Date: 25/11/2024 18:30:07
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for t_agreement
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_agreement`;
|
CREATE TABLE `t_agreement` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`type` int NULL DEFAULT NULL COMMENT '类型（1=用户协议，2=隐私协议，3=技师上门免责声明，4=注销协议，5门店提现免责声明）',
|
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '内容',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '协议' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_agreement
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_banner
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_banner`;
|
CREATE TABLE `t_banner` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`position` int NULL DEFAULT NULL COMMENT '位置（1=首页，2=商城首页）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`jump_type` int NULL DEFAULT NULL COMMENT '跳转类型（1=无跳转，2=外部链接，3=商品详情，4=秒杀商品详情，5=领券中心）',
|
`content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '跳转内容',
|
`image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '图片地址',
|
`video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '视频地址',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除标识（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'banner' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_banner
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_base_setting
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_base_setting`;
|
CREATE TABLE `t_base_setting` (
|
`id` int NOT NULL COMMENT '1:合伙人积分设置一\r\n2:合伙人积分设置二\r\n3:会员说明设置\r\n4:活动管理-活动设置 1开0关',
|
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '内容',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '基础设置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_base_setting
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_coupon_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_coupon_info`;
|
CREATE TABLE `t_coupon_info` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
`coupon_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '优惠券名称',
|
`coupon_type` int NULL DEFAULT NULL COMMENT '优惠券类型 1\'满减券\',2\'代金券\',3\'折扣券\',4\'商品券\'',
|
`condition_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '满x元',
|
`discount_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '减x元',
|
`money_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '代金x元',
|
`discount` decimal(10, 2) NULL DEFAULT NULL COMMENT '折扣',
|
`for_good_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '适用商品ids，全部-1',
|
`send_num` int NULL DEFAULT NULL COMMENT '发放数量',
|
`max_num` int NULL DEFAULT NULL COMMENT '可领数量',
|
`period_type` int NULL DEFAULT NULL COMMENT '有效期类型 1指定时间内有效 2领取后x天有效',
|
`period_start_time` datetime(0) NULL DEFAULT NULL COMMENT '有效期开始时间',
|
`period_end_time` datetime(0) NULL DEFAULT NULL COMMENT '有效期结束时间',
|
`period_days` int NULL DEFAULT NULL COMMENT '领取后x天有效',
|
`send_start_time` datetime(0) NULL DEFAULT NULL COMMENT '开始发放时间',
|
`send_end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束发放时间',
|
`send_type` int NULL DEFAULT NULL COMMENT '1免费发放2积分兑换',
|
`need_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '兑换所需积分',
|
`person_type` int NULL DEFAULT NULL COMMENT '可领用户 1全部 2指定人员 3指定会员 4 新人注册',
|
`person_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '可领取对应的ids，用find_in_set查询',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '优惠劵' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_coupon_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods`;
|
CREATE TABLE `t_goods` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`goods_category_id` int NULL DEFAULT NULL COMMENT '分类id',
|
`type` int NULL DEFAULT NULL COMMENT '类型（1=服务商品，2=单品商品）',
|
`purchase_limit` int NULL DEFAULT NULL COMMENT '限购数量（-1不限购）',
|
`distribution_mode` int NULL DEFAULT NULL COMMENT '配送方式（1=自提，2=快递）',
|
`appoint_store` int NULL DEFAULT NULL COMMENT '指定门店（1=指定，2=所有）',
|
`introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '商品简介',
|
`home_page_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '封面图',
|
`detail_picture` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '详情图，多个逗号分隔',
|
`detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '商品详情',
|
`operating_cost` decimal(10, 2) NULL DEFAULT NULL COMMENT '运营成本',
|
`shop_cost` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店成本',
|
`original_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '划线价',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`commodity_authority` int NULL DEFAULT NULL COMMENT '商品权限JSON（0=全部，1=游客，2=普通会员，3=黄金会员，4=钻石会员，5=准代理，6=代理，7=总代，8=合伙人）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=下架，2=上架）',
|
`sale_num` int NULL DEFAULT NULL COMMENT '销量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user`;
|
CREATE TABLE `t_goods_app_user` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_0`;
|
CREATE TABLE `t_goods_app_user_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_1`;
|
CREATE TABLE `t_goods_app_user_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_2`;
|
CREATE TABLE `t_goods_app_user_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_3`;
|
CREATE TABLE `t_goods_app_user_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_4`;
|
CREATE TABLE `t_goods_app_user_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_5`;
|
CREATE TABLE `t_goods_app_user_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_6`;
|
CREATE TABLE `t_goods_app_user_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_7`;
|
CREATE TABLE `t_goods_app_user_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_8`;
|
CREATE TABLE `t_goods_app_user_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_app_user_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_app_user_9`;
|
CREATE TABLE `t_goods_app_user_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定用户数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_app_user_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area`;
|
CREATE TABLE `t_goods_area` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_0`;
|
CREATE TABLE `t_goods_area_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_1`;
|
CREATE TABLE `t_goods_area_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_2`;
|
CREATE TABLE `t_goods_area_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_3`;
|
CREATE TABLE `t_goods_area_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_4`;
|
CREATE TABLE `t_goods_area_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_5`;
|
CREATE TABLE `t_goods_area_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_6`;
|
CREATE TABLE `t_goods_area_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_7`;
|
CREATE TABLE `t_goods_area_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_8`;
|
CREATE TABLE `t_goods_area_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_area_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_area_9`;
|
CREATE TABLE `t_goods_area_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省编号',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`districts` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区',
|
`districts_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区编号',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品地区配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_area_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_bargain_price
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_bargain_price`;
|
CREATE TABLE `t_goods_bargain_price` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` int NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` int NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店特价申请数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_bargain_price
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_bargain_price_detail
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_bargain_price_detail`;
|
CREATE TABLE `t_goods_bargain_price_detail` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`goods_bargain_price_id` int NULL DEFAULT NULL COMMENT '门店特价申请数据id',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店特价申请明细数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_bargain_price_detail
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_category
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_category`;
|
CREATE TABLE `t_goods_category` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'icon图片地址',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品分类' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_category
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate`;
|
CREATE TABLE `t_goods_evaluate` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` int NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_0`;
|
CREATE TABLE `t_goods_evaluate_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_1`;
|
CREATE TABLE `t_goods_evaluate_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_2`;
|
CREATE TABLE `t_goods_evaluate_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_3`;
|
CREATE TABLE `t_goods_evaluate_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_4`;
|
CREATE TABLE `t_goods_evaluate_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_5`;
|
CREATE TABLE `t_goods_evaluate_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_6`;
|
CREATE TABLE `t_goods_evaluate_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_7`;
|
CREATE TABLE `t_goods_evaluate_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_8`;
|
CREATE TABLE `t_goods_evaluate_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_evaluate_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_evaluate_9`;
|
CREATE TABLE `t_goods_evaluate_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`grade` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
|
`images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评价图片',
|
`status` int NULL DEFAULT 2 COMMENT '状态（1=下架，2=上架）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品评价' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_evaluate_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_seckill
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_seckill`;
|
CREATE TABLE `t_goods_seckill` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '秒杀活动会员配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_seckill
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop`;
|
CREATE TABLE `t_goods_shop` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_0`;
|
CREATE TABLE `t_goods_shop_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_1`;
|
CREATE TABLE `t_goods_shop_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_2`;
|
CREATE TABLE `t_goods_shop_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_3`;
|
CREATE TABLE `t_goods_shop_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_4`;
|
CREATE TABLE `t_goods_shop_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_5`;
|
CREATE TABLE `t_goods_shop_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_6`;
|
CREATE TABLE `t_goods_shop_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_7`;
|
CREATE TABLE `t_goods_shop_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_8`;
|
CREATE TABLE `t_goods_shop_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_shop_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_shop_9`;
|
CREATE TABLE `t_goods_shop_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品指定门店数据' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_shop_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_goods_vip
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_goods_vip`;
|
CREATE TABLE `t_goods_vip` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`vip` int NULL DEFAULT NULL COMMENT '会员级别（1=普通会员，2=黄金会员，3=钻石会员，4=准代理，5=代理，6=总代，7=合伙人）',
|
`cash_payment` int NULL DEFAULT NULL COMMENT '现金支付（0=否，1=是）',
|
`point_payment` int NULL DEFAULT NULL COMMENT '积分支付（0=否，1=是）',
|
`selling_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '基础售价',
|
`integral` int NULL DEFAULT NULL COMMENT '基础积分',
|
`earn_spending_points` int NULL DEFAULT NULL COMMENT '可获得消费积分',
|
`superior_subcommission` decimal(10, 2) NULL DEFAULT NULL COMMENT '上级获得分佣金额',
|
`superior_rebate_points` int NULL DEFAULT NULL COMMENT '上级获得返佣积分',
|
`superior_type` int NULL DEFAULT NULL COMMENT '获取返佣积分上级类型（1=直推上级，2=直帮上级）',
|
`servuce_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '核销门店可获得服务费',
|
`servuce_shop_points` int NULL DEFAULT NULL COMMENT '核销门店可获得服务积分',
|
`technician_points` int NULL DEFAULT NULL COMMENT '技师可获得服务积分',
|
`bound_shop_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店可获得分佣金额',
|
`bound_shop_points` int NULL DEFAULT NULL COMMENT '绑定门店可获得返佣积分',
|
`bound_shop_superiors_charges` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得分佣金额',
|
`bound_shop_superiors_points` int NULL DEFAULT NULL COMMENT '绑定门店上级门店可获得返佣积分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '商品会员配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_goods_vip
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_activity_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_activity_info`;
|
CREATE TABLE `t_order_activity_info` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
`activity_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动名称',
|
`vip_ids` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '适用会员类型',
|
`start_time` datetime(0) NULL DEFAULT NULL COMMENT '活动开始日期',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '活动结束日期',
|
`condition_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '满x元',
|
`discount` decimal(10, 2) NULL DEFAULT NULL COMMENT '折扣',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '订单优惠活动' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_activity_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_phone
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_phone`;
|
CREATE TABLE `t_phone` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`type` int NULL DEFAULT NULL COMMENT '类型（1=平台，2=门店）',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`phone_one` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系电话1',
|
`phone_two` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系电话2',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '客服电话' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_phone
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_point_setting
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_point_setting`;
|
CREATE TABLE `t_point_setting` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '1-7对应会员等级',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
`new_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '拉新人积分',
|
`every_share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '每日分享积分',
|
`sign_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '每日签到积分',
|
`hour_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用一小时积分',
|
`regis_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '注册积分',
|
`regis_point_open` int NULL DEFAULT NULL COMMENT '注册积分 1开0关',
|
`regis_point_gift` int NULL DEFAULT NULL COMMENT '注册积分转赠送 1开0关',
|
`buy_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费积分',
|
`buy_point_open` int NULL DEFAULT NULL COMMENT '消费积分积分 1开0关',
|
`buy_point_gift` int NULL DEFAULT NULL COMMENT '消费积分转赠送 1开0关',
|
`share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '返佣积分',
|
`share_point_open` int NULL DEFAULT NULL COMMENT '返佣积分 1开0关',
|
`share_point_gift` int NULL DEFAULT NULL COMMENT '返佣积分转赠送 1开0关',
|
`shop_share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店返佣积分',
|
`shop_share_point_open` int NULL DEFAULT NULL COMMENT '门店返佣积分 1开0关',
|
`shop_share_point_gift` int NULL DEFAULT NULL COMMENT '门店返佣积分赠送 1开0关',
|
`shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店业绩积分',
|
`shop_point_open` int NULL DEFAULT NULL COMMENT '门店业绩积分 1开0关',
|
`shop_point_gift` int NULL DEFAULT NULL COMMENT '门店业绩积分转赠送 1开0关',
|
`person_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '技师业绩积分',
|
`person_point_open` int NULL DEFAULT NULL COMMENT '技师业绩积分 1开0关',
|
`person_point_gift` int NULL DEFAULT NULL COMMENT '技师积分转赠送 1开0关',
|
`get_new_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '拉新人积分',
|
`get_new_point_open` int NULL DEFAULT NULL COMMENT '拉新人积分 1开0关',
|
`get_new_point_gift` int NULL DEFAULT NULL COMMENT '拉新人积分转赠送 1开0关',
|
`get_regis_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '注册积分',
|
`get_regis_point_open` int NULL DEFAULT NULL COMMENT '注册积分 1开0关',
|
`get_regis_point_gift` int NULL DEFAULT NULL COMMENT '注册积分转赠送 1开0关',
|
`work_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '做工积分',
|
`work_point_open` int NULL DEFAULT NULL COMMENT '做工积分 1开0关',
|
`work_point_gift` int NULL DEFAULT NULL COMMENT '做工积分转赠送 1开0关',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '积分管理-积分设置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_point_setting
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_recharge_set
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_recharge_set`;
|
CREATE TABLE `t_recharge_set` (
|
`id` int NOT NULL,
|
`recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值金额',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '充值管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_recharge_set
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_red_packege_set
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_red_packege_set`;
|
CREATE TABLE `t_red_packege_set` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
`start_time` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`packege_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包金额',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '红包活动设置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_red_packege_set
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_seckill_activity_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_seckill_activity_info`;
|
CREATE TABLE `t_seckill_activity_info` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
`good_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`max_num` int NULL DEFAULT NULL COMMENT '限购数量',
|
`vip_ids` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '适用会员类型',
|
`start_time` datetime(0) NULL DEFAULT NULL COMMENT '活动开始日期',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '活动结束日期',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品秒杀活动' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_seckill_activity_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_share
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_share`;
|
CREATE TABLE `t_share` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '标题',
|
`image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '图片地址',
|
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '分享内容',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` int NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`applet_share` int NULL DEFAULT 0 COMMENT '小程序分享（0=否，1=是）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除状态（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`add_type` int NULL DEFAULT NULL COMMENT '添加类型（1=平台添加，2=推广人添加，3=门店添加）',
|
`object_id` int NULL DEFAULT NULL COMMENT '对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '分享' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_share
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop`;
|
CREATE TABLE `t_shop` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '门店名称',
|
`pid` int NULL DEFAULT 0 COMMENT '上级门店id',
|
`business_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '营业星期（1,2,3,4,5,6,7）',
|
`start_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开始时间（HH:mm）',
|
`end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '结束时间（HH:mm）',
|
`home_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '封面图',
|
`shop_manager` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '店长姓名',
|
`details_picture` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '详情图，多个逗号分隔',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '电话',
|
`app_user_id` int NULL DEFAULT NULL COMMENT '店长用户id',
|
`service_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '客户电话（同步到t_phone表）',
|
`certification` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '资质证书图片',
|
`longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结）',
|
`shop_all_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店积分总数',
|
`shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店业绩积分',
|
`share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店返佣积分',
|
`server_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店服务积分',
|
`lower_level_rebate_points` decimal(10, 2) NULL DEFAULT NULL COMMENT '下级门店返佣积分',
|
`use_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店已用积分',
|
`giveaway_all_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店分佣总金额',
|
`giveaway_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店分佣金额',
|
`lower_level_giveaway_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '绑定下级门店分佣金额',
|
`server_giveaway_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '门店服务分佣金额',
|
`can_withdraw_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额',
|
`withdraw_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额',
|
`order_number` int NULL DEFAULT NULL COMMENT '门店订单总数',
|
`server_order_number` int NULL DEFAULT NULL COMMENT '门店服务订单数',
|
`custom_order_number` int NULL DEFAULT NULL COMMENT '单品自提订单数',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '总评分',
|
`score_number` int NULL DEFAULT NULL COMMENT '评分数量',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement`;
|
CREATE TABLE `t_shop_balance_statement` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_0`;
|
CREATE TABLE `t_shop_balance_statement_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_1`;
|
CREATE TABLE `t_shop_balance_statement_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_10`;
|
CREATE TABLE `t_shop_balance_statement_10` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_11`;
|
CREATE TABLE `t_shop_balance_statement_11` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_12`;
|
CREATE TABLE `t_shop_balance_statement_12` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_13`;
|
CREATE TABLE `t_shop_balance_statement_13` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_14`;
|
CREATE TABLE `t_shop_balance_statement_14` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_15`;
|
CREATE TABLE `t_shop_balance_statement_15` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_16`;
|
CREATE TABLE `t_shop_balance_statement_16` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_17`;
|
CREATE TABLE `t_shop_balance_statement_17` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_18`;
|
CREATE TABLE `t_shop_balance_statement_18` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_19`;
|
CREATE TABLE `t_shop_balance_statement_19` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_2`;
|
CREATE TABLE `t_shop_balance_statement_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_3`;
|
CREATE TABLE `t_shop_balance_statement_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_4`;
|
CREATE TABLE `t_shop_balance_statement_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_5`;
|
CREATE TABLE `t_shop_balance_statement_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_6`;
|
CREATE TABLE `t_shop_balance_statement_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_7`;
|
CREATE TABLE `t_shop_balance_statement_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_8`;
|
CREATE TABLE `t_shop_balance_statement_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_balance_statement_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_balance_statement_9`;
|
CREATE TABLE `t_shop_balance_statement_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=返佣，2=提现）',
|
`historical_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店余额流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_balance_statement_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point`;
|
CREATE TABLE `t_shop_point` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_0`;
|
CREATE TABLE `t_shop_point_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_1`;
|
CREATE TABLE `t_shop_point_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_10`;
|
CREATE TABLE `t_shop_point_10` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_11`;
|
CREATE TABLE `t_shop_point_11` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_12`;
|
CREATE TABLE `t_shop_point_12` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_13`;
|
CREATE TABLE `t_shop_point_13` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_14`;
|
CREATE TABLE `t_shop_point_14` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_15`;
|
CREATE TABLE `t_shop_point_15` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_16`;
|
CREATE TABLE `t_shop_point_16` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_17`;
|
CREATE TABLE `t_shop_point_17` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_18`;
|
CREATE TABLE `t_shop_point_18` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_19`;
|
CREATE TABLE `t_shop_point_19` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_2`;
|
CREATE TABLE `t_shop_point_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_3`;
|
CREATE TABLE `t_shop_point_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_4`;
|
CREATE TABLE `t_shop_point_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_5`;
|
CREATE TABLE `t_shop_point_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_6`;
|
CREATE TABLE `t_shop_point_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_7`;
|
CREATE TABLE `t_shop_point_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_8`;
|
CREATE TABLE `t_shop_point_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_point_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_point_9`;
|
CREATE TABLE `t_shop_point_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`type` int NULL DEFAULT NULL COMMENT '变动类型（1=门店业绩，2=门店返佣，3=下级门店返佣）',
|
`historical_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '历史余额',
|
`variable_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '变动用户id',
|
`object_id` bigint NULL DEFAULT NULL COMMENT '关联对象id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店积分流水' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_point_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_0`;
|
CREATE TABLE `t_shop_score_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_1`;
|
CREATE TABLE `t_shop_score_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_10`;
|
CREATE TABLE `t_shop_score_10` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_11`;
|
CREATE TABLE `t_shop_score_11` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_12`;
|
CREATE TABLE `t_shop_score_12` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_13`;
|
CREATE TABLE `t_shop_score_13` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_14`;
|
CREATE TABLE `t_shop_score_14` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_15`;
|
CREATE TABLE `t_shop_score_15` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_16`;
|
CREATE TABLE `t_shop_score_16` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_17`;
|
CREATE TABLE `t_shop_score_17` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_18`;
|
CREATE TABLE `t_shop_score_18` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_19`;
|
CREATE TABLE `t_shop_score_19` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_2`;
|
CREATE TABLE `t_shop_score_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_3`;
|
CREATE TABLE `t_shop_score_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_4`;
|
CREATE TABLE `t_shop_score_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_5`;
|
CREATE TABLE `t_shop_score_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_6`;
|
CREATE TABLE `t_shop_score_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_7`;
|
CREATE TABLE `t_shop_score_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_8`;
|
CREATE TABLE `t_shop_score_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_score_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_score_9`;
|
CREATE TABLE `t_shop_score_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_score_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw`;
|
CREATE TABLE `t_shop_withdraw` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_0`;
|
CREATE TABLE `t_shop_withdraw_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_1`;
|
CREATE TABLE `t_shop_withdraw_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_2`;
|
CREATE TABLE `t_shop_withdraw_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_3`;
|
CREATE TABLE `t_shop_withdraw_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_4`;
|
CREATE TABLE `t_shop_withdraw_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_5`;
|
CREATE TABLE `t_shop_withdraw_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_6`;
|
CREATE TABLE `t_shop_withdraw_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_7`;
|
CREATE TABLE `t_shop_withdraw_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_8`;
|
CREATE TABLE `t_shop_withdraw_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shop_withdraw_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shop_withdraw_9`;
|
CREATE TABLE `t_shop_withdraw_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`money` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额',
|
`audit_status` int NULL DEFAULT 0 COMMENT '审核状态（0=待审核，1=审核通过，2=审核失败）',
|
`audit_user_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
|
`audit_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
|
`audit_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核结果',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=申请中，2=已到账）',
|
`arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到账时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`create_user_id` bigint NULL DEFAULT NULL COMMENT '添加用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '门店提现申请' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shop_withdraw_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_system_config
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_system_config`;
|
CREATE TABLE `t_system_config` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`type` int NULL DEFAULT NULL COMMENT '类型（1=启动页管理，2=首页配置，3=订单包邮设置）',
|
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '配置内容json',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统配置' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_system_config
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician`;
|
CREATE TABLE `t_technician` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`shop_id` int NULL DEFAULT NULL COMMENT '门店id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '技师姓名',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '电话',
|
`introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '简介',
|
`home_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '技师封面图',
|
`info_picture` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '技师详情图',
|
`status` int NULL DEFAULT 1 COMMENT '状态（1=下架，2=上架）',
|
`subscribe_status` int NULL DEFAULT NULL COMMENT '预约状态（1=可预约，2=不可预约）',
|
`del_flag` int NULL DEFAULT 0 COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician
|
-- ----------------------------
|
INSERT INTO `t_technician` VALUES (1, 1, '1', NULL, NULL, NULL, NULL, 2, 1, 0, NULL, NULL);
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_0`;
|
CREATE TABLE `t_technician_score_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_1`;
|
CREATE TABLE `t_technician_score_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_1
|
-- ----------------------------
|
INSERT INTO `t_technician_score_1` VALUES (1, 1, 1, 5.00, '2024-11-25 15:30:01');
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_10`;
|
CREATE TABLE `t_technician_score_10` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_11`;
|
CREATE TABLE `t_technician_score_11` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_12`;
|
CREATE TABLE `t_technician_score_12` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_13`;
|
CREATE TABLE `t_technician_score_13` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_14`;
|
CREATE TABLE `t_technician_score_14` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_15`;
|
CREATE TABLE `t_technician_score_15` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_16`;
|
CREATE TABLE `t_technician_score_16` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_17`;
|
CREATE TABLE `t_technician_score_17` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_18`;
|
CREATE TABLE `t_technician_score_18` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_19`;
|
CREATE TABLE `t_technician_score_19` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_2`;
|
CREATE TABLE `t_technician_score_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_2
|
-- ----------------------------
|
INSERT INTO `t_technician_score_2` VALUES (2, 2, 1, 3.00, '2024-11-25 15:30:39');
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_3`;
|
CREATE TABLE `t_technician_score_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_4`;
|
CREATE TABLE `t_technician_score_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_5`;
|
CREATE TABLE `t_technician_score_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_6`;
|
CREATE TABLE `t_technician_score_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_7`;
|
CREATE TABLE `t_technician_score_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_8`;
|
CREATE TABLE `t_technician_score_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_score_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_score_9`;
|
CREATE TABLE `t_technician_score_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师评分记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_score_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe`;
|
CREATE TABLE `t_technician_subscribe` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe
|
-- ----------------------------
|
INSERT INTO `t_technician_subscribe` VALUES (1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
|
INSERT INTO `t_technician_subscribe` VALUES (2, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_0`;
|
CREATE TABLE `t_technician_subscribe_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_1`;
|
CREATE TABLE `t_technician_subscribe_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_1
|
-- ----------------------------
|
INSERT INTO `t_technician_subscribe_1` VALUES (1, 1, 1, '2024-11-25 14:36:39', NULL, NULL, 0, NULL, NULL);
|
INSERT INTO `t_technician_subscribe_1` VALUES (2, 1, 1, '2024-11-24 14:36:48', NULL, NULL, 1, NULL, NULL);
|
INSERT INTO `t_technician_subscribe_1` VALUES (3, 1, 1, '2024-11-26 14:37:04', NULL, NULL, 2, NULL, NULL);
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_2`;
|
CREATE TABLE `t_technician_subscribe_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_3`;
|
CREATE TABLE `t_technician_subscribe_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_4`;
|
CREATE TABLE `t_technician_subscribe_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_5`;
|
CREATE TABLE `t_technician_subscribe_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_6`;
|
CREATE TABLE `t_technician_subscribe_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_7`;
|
CREATE TABLE `t_technician_subscribe_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_8`;
|
CREATE TABLE `t_technician_subscribe_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_technician_subscribe_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_technician_subscribe_9`;
|
CREATE TABLE `t_technician_subscribe_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '预约时间',
|
`service_mode` int NULL DEFAULT NULL COMMENT '服务方式（1=上门服务，2=到店服务）',
|
`user_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户地址JSON对象',
|
`status` int NULL DEFAULT NULL COMMENT '状态（0=待服务，1=已服务，2=已取消）',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '技师预约记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_technician_subscribe_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good`;
|
CREATE TABLE `t_vip_good` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_0`;
|
CREATE TABLE `t_vip_good_0` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_1`;
|
CREATE TABLE `t_vip_good_1` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_2`;
|
CREATE TABLE `t_vip_good_2` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_3`;
|
CREATE TABLE `t_vip_good_3` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_4`;
|
CREATE TABLE `t_vip_good_4` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_5`;
|
CREATE TABLE `t_vip_good_5` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_6`;
|
CREATE TABLE `t_vip_good_6` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_7`;
|
CREATE TABLE `t_vip_good_7` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_8`;
|
CREATE TABLE `t_vip_good_8` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_good_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_good_9`;
|
CREATE TABLE `t_vip_good_9` (
|
`id` bigint NOT NULL,
|
`vip_id` int NULL DEFAULT NULL COMMENT '对应会员id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '指定购买后升级商品的json快照',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员等级设置-指定商品' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_good_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_vip_setting
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_vip_setting`;
|
CREATE TABLE `t_vip_setting` (
|
`id` int NOT NULL COMMENT '1-7对应会员',
|
`vip_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '会员名称',
|
`vip_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '会员专属权益',
|
`vip_cancel_day` int NULL DEFAULT NULL COMMENT '1级会员用 注册 天后 未成为黄金会员自动解绑推广人',
|
`vip_change_day` int NULL DEFAULT NULL COMMENT '1级会员用 注册 天后 未在商城下单，可更换推广人',
|
`vip_withdrawal_role` int NULL DEFAULT NULL COMMENT '钱包提现权限1开0关',
|
`vip_withdrawal_min_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '最低提现门槛',
|
`vip_gift_role` int NULL DEFAULT NULL COMMENT '积分转赠权限 1开0关',
|
`vip_level_up_shop` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费达到积分 后升级',
|
`vip_level_up_shop_role` int NULL DEFAULT NULL COMMENT '普通会员：达到消费积分后升级开关 1开0关',
|
`vip_level_up_share` decimal(10, 2) NULL DEFAULT NULL COMMENT '返佣达到积分 后升级',
|
`vip_level_up_share_role` int NULL DEFAULT NULL COMMENT '普通会员：返佣积分后升级开关 1开0关',
|
`vip_agent_level_up_role` int NULL DEFAULT NULL COMMENT '创业者：消费并且返佣升级 1开0关',
|
`vip_direct_num` int NULL DEFAULT NULL COMMENT '普通会员：直推用户数 达到后升级',
|
`vip_team_num` int NULL DEFAULT NULL COMMENT '普通会员：团队人数达到后升级',
|
`vip_level_up_num_role` int NULL DEFAULT NULL COMMENT '普通会员：推广人数升级开关 1开0关',
|
`vip_direct_vip_num` int NULL DEFAULT NULL COMMENT '创业者：直推钻石会员',
|
`vip_direct_vip_role` int NULL DEFAULT NULL COMMENT '创业者：直推钻石会员开关 1开0关',
|
`keep_buy_day` int NULL DEFAULT NULL COMMENT '保级：消费x天',
|
`keep_buy_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '保级：消费x分',
|
`keep_share_day` int NULL DEFAULT NULL COMMENT '保级：返佣x天',
|
`keep_share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '保级：返佣x分',
|
`keep_shop_day` int NULL DEFAULT NULL COMMENT '保级：门店x天',
|
`keep_shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '保级：门店x分',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员权益' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_vip_setting
|
-- ----------------------------
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
