/* 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;