/* 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_account Target Server Type : MySQL Target Server Version : 80036 File Encoding : 65001 Date: 25/11/2024 18:29:30 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_agent_application -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application`; CREATE TABLE `t_agent_application` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_0 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_0`; CREATE TABLE `t_agent_application_0` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_1 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_1`; CREATE TABLE `t_agent_application_1` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_10 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_10`; CREATE TABLE `t_agent_application_10` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_11 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_11`; CREATE TABLE `t_agent_application_11` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_12 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_12`; CREATE TABLE `t_agent_application_12` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_13 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_13`; CREATE TABLE `t_agent_application_13` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_14 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_14`; CREATE TABLE `t_agent_application_14` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_15 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_15`; CREATE TABLE `t_agent_application_15` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_16 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_16`; CREATE TABLE `t_agent_application_16` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_17 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_17`; CREATE TABLE `t_agent_application_17` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_18 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_18`; CREATE TABLE `t_agent_application_18` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_19 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_19`; CREATE TABLE `t_agent_application_19` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_2 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_2`; CREATE TABLE `t_agent_application_2` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_3 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_3`; CREATE TABLE `t_agent_application_3` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_4 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_4`; CREATE TABLE `t_agent_application_4` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_5 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_5`; CREATE TABLE `t_agent_application_5` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_6 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_6`; CREATE TABLE `t_agent_application_6` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_7 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_7`; CREATE TABLE `t_agent_application_7` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_8 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_8`; CREATE TABLE `t_agent_application_8` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_agent_application_9 -- ---------------------------- DROP TABLE IF EXISTS `t_agent_application_9`; CREATE TABLE `t_agent_application_9` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `application_vip_id` int NULL DEFAULT NULL COMMENT '申请类型 对应vip_id', `application_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `status` int NULL DEFAULT NULL COMMENT '1\'待处理\',2\'已处理-同意\',3\'已处理-拒绝\'', `shop_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前消费积分', `share_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '用户当前分佣积分', `direct_vip_num` int NULL DEFAULT NULL COMMENT '直推用户已达钻石会员数', `direct_agent_num` int NULL DEFAULT NULL COMMENT '直推用户已成为代理数', `bind_shop_num` int NULL DEFAULT NULL COMMENT '已绑定门店数', `remark` 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_agent_application_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user -- ---------------------------- DROP TABLE IF EXISTS `t_app_user`; CREATE TABLE `t_app_user` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `last_shop_time` datetime(0) NULL DEFAULT NULL COMMENT '最后消费时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_0 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_0`; CREATE TABLE `t_app_user_0` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_1 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_1`; CREATE TABLE `t_app_user_1` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_2 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_2`; CREATE TABLE `t_app_user_2` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_3 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_3`; CREATE TABLE `t_app_user_3` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_4 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_4`; CREATE TABLE `t_app_user_4` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_5 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_5`; CREATE TABLE `t_app_user_5` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_6 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_6`; CREATE TABLE `t_app_user_6` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_7 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_7`; CREATE TABLE `t_app_user_7` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_8 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_8`; CREATE TABLE `t_app_user_8` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_9 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_9`; CREATE TABLE `t_app_user_9` ( `id` bigint NOT NULL COMMENT '主键', `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 '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像', `vip_id` int NULL DEFAULT NULL COMMENT '会员id', `wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid', `ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid', `status` int NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=注销）', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', `del_flag` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '删除（0=否，1=是）', `first_add` int NULL DEFAULT NULL COMMENT '0否1是第一次添加', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `top_invite_id` bigint NULL DEFAULT NULL COMMENT '顶级推广人id', `invite_user_id` bigint NULL DEFAULT NULL COMMENT '推广人id', `shop_id` int NULL DEFAULT NULL COMMENT '拥有门店id', `part_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '合伙人积分数', `part_grow_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 '返佣积分数', `shop_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '消费总金额', `withdrawable_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '可提现金额', `withdrawn_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已提现金额', `total_recharge_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值总金额', `total_red_packet_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '红包总金额', `total_distribution_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '分销总金额', `可提现金额` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'app用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_0 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_0`; CREATE TABLE `t_app_user_bank_0` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_1 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_1`; CREATE TABLE `t_app_user_bank_1` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_2 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_2`; CREATE TABLE `t_app_user_bank_2` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_3 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_3`; CREATE TABLE `t_app_user_bank_3` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_4 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_4`; CREATE TABLE `t_app_user_bank_4` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_5 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_5`; CREATE TABLE `t_app_user_bank_5` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_6 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_6`; CREATE TABLE `t_app_user_bank_6` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_7 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_7`; CREATE TABLE `t_app_user_bank_7` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_8 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_8`; CREATE TABLE `t_app_user_bank_8` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_app_user_bank_9 -- ---------------------------- DROP TABLE IF EXISTS `t_app_user_bank_9`; CREATE TABLE `t_app_user_bank_9` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行名称', `bank_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户银行卡' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_app_user_bank_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_0 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_0`; CREATE TABLE `t_balance_change_record_0` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_1 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_1`; CREATE TABLE `t_balance_change_record_1` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_10 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_10`; CREATE TABLE `t_balance_change_record_10` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_11 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_11`; CREATE TABLE `t_balance_change_record_11` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_12 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_12`; CREATE TABLE `t_balance_change_record_12` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_13 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_13`; CREATE TABLE `t_balance_change_record_13` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_14 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_14`; CREATE TABLE `t_balance_change_record_14` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_15 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_15`; CREATE TABLE `t_balance_change_record_15` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_16 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_16`; CREATE TABLE `t_balance_change_record_16` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_17 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_17`; CREATE TABLE `t_balance_change_record_17` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_18 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_18`; CREATE TABLE `t_balance_change_record_18` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_19 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_19`; CREATE TABLE `t_balance_change_record_19` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_2 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_2`; CREATE TABLE `t_balance_change_record_2` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_3 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_3`; CREATE TABLE `t_balance_change_record_3` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_4 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_4`; CREATE TABLE `t_balance_change_record_4` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_5 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_5`; CREATE TABLE `t_balance_change_record_5` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_6 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_6`; CREATE TABLE `t_balance_change_record_6` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_7 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_7`; CREATE TABLE `t_balance_change_record_7` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_8 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_8`; CREATE TABLE `t_balance_change_record_8` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_change_record_9 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_change_record_9`; CREATE TABLE `t_balance_change_record_9` ( `id` bigint(20) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', `change_type` tinyint(1) NULL DEFAULT NULL COMMENT '1充值2提现3红包4分佣5商城购物', `before_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更前金额', `change_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '变更金额', `after_amount` decimal(10, 2) 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_balance_change_record_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_0 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_0`; CREATE TABLE `t_balance_payment_0` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_1 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_1`; CREATE TABLE `t_balance_payment_1` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_10 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_10`; CREATE TABLE `t_balance_payment_10` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_11 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_11`; CREATE TABLE `t_balance_payment_11` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_12 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_12`; CREATE TABLE `t_balance_payment_12` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_13 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_13`; CREATE TABLE `t_balance_payment_13` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_14 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_14`; CREATE TABLE `t_balance_payment_14` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_15 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_15`; CREATE TABLE `t_balance_payment_15` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_16 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_16`; CREATE TABLE `t_balance_payment_16` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_17 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_17`; CREATE TABLE `t_balance_payment_17` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_18 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_18`; CREATE TABLE `t_balance_payment_18` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_19 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_19`; CREATE TABLE `t_balance_payment_19` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_2 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_2`; CREATE TABLE `t_balance_payment_2` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_20 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_20`; CREATE TABLE `t_balance_payment_20` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_20 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_21 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_21`; CREATE TABLE `t_balance_payment_21` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_21 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_22 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_22`; CREATE TABLE `t_balance_payment_22` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_22 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_23 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_23`; CREATE TABLE `t_balance_payment_23` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_23 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_24 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_24`; CREATE TABLE `t_balance_payment_24` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_24 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_25 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_25`; CREATE TABLE `t_balance_payment_25` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_25 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_26 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_26`; CREATE TABLE `t_balance_payment_26` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_26 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_27 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_27`; CREATE TABLE `t_balance_payment_27` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_27 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_28 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_28`; CREATE TABLE `t_balance_payment_28` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_28 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_29 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_29`; CREATE TABLE `t_balance_payment_29` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_29 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_3 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_3`; CREATE TABLE `t_balance_payment_3` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_30 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_30`; CREATE TABLE `t_balance_payment_30` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_30 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_31 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_31`; CREATE TABLE `t_balance_payment_31` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_31 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_32 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_32`; CREATE TABLE `t_balance_payment_32` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_32 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_33 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_33`; CREATE TABLE `t_balance_payment_33` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_33 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_34 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_34`; CREATE TABLE `t_balance_payment_34` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_34 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_35 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_35`; CREATE TABLE `t_balance_payment_35` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_35 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_36 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_36`; CREATE TABLE `t_balance_payment_36` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_36 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_37 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_37`; CREATE TABLE `t_balance_payment_37` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_37 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_38 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_38`; CREATE TABLE `t_balance_payment_38` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_38 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_39 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_39`; CREATE TABLE `t_balance_payment_39` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_39 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_4 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_4`; CREATE TABLE `t_balance_payment_4` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_40 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_40`; CREATE TABLE `t_balance_payment_40` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_40 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_41 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_41`; CREATE TABLE `t_balance_payment_41` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_41 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_42 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_42`; CREATE TABLE `t_balance_payment_42` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_42 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_43 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_43`; CREATE TABLE `t_balance_payment_43` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_43 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_44 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_44`; CREATE TABLE `t_balance_payment_44` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_44 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_45 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_45`; CREATE TABLE `t_balance_payment_45` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_45 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_46 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_46`; CREATE TABLE `t_balance_payment_46` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_46 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_47 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_47`; CREATE TABLE `t_balance_payment_47` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_47 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_48 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_48`; CREATE TABLE `t_balance_payment_48` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_48 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_49 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_49`; CREATE TABLE `t_balance_payment_49` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_49 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_5 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_5`; CREATE TABLE `t_balance_payment_5` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_6 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_6`; CREATE TABLE `t_balance_payment_6` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_7 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_7`; CREATE TABLE `t_balance_payment_7` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_8 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_8`; CREATE TABLE `t_balance_payment_8` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_balance_payment_9 -- ---------------------------- DROP TABLE IF EXISTS `t_balance_payment_9`; CREATE TABLE `t_balance_payment_9` ( `id` bigint NOT NULL COMMENT '主键', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额', `serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付流水号', `status` int NULL DEFAULT 1 COMMENT '微信支付状态（1=待支付，2=已支付）', `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间', `balance_change_record_id` bigint NULL DEFAULT NULL COMMENT '余额变更记录id', `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_balance_payment_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address -- ---------------------------- DROP TABLE IF EXISTS `t_user_address`; CREATE TABLE `t_user_address` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_0 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_0`; CREATE TABLE `t_user_address_0` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_1 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_1`; CREATE TABLE `t_user_address_1` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_10 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_10`; CREATE TABLE `t_user_address_10` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_11 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_11`; CREATE TABLE `t_user_address_11` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_12 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_12`; CREATE TABLE `t_user_address_12` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_13 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_13`; CREATE TABLE `t_user_address_13` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_14 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_14`; CREATE TABLE `t_user_address_14` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_15 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_15`; CREATE TABLE `t_user_address_15` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_16 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_16`; CREATE TABLE `t_user_address_16` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_17 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_17`; CREATE TABLE `t_user_address_17` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_18 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_18`; CREATE TABLE `t_user_address_18` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_19 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_19`; CREATE TABLE `t_user_address_19` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_2 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_2`; CREATE TABLE `t_user_address_2` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_3 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_3`; CREATE TABLE `t_user_address_3` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_4 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_4`; CREATE TABLE `t_user_address_4` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_5 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_5`; CREATE TABLE `t_user_address_5` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_6 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_6`; CREATE TABLE `t_user_address_6` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_7 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_7`; CREATE TABLE `t_user_address_7` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_8 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_8`; CREATE TABLE `t_user_address_8` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_address_9 -- ---------------------------- DROP TABLE IF EXISTS `t_user_address_9`; CREATE TABLE `t_user_address_9` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `recieve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人姓名', `recieve_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人电话', `recieve_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收件人地址', `is_default` int NULL DEFAULT NULL COMMENT '是否默认1是0否', `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_user_address_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log`; CREATE TABLE `t_user_cancellation_log` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_0 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_0`; CREATE TABLE `t_user_cancellation_log_0` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_1 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_1`; CREATE TABLE `t_user_cancellation_log_1` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_2 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_2`; CREATE TABLE `t_user_cancellation_log_2` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_3 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_3`; CREATE TABLE `t_user_cancellation_log_3` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_4 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_4`; CREATE TABLE `t_user_cancellation_log_4` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_5 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_5`; CREATE TABLE `t_user_cancellation_log_5` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_6 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_6`; CREATE TABLE `t_user_cancellation_log_6` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_7 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_7`; CREATE TABLE `t_user_cancellation_log_7` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_8 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_8`; CREATE TABLE `t_user_cancellation_log_8` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_cancellation_log_9 -- ---------------------------- DROP TABLE IF EXISTS `t_user_cancellation_log_9`; CREATE TABLE `t_user_cancellation_log_9` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_cancellation_log_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log`; CREATE TABLE `t_user_change_log` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_0 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_0`; CREATE TABLE `t_user_change_log_0` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_1 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_1`; CREATE TABLE `t_user_change_log_1` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_10 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_10`; CREATE TABLE `t_user_change_log_10` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_11 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_11`; CREATE TABLE `t_user_change_log_11` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_12 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_12`; CREATE TABLE `t_user_change_log_12` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_13 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_13`; CREATE TABLE `t_user_change_log_13` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_14 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_14`; CREATE TABLE `t_user_change_log_14` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_15 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_15`; CREATE TABLE `t_user_change_log_15` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_16 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_16`; CREATE TABLE `t_user_change_log_16` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_17 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_17`; CREATE TABLE `t_user_change_log_17` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_18 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_18`; CREATE TABLE `t_user_change_log_18` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_19 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_19`; CREATE TABLE `t_user_change_log_19` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_2 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_2`; CREATE TABLE `t_user_change_log_2` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_3 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_3`; CREATE TABLE `t_user_change_log_3` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_4 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_4`; CREATE TABLE `t_user_change_log_4` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_5 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_5`; CREATE TABLE `t_user_change_log_5` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_6 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_6`; CREATE TABLE `t_user_change_log_6` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_7 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_7`; CREATE TABLE `t_user_change_log_7` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_8 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_8`; CREATE TABLE `t_user_change_log_8` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_change_log_9 -- ---------------------------- DROP TABLE IF EXISTS `t_user_change_log_9`; CREATE TABLE `t_user_change_log_9` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `before_vip_id` int NULL DEFAULT NULL COMMENT '变更前等级', `after_vip_id` int NULL DEFAULT NULL COMMENT '变更后等级', `change_type` int 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_user_change_log_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log`; CREATE TABLE `t_user_click_log` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_0 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_0`; CREATE TABLE `t_user_click_log_0` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_1 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_1`; CREATE TABLE `t_user_click_log_1` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_10 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_10`; CREATE TABLE `t_user_click_log_10` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_11 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_11`; CREATE TABLE `t_user_click_log_11` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_12 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_12`; CREATE TABLE `t_user_click_log_12` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_13 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_13`; CREATE TABLE `t_user_click_log_13` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_14 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_14`; CREATE TABLE `t_user_click_log_14` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_15 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_15`; CREATE TABLE `t_user_click_log_15` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_16 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_16`; CREATE TABLE `t_user_click_log_16` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_17 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_17`; CREATE TABLE `t_user_click_log_17` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_18 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_18`; CREATE TABLE `t_user_click_log_18` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_19 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_19`; CREATE TABLE `t_user_click_log_19` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_2 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_2`; CREATE TABLE `t_user_click_log_2` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_20 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_20`; CREATE TABLE `t_user_click_log_20` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_20 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_21 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_21`; CREATE TABLE `t_user_click_log_21` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_21 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_22 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_22`; CREATE TABLE `t_user_click_log_22` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_22 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_23 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_23`; CREATE TABLE `t_user_click_log_23` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_23 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_24 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_24`; CREATE TABLE `t_user_click_log_24` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_24 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_25 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_25`; CREATE TABLE `t_user_click_log_25` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_25 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_26 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_26`; CREATE TABLE `t_user_click_log_26` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_26 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_27 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_27`; CREATE TABLE `t_user_click_log_27` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_27 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_28 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_28`; CREATE TABLE `t_user_click_log_28` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_28 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_29 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_29`; CREATE TABLE `t_user_click_log_29` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_29 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_3 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_3`; CREATE TABLE `t_user_click_log_3` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_30 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_30`; CREATE TABLE `t_user_click_log_30` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_30 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_31 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_31`; CREATE TABLE `t_user_click_log_31` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_31 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_32 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_32`; CREATE TABLE `t_user_click_log_32` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_32 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_33 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_33`; CREATE TABLE `t_user_click_log_33` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_33 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_34 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_34`; CREATE TABLE `t_user_click_log_34` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_34 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_35 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_35`; CREATE TABLE `t_user_click_log_35` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_35 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_36 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_36`; CREATE TABLE `t_user_click_log_36` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_36 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_37 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_37`; CREATE TABLE `t_user_click_log_37` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_37 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_38 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_38`; CREATE TABLE `t_user_click_log_38` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_38 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_39 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_39`; CREATE TABLE `t_user_click_log_39` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_39 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_4 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_4`; CREATE TABLE `t_user_click_log_4` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_5 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_5`; CREATE TABLE `t_user_click_log_5` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_6 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_6`; CREATE TABLE `t_user_click_log_6` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_7 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_7`; CREATE TABLE `t_user_click_log_7` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_8 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_8`; CREATE TABLE `t_user_click_log_8` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_click_log_9 -- ---------------------------- DROP TABLE IF EXISTS `t_user_click_log_9`; CREATE TABLE `t_user_click_log_9` ( `id` bigint NOT NULL COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `vip_id` int 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_user_click_log_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon`; CREATE TABLE `t_user_coupon` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_0 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_0`; CREATE TABLE `t_user_coupon_0` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_1 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_1`; CREATE TABLE `t_user_coupon_1` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_10 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_10`; CREATE TABLE `t_user_coupon_10` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_11 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_11`; CREATE TABLE `t_user_coupon_11` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_12 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_12`; CREATE TABLE `t_user_coupon_12` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_13 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_13`; CREATE TABLE `t_user_coupon_13` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_14 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_14`; CREATE TABLE `t_user_coupon_14` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_15 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_15`; CREATE TABLE `t_user_coupon_15` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_16 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_16`; CREATE TABLE `t_user_coupon_16` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_17 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_17`; CREATE TABLE `t_user_coupon_17` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_18 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_18`; CREATE TABLE `t_user_coupon_18` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_19 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_19`; CREATE TABLE `t_user_coupon_19` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_2 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_2`; CREATE TABLE `t_user_coupon_2` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_3 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_3`; CREATE TABLE `t_user_coupon_3` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_4 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_4`; CREATE TABLE `t_user_coupon_4` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_5 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_5`; CREATE TABLE `t_user_coupon_5` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_6 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_6`; CREATE TABLE `t_user_coupon_6` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_7 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_7`; CREATE TABLE `t_user_coupon_7` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_8 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_8`; CREATE TABLE `t_user_coupon_8` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_coupon_9 -- ---------------------------- DROP TABLE IF EXISTS `t_user_coupon_9`; CREATE TABLE `t_user_coupon_9` ( `id` bigint NOT NULL, `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `use_time` datetime(0) NULL DEFAULT NULL COMMENT '使用时间', `coupon_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_user_coupon_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point -- ---------------------------- DROP TABLE IF EXISTS `t_user_point`; CREATE TABLE `t_user_point` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_0 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_0`; CREATE TABLE `t_user_point_0` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_1 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_1`; CREATE TABLE `t_user_point_1` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_10 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_10`; CREATE TABLE `t_user_point_10` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_11 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_11`; CREATE TABLE `t_user_point_11` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_12 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_12`; CREATE TABLE `t_user_point_12` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_13 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_13`; CREATE TABLE `t_user_point_13` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_14 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_14`; CREATE TABLE `t_user_point_14` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_15 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_15`; CREATE TABLE `t_user_point_15` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_16 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_16`; CREATE TABLE `t_user_point_16` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_17 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_17`; CREATE TABLE `t_user_point_17` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_18 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_18`; CREATE TABLE `t_user_point_18` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_19 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_19`; CREATE TABLE `t_user_point_19` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_2 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_2`; CREATE TABLE `t_user_point_2` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_3 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_3`; CREATE TABLE `t_user_point_3` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_4 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_4`; CREATE TABLE `t_user_point_4` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_5 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_5`; CREATE TABLE `t_user_point_5` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_6 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_6`; CREATE TABLE `t_user_point_6` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_7 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_7`; CREATE TABLE `t_user_point_7` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_8 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_8`; CREATE TABLE `t_user_point_8` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_point_9 -- ---------------------------- DROP TABLE IF EXISTS `t_user_point_9`; CREATE TABLE `t_user_point_9` ( `id` bigint NOT NULL COMMENT '主键', `type` int NULL DEFAULT NULL COMMENT '变动类型（1=消费积分，2=返佣积分，3=拉新人积分，4=兑换商品 5 = 门店业绩积分 6 =门店返佣积分7=技师业绩积分8 =转赠积分 9 =做工积分 10 =注册积分）', `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 '变动时间', `app_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_user_point_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record`; CREATE TABLE `t_user_sign_record` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_0 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_0`; CREATE TABLE `t_user_sign_record_0` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_1 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_1`; CREATE TABLE `t_user_sign_record_1` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_10 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_10`; CREATE TABLE `t_user_sign_record_10` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_11 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_11`; CREATE TABLE `t_user_sign_record_11` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_12 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_12`; CREATE TABLE `t_user_sign_record_12` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_13 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_13`; CREATE TABLE `t_user_sign_record_13` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_14 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_14`; CREATE TABLE `t_user_sign_record_14` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_15 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_15`; CREATE TABLE `t_user_sign_record_15` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_16 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_16`; CREATE TABLE `t_user_sign_record_16` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_17 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_17`; CREATE TABLE `t_user_sign_record_17` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_18 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_18`; CREATE TABLE `t_user_sign_record_18` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_19 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_19`; CREATE TABLE `t_user_sign_record_19` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_2 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_2`; CREATE TABLE `t_user_sign_record_2` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_3 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_3`; CREATE TABLE `t_user_sign_record_3` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_4 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_4`; CREATE TABLE `t_user_sign_record_4` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_5 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_5`; CREATE TABLE `t_user_sign_record_5` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_6 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_6`; CREATE TABLE `t_user_sign_record_6` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_7 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_7`; CREATE TABLE `t_user_sign_record_7` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_8 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_8`; CREATE TABLE `t_user_sign_record_8` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_user_sign_record_9 -- ---------------------------- DROP TABLE IF EXISTS `t_user_sign_record_9`; CREATE TABLE `t_user_sign_record_9` ( `id` bigint NOT NULL, `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `sign_day` date NULL DEFAULT NULL COMMENT '签到时间', `red_amount` decimal(10, 2) 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user_sign_record_9 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests`; CREATE TABLE `t_withdrawal_requests` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', 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_withdrawal_requests -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_0 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_0`; CREATE TABLE `t_withdrawal_requests_0` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_0 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_1 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_1`; CREATE TABLE `t_withdrawal_requests_1` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_1 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_10 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_10`; CREATE TABLE `t_withdrawal_requests_10` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_10 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_11 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_11`; CREATE TABLE `t_withdrawal_requests_11` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_11 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_12 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_12`; CREATE TABLE `t_withdrawal_requests_12` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_12 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_13 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_13`; CREATE TABLE `t_withdrawal_requests_13` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_13 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_14 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_14`; CREATE TABLE `t_withdrawal_requests_14` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_14 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_15 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_15`; CREATE TABLE `t_withdrawal_requests_15` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_15 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_16 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_16`; CREATE TABLE `t_withdrawal_requests_16` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_16 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_17 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_17`; CREATE TABLE `t_withdrawal_requests_17` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_17 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_18 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_18`; CREATE TABLE `t_withdrawal_requests_18` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_18 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_19 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_19`; CREATE TABLE `t_withdrawal_requests_19` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_19 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_2 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_2`; CREATE TABLE `t_withdrawal_requests_2` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_2 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_3 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_3`; CREATE TABLE `t_withdrawal_requests_3` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_3 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_4 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_4`; CREATE TABLE `t_withdrawal_requests_4` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_4 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_5 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_5`; CREATE TABLE `t_withdrawal_requests_5` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_5 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_6 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_6`; CREATE TABLE `t_withdrawal_requests_6` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_6 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_7 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_7`; CREATE TABLE `t_withdrawal_requests_7` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_7 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_8 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_8`; CREATE TABLE `t_withdrawal_requests_8` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_8 -- ---------------------------- -- ---------------------------- -- Table structure for t_withdrawal_requests_9 -- ---------------------------- DROP TABLE IF EXISTS `t_withdrawal_requests_9`; CREATE TABLE `t_withdrawal_requests_9` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间', `app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id', `withdrawal_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '提现金额', `withdrawal_method` int NULL DEFAULT NULL COMMENT '1微信2银行卡', `account_holder` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开户人', `bank_card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '银行卡号', `audit_status` int NULL DEFAULT NULL COMMENT '审核状态 1\'待审核\',2\'审核通过\',3\'审核拒绝\' ', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '提现申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_withdrawal_requests_9 -- ---------------------------- SET FOREIGN_KEY_CHECKS = 1;