/* Navicat Premium Data Transfer Source Server : 本机 Source Server Type : MySQL Source Server Version : 80017 (8.0.17) Source Host : localhost:3306 Source Schema : youlai_admin Target Server Type : MySQL Target Server Version : 80017 (8.0.17) File Encoding : 65001 Date: 10/06/2026 16:51:29 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `table_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '表名', `module_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模块名', `package_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '包名', `business_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务名', `entity_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '实体类名', `author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '作者', `parent_menu_id` bigint(20) NULL DEFAULT NULL COMMENT '上级菜单ID，对应sys_menu的id ', `remove_table_prefix` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '要移除的表前缀，如: sys_', `page_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '页面类型(classic|curd)', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_tablename`(`table_name` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代码生成配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for gen_table_column -- ---------------------------- DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `table_id` bigint(20) NOT NULL COMMENT '关联的表配置ID', `column_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `column_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `column_length` int(11) NULL DEFAULT NULL, `field_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字段名称', `field_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字段类型', `field_sort` int(11) NULL DEFAULT NULL COMMENT '字段排序', `field_comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字段描述', `max_length` int(11) NULL DEFAULT NULL, `is_required` tinyint(1) NULL DEFAULT NULL COMMENT '是否必填', `is_show_in_list` tinyint(1) NULL DEFAULT 0 COMMENT '是否在列表显示', `is_show_in_form` tinyint(1) NULL DEFAULT 0 COMMENT '是否在表单显示', `is_show_in_query` tinyint(1) NULL DEFAULT 0 COMMENT '是否在查询条件显示', `query_type` tinyint(4) NULL DEFAULT NULL COMMENT '查询方式', `form_type` tinyint(4) NULL DEFAULT NULL COMMENT '表单类型', `dict_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典类型', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_table_id`(`table_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代码生成字段配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_config -- ---------------------------- DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `config_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置名称', `config_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置key', `config_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置值', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '逻辑删除标识(0-未删除 1-已删除)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '部门名称', `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '部门编号', `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父节点id', `tree_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '父节点id路径', `sort` smallint(6) NULL DEFAULT 0 COMMENT '显示顺序', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-正常 0-禁用)', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '修改人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除标识(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_code`(`code` ASC) USING BTREE COMMENT '部门编号唯一索引' ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '部门管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_dict -- ---------------------------- DROP TABLE IF EXISTS `sys_dict`; CREATE TABLE `sys_dict` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键 ', `dict_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类型编码', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类型名称', `status` tinyint(1) NULL DEFAULT 0 COMMENT '状态(0:正常;1:禁用)', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '修改人ID', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '是否删除(1-删除，0-未删除)', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_dict_code`(`dict_code` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '数据字典类型表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_dict_item -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_item`; CREATE TABLE `sys_dict_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `dict_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联字典编码，与sys_dict表中的dict_code对应', `value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典项值', `label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典项标签', `tag_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标签类型，用于前端样式展示（如success、warning等）', `status` tinyint(4) NULL DEFAULT 0 COMMENT '状态（1-正常，0-禁用）', `sort` int(11) NULL DEFAULT 0 COMMENT '排序', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '修改人ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '数据字典项表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_log -- ---------------------------- DROP TABLE IF EXISTS `sys_log`; CREATE TABLE `sys_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `module` tinyint(4) NOT NULL COMMENT '模块，数字枚举，参考 LogModule 枚举', `action_type` tinyint(4) NOT NULL COMMENT '操作类型，数字枚举，参考 ActionType 枚举', `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '前端显示标题', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '自定义日志内容', `operator_id` bigint(20) NULL DEFAULT NULL COMMENT '操作人ID', `operator_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作人名称', `request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求路径', `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求方法', `ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IP地址', `province` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省份', `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市', `device` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设备', `os` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作系统', `browser` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '浏览器', `status` tinyint(4) NULL DEFAULT 1 COMMENT '0失败 1成功', `error_msg` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '错误信息', `execution_time` int(11) NULL DEFAULT NULL COMMENT '执行时间(ms)', `create_time` datetime NULL DEFAULT NULL COMMENT '操作时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_module_action_time`(`module` ASC, `action_type` ASC, `create_time` ASC) USING BTREE, INDEX `idx_operator_time`(`operator_id` ASC, `create_time` ASC) USING BTREE, INDEX `idx_time`(`create_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2915 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统操作日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `parent_id` bigint(20) NOT NULL COMMENT '父菜单ID', `tree_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '父节点ID路径', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单名称', `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单类型（C-目录 M-菜单 B-按钮）', `route_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由名称（Vue Router 中用于命名路由）', `route_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由路径（Vue Router 中定义的 URL 路径）', `component` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组件路径（组件页面完整路径，相对于 src/views/，缺省后缀 .vue）', `perm` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '【按钮】权限标识', `always_show` tinyint(4) NULL DEFAULT 0 COMMENT '【目录】只有一个子路由是否始终显示（1-是 0-否）', `keep_alive` tinyint(4) NULL DEFAULT 0 COMMENT '【菜单】是否开启页面缓存（1-是 0-否）', `visible` tinyint(1) NULL DEFAULT 1 COMMENT '显示状态（1-显示 0-隐藏）', `sort` int(11) NULL DEFAULT 0 COMMENT '排序', `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单图标', `redirect` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '跳转路径', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `params` json NULL COMMENT '路由参数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 122203 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统菜单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_notice -- ---------------------------- DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '通知标题', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '通知内容', `type` tinyint(4) NOT NULL COMMENT '通知类型（关联字典编码：notice_type）', `level` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通知等级（字典code：notice_level）', `target_type` tinyint(4) NOT NULL COMMENT '目标类型（1: 全体, 2: 指定）', `target_user_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '目标人ID集合（多个使用英文逗号,分割）', `publisher_id` bigint(20) NULL DEFAULT NULL COMMENT '发布人ID', `publish_status` tinyint(4) NULL DEFAULT 0 COMMENT '发布状态（0: 未发布, 1: 已发布, -1: 已撤回）', `publish_time` datetime NULL DEFAULT NULL COMMENT '发布时间', `revoke_time` datetime NULL DEFAULT NULL COMMENT '撤回时间', `create_by` bigint(20) NOT NULL COMMENT '创建人ID', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除（0: 未删除, 1: 已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统通知公告表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名称', `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色编码', `sort` int(11) NULL DEFAULT NULL COMMENT '显示顺序', `status` tinyint(1) NULL DEFAULT 1 COMMENT '角色状态(1-正常 0-停用)', `data_scope` tinyint(4) NULL DEFAULT NULL COMMENT '数据权限(1-所有数据 2-部门及子部门数据 3-本部门数据 4-本人数据 5-自定义部门数据)', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人 ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑删除标识(0-未删除 1-已删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_name`(`name` ASC) USING BTREE COMMENT '角色名称唯一索引', UNIQUE INDEX `uk_code`(`code` ASC) USING BTREE COMMENT '角色编码唯一索引' ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统角色表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_role_dept`; CREATE TABLE `sys_role_dept` ( `role_id` bigint(20) NOT NULL COMMENT '角色ID', `dept_id` bigint(20) NOT NULL COMMENT '部门ID', UNIQUE INDEX `uk_roleid_deptid`(`role_id` ASC, `dept_id` ASC) USING BTREE COMMENT '角色部门唯一索引' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色部门关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `role_id` bigint(20) NOT NULL COMMENT '角色ID', `menu_id` bigint(20) NOT NULL COMMENT '菜单ID', UNIQUE INDEX `uk_roleid_menuid`(`role_id` ASC, `menu_id` ASC) USING BTREE COMMENT '角色菜单唯一索引' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色菜单关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名', `nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '昵称', `gender` tinyint(1) NULL DEFAULT 1 COMMENT '性别((1-男 2-女 0-保密)', `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码', `dept_id` int(11) NULL DEFAULT NULL COMMENT '部门ID', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像', `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系方式', `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态(1-正常 0-禁用)', `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户邮箱', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '修改人ID', `is_deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑删除标识(0-未删除 1-已删除)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user_notice -- ---------------------------- DROP TABLE IF EXISTS `sys_user_notice`; CREATE TABLE `sys_user_notice` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `notice_id` bigint(20) NOT NULL COMMENT '公共通知id', `user_id` bigint(20) NOT NULL COMMENT '用户id', `is_read` tinyint(4) NULL DEFAULT 0 COMMENT '读取状态（0: 未读, 1: 已读）', `read_time` datetime NULL DEFAULT NULL COMMENT '阅读时间', `create_time` datetime NOT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(0: 未删除, 1: 已删除)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户通知公告关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `user_id` bigint(20) NOT NULL COMMENT '用户ID', `role_id` bigint(20) NOT NULL COMMENT '角色ID', PRIMARY KEY (`user_id`, `role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户角色关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user_social -- ---------------------------- DROP TABLE IF EXISTS `sys_user_social`; CREATE TABLE `sys_user_social` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `platform` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '平台类型(WECHAT_MINI/WECHAT_MP/ALIPAY/QQ/APPLE)', `openid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '平台openid', `unionid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信unionid', `nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '第三方昵称', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '第三方头像URL', `session_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信session_key', `verified` tinyint(1) NULL DEFAULT 1 COMMENT '是否已验证(1-已验证 0-未验证)', `create_time` datetime NULL DEFAULT NULL COMMENT '绑定时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_platform_openid`(`platform` ASC, `openid` ASC) USING BTREE, INDEX `idx_user_id`(`user_id` ASC) USING BTREE, INDEX `idx_unionid`(`unionid` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户第三方账号绑定表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_distribution_account -- ---------------------------- DROP TABLE IF EXISTS `xxk_distribution_account`; CREATE TABLE `xxk_distribution_account` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '后台用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '会员ID', `available_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '可用佣金余额', `frozen_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '冻结佣金余额', `total_earned_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计获得佣金', `total_revoked_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计回退佣金', `total_transfer_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计转入钱包金额', `total_withdraw_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计提现金额', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(1正常 0禁用)', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_distribution_account_member_user_id`(`member_user_id` ASC) USING BTREE, UNIQUE INDEX `uk_xxk_distribution_account_user_id`(`user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '分销佣金账户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_distribution_account_flow -- ---------------------------- DROP TABLE IF EXISTS `xxk_distribution_account_flow`; CREATE TABLE `xxk_distribution_account_flow` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `flow_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '流水号', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '后台用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '会员ID', `commission_id` bigint(20) NULL DEFAULT NULL COMMENT '关联佣金记录ID', `biz_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务类型', `change_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '变动类型(IN/OUT)', `change_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动金额', `before_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动前余额', `after_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动后余额', `before_frozen_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动前冻结余额', `after_frozen_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动后冻结余额', `related_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联订单号', `related_wallet_flow_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联钱包流水号', `related_withdraw_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联提现单号', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `operate_by` bigint(20) NULL DEFAULT NULL COMMENT '操作人ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_distribution_account_flow_no`(`flow_no` ASC) USING BTREE, INDEX `idx_xxk_distribution_account_flow_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_distribution_account_flow_commission_id`(`commission_id` ASC) USING BTREE, INDEX `idx_xxk_distribution_account_flow_related_withdraw_no`(`related_withdraw_no` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '分销佣金账户流水表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_distribution_commission -- ---------------------------- DROP TABLE IF EXISTS `xxk_distribution_commission`; CREATE TABLE `xxk_distribution_commission` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NOT NULL COMMENT '佣金归属用户ID', `from_user_id` bigint(20) NOT NULL COMMENT '消费用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '佣金归属会员ID', `from_member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '消费会员ID', `order_id` bigint(20) NOT NULL COMMENT '订单ID', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号', `level_no` tinyint(4) NOT NULL COMMENT '层级(1/2)', `rate` decimal(10, 4) NOT NULL DEFAULT 0.0000 COMMENT '佣金比例', `base_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '佣金基数', `commission_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '佣金金额', `commission_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'PENDING' COMMENT '佣金状态', `confirm_time` datetime NULL DEFAULT NULL COMMENT '确认时间', `settle_time` datetime NULL DEFAULT NULL COMMENT '结算时间', `invalid_time` datetime NULL DEFAULT NULL COMMENT '失效时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_commission_user_status`(`user_id` ASC, `commission_status` ASC) USING BTREE, INDEX `idx_commission_order_id`(`order_id` ASC) USING BTREE, INDEX `idx_xxk_distribution_commission_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_distribution_commission_from_member_user_id`(`from_member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '分销佣金流水表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_distribution_config -- ---------------------------- DROP TABLE IF EXISTS `xxk_distribution_config`; CREATE TABLE `xxk_distribution_config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `distribution_enabled` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用分销(1-是 0-否)', `first_level_rate` decimal(10, 4) NOT NULL DEFAULT 0.0000 COMMENT '一级佣金比例', `second_level_rate` decimal(10, 4) NOT NULL DEFAULT 0.0000 COMMENT '二级佣金比例', `withdraw_threshold` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '提现门槛金额', `withdraw_fee_rate` decimal(10, 4) NOT NULL DEFAULT 0.0000 COMMENT '提现手续费比例', `settle_rule` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'OPEN_SUCCESS_AMOUNT' COMMENT '结算规则', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-启用 0-禁用)', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime 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; -- ---------------------------- -- Table structure for xxk_distribution_relation -- ---------------------------- DROP TABLE IF EXISTS `xxk_distribution_relation`; CREATE TABLE `xxk_distribution_relation` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '当前用户ID', `parent_user_id` bigint(20) NULL DEFAULT NULL COMMENT '一级上级用户ID', `grand_parent_user_id` bigint(20) NULL DEFAULT NULL COMMENT '二级上级用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '当前会员ID', `parent_member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '一级上级会员ID', `grand_parent_member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '二级上级会员ID', `bind_source` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '绑定来源', `bind_time` datetime NULL DEFAULT NULL COMMENT '绑定时间', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_distribution_user_id`(`user_id` ASC) USING BTREE, UNIQUE INDEX `uk_xxk_distribution_relation_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_distribution_parent_user_id`(`parent_user_id` ASC) USING BTREE, INDEX `idx_xxk_distribution_relation_parent_member_user_id`(`parent_member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '分销关系表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_distribution_withdraw_apply -- ---------------------------- DROP TABLE IF EXISTS `xxk_distribution_withdraw_apply`; CREATE TABLE `xxk_distribution_withdraw_apply` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `withdraw_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '提现单号', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `username_snapshot` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '会员账号快照', `nickname_snapshot` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '会员昵称快照', `mobile_snapshot` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '会员手机号快照', `withdraw_method_id` bigint(20) NULL DEFAULT NULL COMMENT '提现方式ID', `method_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '收款方式类型', `account_name_snapshot` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '收款人快照', `account_no_snapshot` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收款账号快照', `qr_code_url_snapshot` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收款码快照', `amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '申请提现金额', `paid_amount` decimal(18, 2) NULL DEFAULT NULL COMMENT '实际打款金额', `status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '状态(PENDING/APPROVED/REJECTED/PAID)', `submit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '申请备注', `submit_time` datetime NULL DEFAULT NULL COMMENT '申请时间', `audit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '审核备注', `audit_by` bigint(20) NULL DEFAULT NULL COMMENT '审核人', `audit_time` datetime NULL DEFAULT NULL COMMENT '审核时间', `pay_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '打款备注', `pay_proof_urls_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '打款凭证JSON', `pay_by` bigint(20) NULL DEFAULT NULL COMMENT '打款确认人', `pay_time` datetime NULL DEFAULT NULL COMMENT '打款时间', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_distribution_withdraw_apply_no`(`withdraw_no` ASC) USING BTREE, INDEX `idx_xxk_distribution_withdraw_apply_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_distribution_withdraw_apply_status`(`status` ASC) USING BTREE, INDEX `idx_xxk_distribution_withdraw_apply_submit_time`(`submit_time` ASC) USING BTREE, INDEX `idx_xxk_distribution_withdraw_apply_pay_time`(`pay_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '分销提现申请表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_distribution_withdraw_method -- ---------------------------- DROP TABLE IF EXISTS `xxk_distribution_withdraw_method`; CREATE TABLE `xxk_distribution_withdraw_method` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `method_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '收款方式(ALIPAY_ACCOUNT/ALIPAY_QR/WECHAT_QR)', `account_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '收款人姓名', `account_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收款账号', `qr_code_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收款码地址', `is_default` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否默认(1-是 0-否)', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(1-正常 0-禁用)', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_xxk_distribution_withdraw_method_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_distribution_withdraw_method_default`(`member_user_id` ASC, `is_default` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '分销提现收款方式表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_dynamic_channel -- ---------------------------- DROP TABLE IF EXISTS `xxk_dynamic_channel`; CREATE TABLE `xxk_dynamic_channel` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '会员ID', `order_id` bigint(20) NOT NULL COMMENT '订单ID', `order_item_id` bigint(20) NULL DEFAULT NULL COMMENT '订单项ID', `product_id` bigint(20) NOT NULL COMMENT '商品ID', `upstream_provider_id` bigint(20) NOT NULL COMMENT '上游供应商ID', `upstream_channel_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '上游通道ID', `channel_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通道名称', `channel_password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '通道密码', `channel_status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'ENABLED' COMMENT '通道状态', `flow_package_gb` decimal(12, 3) NOT NULL DEFAULT 0.000 COMMENT '购买流量包GB', `traffic_limit_gb` decimal(12, 3) NOT NULL DEFAULT 0.000 COMMENT '通道流量上限GB', `used_traffic_gb` decimal(12, 3) NOT NULL DEFAULT 0.000 COMMENT '已用流量GB', `remaining_traffic_gb` decimal(12, 3) NOT NULL DEFAULT 0.000 COMMENT '剩余流量GB', `expired_at` datetime NULL DEFAULT NULL COMMENT '到期时间', `allow_generate_proxy` tinyint(4) NULL DEFAULT 1 COMMENT '允许生成代理(1-是 0-否)', `last_sync_time` datetime NULL DEFAULT NULL COMMENT '最后同步时间', `raw_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '原始数据快照', `status` tinyint(4) NULL DEFAULT 1 COMMENT '业务状态(1-有效 0-无效)', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_dynamic_upstream_channel_id`(`upstream_channel_id` ASC) USING BTREE, INDEX `idx_dynamic_user_status`(`user_id` ASC, `status` ASC) USING BTREE, INDEX `idx_xxk_dynamic_channel_member_user_id`(`member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '动态通道表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_dynamic_channel_traffic_log -- ---------------------------- DROP TABLE IF EXISTS `xxk_dynamic_channel_traffic_log`; CREATE TABLE `xxk_dynamic_channel_traffic_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `channel_id` bigint(20) NOT NULL COMMENT '动态通道ID', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '会员ID', `date_type` tinyint(4) NULL DEFAULT NULL COMMENT '查询日期类型', `start_date` date NULL DEFAULT NULL COMMENT '开始日期', `end_date` date NULL DEFAULT NULL COMMENT '结束日期', `used_traffic_gb` decimal(12, 3) NOT NULL DEFAULT 0.000 COMMENT '已用流量GB', `total_traffic_gb` decimal(12, 3) NULL DEFAULT 0.000 COMMENT '累计流量GB', `raw_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '原始返回', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_channel_traffic_channel_id`(`channel_id` ASC, `create_time` ASC) USING BTREE, INDEX `idx_xxk_dynamic_channel_traffic_log_member_user_id`(`member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '动态通道流量日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_dynamic_proxy_generate_log -- ---------------------------- DROP TABLE IF EXISTS `xxk_dynamic_proxy_generate_log`; CREATE TABLE `xxk_dynamic_proxy_generate_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `channel_id` bigint(20) NOT NULL COMMENT '动态通道ID', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '会员ID', `location` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '地区参数', `domain` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'Global' COMMENT '域名参数', `sticky_session_time` int(11) NOT NULL DEFAULT 0 COMMENT '粘性会话分钟', `proxy_count` int(11) NOT NULL DEFAULT 1 COMMENT '生成数量', `state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '州', `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市', `generated_result` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '生成结果', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_generate_channel_id`(`channel_id` ASC, `create_time` ASC) USING BTREE, INDEX `idx_xxk_dynamic_proxy_generate_log_member_user_id`(`member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '动态代理生成日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_member_login_log -- ---------------------------- DROP TABLE IF EXISTS `xxk_member_login_log`; CREATE TABLE `xxk_member_login_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '会员ID', `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录手机号', `login_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '登录类型', `login_ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录IP', `login_region` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录地区', `device_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设备信息', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '登录结果(1成功 0失败)', `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '结果说明', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_xxk_member_login_log_user`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_member_login_log_mobile`(`mobile` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员登录日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_member_profile -- ---------------------------- DROP TABLE IF EXISTS `xxk_member_profile`; CREATE TABLE `xxk_member_profile` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `invite_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请码', `agent_level` tinyint(4) NOT NULL DEFAULT 2 COMMENT '代理级别(1一级代理 2二级代理)', `real_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '真实姓名', `id_card_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证号', `id_card_front_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证人像面', `id_card_back_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证国徽面', `support_docs_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '补充材料JSON', `company_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公司名称', `contact_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系人', `contact_wechat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系微信', `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系邮箱', `qq` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'QQ', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址', `industry` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '行业', `realname_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '实名状态(0未提交 1待审核 2已认证 3已驳回)', `last_verify_record_id` bigint(20) NULL DEFAULT NULL COMMENT '最近认证记录ID', `last_submit_time` datetime NULL DEFAULT NULL COMMENT '最近提交时间', `verified_time` datetime NULL DEFAULT NULL COMMENT '认证通过时间', `audit_time` datetime NULL DEFAULT NULL COMMENT '审核时间', `audit_by` bigint(20) NULL DEFAULT NULL COMMENT '审核人ID', `audit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '审核备注', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_member_profile_user`(`member_user_id` ASC) USING BTREE, UNIQUE INDEX `uk_xxk_member_profile_invite_code`(`invite_code` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员资料表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_member_user -- ---------------------------- DROP TABLE IF EXISTS `xxk_member_user`; CREATE TABLE `xxk_member_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名', `nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '昵称', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像', `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号', `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(1正常 0禁用)', `source` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'MANUAL' COMMENT '注册来源', `wx_openid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信openid', `wx_unionid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信unionid', `last_login_time` datetime NULL DEFAULT NULL COMMENT '最后登录时间', `last_login_ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '最后登录IP', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_member_user_username`(`username` ASC) USING BTREE, UNIQUE INDEX `uk_xxk_member_user_mobile`(`mobile` ASC) USING BTREE, INDEX `idx_xxk_member_user_status`(`status` ASC) USING BTREE, INDEX `idx_xxk_member_user_source`(`source` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员主账号表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_member_verify_record -- ---------------------------- DROP TABLE IF EXISTS `xxk_member_verify_record`; CREATE TABLE `xxk_member_verify_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `verify_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '认证单号', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `username_snapshot` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名快照', `nickname_snapshot` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '昵称快照', `mobile_snapshot` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号快照', `real_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '真实姓名', `id_card_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证号', `id_card_front_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证人像面', `id_card_back_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证国徽面', `support_docs_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '补充材料JSON', `policy_snapshot_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '策略快照JSON', `form_data_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '提交数据JSON', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(1待审核 2通过 3驳回)', `submit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '提交备注', `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间', `audit_time` datetime NULL DEFAULT NULL COMMENT '审核时间', `audit_by` bigint(20) NULL DEFAULT NULL COMMENT '审核人ID', `audit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '审核备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_member_verify_record_no`(`verify_no` ASC) USING BTREE, INDEX `idx_xxk_member_verify_record_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_member_verify_record_status`(`status` ASC) USING BTREE, INDEX `idx_xxk_member_verify_record_submit_time`(`submit_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员认证记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_member_wallet -- ---------------------------- DROP TABLE IF EXISTS `xxk_member_wallet`; CREATE TABLE `xxk_member_wallet` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '余额', `frozen_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '冻结金额', `total_recharge_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计充值金额', `total_consume_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计消费金额', `total_refund_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计退款金额', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(1正常 0禁用)', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_member_wallet_user`(`member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会员钱包表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_open_api_account -- ---------------------------- DROP TABLE IF EXISTS `xxk_open_api_account`; CREATE TABLE `xxk_open_api_account` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `open_api_app_id` bigint(20) NOT NULL COMMENT '开放应用ID', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '余额', `frozen_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '冻结余额', `total_recharge_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计充值金额', `total_consume_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计消费金额', `total_refund_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计退款金额', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(0停用 1正常)', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_open_api_account_app_id`(`open_api_app_id` ASC) USING BTREE, INDEX `idx_xxk_open_api_account_member_user_id`(`member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'API独立账户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_open_api_account_flow -- ---------------------------- DROP TABLE IF EXISTS `xxk_open_api_account_flow`; CREATE TABLE `xxk_open_api_account_flow` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `flow_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '流水号', `open_api_app_id` bigint(20) NOT NULL COMMENT '开放应用ID', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `biz_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务类型', `change_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '变动类型(IN/OUT)', `change_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动金额', `before_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动前余额', `after_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动后余额', `related_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联单号', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `operate_by` bigint(20) NULL DEFAULT NULL COMMENT '操作人ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_open_api_account_flow_no`(`flow_no` ASC) USING BTREE, INDEX `idx_xxk_open_api_account_flow_app_id`(`open_api_app_id` ASC) USING BTREE, INDEX `idx_xxk_open_api_account_flow_related_order_no`(`related_order_no` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'API独立账户流水表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_open_api_app -- ---------------------------- DROP TABLE IF EXISTS `xxk_open_api_app`; CREATE TABLE `xxk_open_api_app` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `app_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '应用ID', `app_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '应用名称', `app_secret` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '应用密钥', `member_user_id` bigint(20) NOT NULL COMMENT '绑定会员ID', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(0停用 1启用)', `allow_ip_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '允许访问IP列表，逗号/换行分隔', `callback_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '订单结果回调地址', `callback_secret` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '订单结果回调签名密钥', `last_auth_time` datetime NULL DEFAULT NULL COMMENT '最近换取token时间', `last_auth_ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '最近换取token IP', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_open_api_app_app_id`(`app_id` ASC) USING BTREE, UNIQUE INDEX `uk_xxk_open_api_app_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_open_api_app_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_open_api_app_status`(`status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '开放接口应用表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_open_api_apply -- ---------------------------- DROP TABLE IF EXISTS `xxk_open_api_apply`; CREATE TABLE `xxk_open_api_apply` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `apply_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '申请单号', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `username_snapshot` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名快照', `mobile_snapshot` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号快照', `contact_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '联系人', `contact_mobile` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话', `contact_email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系邮箱', `company_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公司名称', `purpose` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '申请用途', `scenario_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '使用场景说明', `allow_ip_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'IP白名单', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态(0待审核 1已通过 2已驳回)', `submit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '补充说明', `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间', `audit_time` datetime NULL DEFAULT NULL COMMENT '审核时间', `audit_by` bigint(20) NULL DEFAULT NULL COMMENT '审核人ID', `audit_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '审核备注', `open_api_app_id` bigint(20) NULL DEFAULT NULL COMMENT '关联开放应用ID', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_open_api_apply_no`(`apply_no` ASC) USING BTREE, INDEX `idx_xxk_open_api_apply_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_open_api_apply_status`(`status` ASC) USING BTREE, INDEX `idx_xxk_open_api_apply_submit_time`(`submit_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '开放接口申请表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_open_api_callback_log -- ---------------------------- DROP TABLE IF EXISTS `xxk_open_api_callback_log`; CREATE TABLE `xxk_open_api_callback_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `open_api_app_id` bigint(20) NOT NULL COMMENT '开放应用ID', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `order_id` bigint(20) NOT NULL COMMENT '订单ID', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号', `callback_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '回调地址', `event_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '事件类型', `request_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '请求报文', `response_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '响应报文', `response_status` int(11) NULL DEFAULT NULL COMMENT '响应HTTP状态码', `delivery_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'PENDING' COMMENT '投递状态(PENDING/SUCCESS/FAIL/SKIPPED)', `error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '错误信息', `attempt_no` int(11) NOT NULL DEFAULT 1 COMMENT '尝试次数', `trigger_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '触发时间', `finish_time` datetime NULL DEFAULT NULL COMMENT '完成时间', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_xxk_open_api_callback_log_app_id`(`open_api_app_id` ASC) USING BTREE, INDEX `idx_xxk_open_api_callback_log_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_xxk_open_api_callback_log_status`(`delivery_status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '开放API订单回调日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_open_api_recharge_order -- ---------------------------- DROP TABLE IF EXISTS `xxk_open_api_recharge_order`; CREATE TABLE `xxk_open_api_recharge_order` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `recharge_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '充值单号', `pay_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '支付单号', `open_api_app_id` bigint(20) NOT NULL COMMENT '开放应用ID', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `payment_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '支付方式', `pay_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '支付状态', `channel_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '渠道订单号', `channel_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '渠道响应', `client_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客户端类型', `return_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '回跳地址', `amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '充值金额', `gift_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '赠送金额', `credited_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '到账金额', `promotion_rule_snapshot` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '活动规则快照', `currency` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'USD' COMMENT '币种', `paid_time` datetime NULL DEFAULT NULL COMMENT '支付完成时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_open_api_recharge_no`(`recharge_no` ASC) USING BTREE, UNIQUE INDEX `uk_xxk_open_api_pay_order_no`(`pay_order_no` ASC) USING BTREE, INDEX `idx_xxk_open_api_recharge_order_app_id`(`open_api_app_id` ASC) USING BTREE, INDEX `idx_xxk_open_api_recharge_order_member_user_id`(`member_user_id` ASC) USING BTREE, INDEX `idx_xxk_open_api_recharge_order_pay_status`(`pay_status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'API独立账户充值单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_order_compensation_record -- ---------------------------- DROP TABLE IF EXISTS `xxk_order_compensation_record`; CREATE TABLE `xxk_order_compensation_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `order_id` bigint(20) NOT NULL COMMENT '订单ID', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号', `compensation_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '补偿类型', `attempt_no` int(11) NOT NULL DEFAULT 1 COMMENT '第几次补偿尝试', `compensation_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'PENDING' COMMENT '补偿状态(PENDING/SUCCESS/FAIL)', `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '补偿原因', `error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '失败原因', `related_flow_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联退款流水号', `operator_id` bigint(20) NULL DEFAULT NULL COMMENT '操作人ID', `operator_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作人名称', `execute_time` datetime NULL DEFAULT NULL COMMENT '执行时间', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_order_compensation_attempt`(`order_id` ASC, `compensation_type` ASC, `attempt_no` ASC) USING BTREE, INDEX `idx_xxk_order_compensation_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_xxk_order_compensation_status`(`compensation_status` ASC, `execute_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '订单补偿记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_order_operate_log -- ---------------------------- DROP TABLE IF EXISTS `xxk_order_operate_log`; CREATE TABLE `xxk_order_operate_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `order_id` bigint(20) NOT NULL COMMENT '订单ID', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号', `operate_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '操作类型', `before_status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作前状态', `after_status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作后状态', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '操作内容', `operator_id` bigint(20) NULL DEFAULT NULL COMMENT '操作人ID', `operator_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作人名称', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_order_operate_order_id`(`order_id` ASC, `create_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '订单操作日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_product -- ---------------------------- DROP TABLE IF EXISTS `xxk_product`; CREATE TABLE `xxk_product` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `product_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品编码', `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称', `product_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品类型(STATIC_RESIDENTIAL/DYNAMIC_RESIDENTIAL)', `upstream_provider_id` bigint(20) NOT NULL COMMENT '上游供应商ID', `upstream_product_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上游商品编码', `proxies_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上游代理类型', `proxies_format` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上游代理格式', `purpose_web` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上游用途参数', `upstream_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '上游扩展参数JSON', `upstream_capabilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '上游能力JSON', `protocols_type` tinyint(4) NULL DEFAULT NULL COMMENT '协议类型(1-HTTP 2-SOCKS5 3-HTTP+SOCKS5)', `udp_status` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用UDP(1-是 0-否)', `currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'RMB' COMMENT '币种', `enable_distribution` tinyint(4) NULL DEFAULT 1 COMMENT '是否参与分销(1-是 0-否)', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-上架 0-下架)', `sort` int(11) NULL DEFAULT 0 COMMENT '排序', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_product_code`(`product_code` ASC) USING BTREE, INDEX `idx_product_type_status`(`product_type` ASC, `status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品主表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_product_duration_multiplier -- ---------------------------- DROP TABLE IF EXISTS `xxk_product_duration_multiplier`; CREATE TABLE `xxk_product_duration_multiplier` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `product_id` bigint(20) NOT NULL COMMENT '商品ID', `duration_days` int(11) NOT NULL COMMENT '时长天数(30的整数倍)', `duration_unit` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'DAY' COMMENT '时长单位(DAY天/HOUR小时)', `duration_value` int(11) NOT NULL DEFAULT 1 COMMENT '时长数值', `multiplier` decimal(10, 4) NOT NULL DEFAULT 1.0000 COMMENT '价格倍率', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-启用 0-禁用)', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_product_duration_unit_value`(`product_id` ASC, `duration_unit` ASC, `duration_value` ASC) USING BTREE, INDEX `idx_product_duration_days`(`product_id` ASC, `duration_days` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商品时长倍率表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_product_dynamic_plan -- ---------------------------- DROP TABLE IF EXISTS `xxk_product_dynamic_plan`; CREATE TABLE `xxk_product_dynamic_plan` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `product_id` bigint(20) NOT NULL COMMENT '商品ID', `plan_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '流量套餐编码', `flow_gb` decimal(12, 3) NOT NULL DEFAULT 0.000 COMMENT '流量套餐GB', `base_price` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '流量套餐基础价', `allow_sticky_session` tinyint(4) NULL DEFAULT 1 COMMENT '允许粘性会话(1-是 0-否)', `allow_location_select` tinyint(4) NULL DEFAULT 1 COMMENT '允许地区选择(1-是 0-否)', `allow_custom_limit` tinyint(4) NULL DEFAULT 0 COMMENT '允许自定义通道流量上限(1-是 0-否)', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-启用 0-禁用)', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_plan_code`(`plan_code` ASC) USING BTREE, UNIQUE INDEX `uk_product_flow`(`product_id` ASC, `flow_gb` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '动态商品流量套餐表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_product_static_country_price -- ---------------------------- DROP TABLE IF EXISTS `xxk_product_static_country_price`; CREATE TABLE `xxk_product_static_country_price` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `product_id` bigint(20) NOT NULL COMMENT '商品ID', `price_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '价格类型(DEFAULT默认/NODE特殊节点)', `qiyun_product_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '齐云产品类型', `qiyun_pid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '齐云项目ID', `qiyun_project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '齐云项目名称', `qiyun_area_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '齐云省份ID', `qiyun_area_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '齐云省份名称', `qiyun_node_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '齐云节点ID', `qiyun_node_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '齐云节点名称', `region_id` bigint(20) NULL DEFAULT NULL COMMENT '地区ID', `region_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地区编号', `region_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地区名称', `region_name_zh` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地区中文名', `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '国家编码', `country_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '国家名称', `base_price` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '地区基础单价', `currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'RMB' COMMENT '币种', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-启用 0-禁用)', `sort` int(11) NULL DEFAULT 0 COMMENT '排序', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_country_code`(`country_code` ASC) USING BTREE, INDEX `idx_static_price_region_id`(`region_id` ASC) USING BTREE, INDEX `idx_product_country`(`product_id` ASC, `country_code` ASC) USING BTREE, INDEX `idx_static_price_qiyun_node`(`product_id` ASC, `price_type` ASC, `qiyun_node_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '静态商品地区定价表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_proxy_city -- ---------------------------- DROP TABLE IF EXISTS `xxk_proxy_city`; CREATE TABLE `xxk_proxy_city` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `city_cn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市中文名', `region_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家代码', `state` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '州/省', PRIMARY KEY (`id`, `city`) USING BTREE, UNIQUE INDEX `uk_proxy_city_country_city`(`region_code` ASC, `city` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 28633 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代理平台城市字典表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_proxy_city_library -- ---------------------------- DROP TABLE IF EXISTS `xxk_proxy_city_library`; CREATE TABLE `xxk_proxy_city_library` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `city_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '城市编号', `city_name_zh` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '城市中文名', `city_name_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '城市英文名', `country_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家编码', `country_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家名称', `icon_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '城市图标', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(1-启用 0-禁用)', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(1-已删 0-未删)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_proxy_city_library_code_country`(`city_code` ASC, `country_code` ASC, `is_deleted` ASC) USING BTREE, INDEX `idx_proxy_city_library_country_status`(`country_code` ASC, `status` ASC, `is_deleted` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代理平台城市库' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_proxy_order -- ---------------------------- DROP TABLE IF EXISTS `xxk_proxy_order`; CREATE TABLE `xxk_proxy_order` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号', `member_user_id` bigint(20) NULL DEFAULT NULL, `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `product_id` bigint(20) NOT NULL COMMENT '商品ID', `product_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品类型', `order_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NEW' COMMENT '订单类型(NEW/RENEW)', `order_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'WAIT_PAY' COMMENT '订单状态', `pay_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'UNPAID' COMMENT '支付状态', `open_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'WAIT_OPEN' COMMENT '开通状态', `payment_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'BALANCE' COMMENT '支付方式', `currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'RMB' COMMENT '币种', `buy_quantity` int(11) NOT NULL DEFAULT 1 COMMENT '购买数量', `duration_days` int(11) NOT NULL COMMENT '购买天数', `sale_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '销售金额', `paid_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '实付金额', `cost_amount` decimal(18, 2) NULL DEFAULT 0.00 COMMENT '采购成本', `open_success_amount` decimal(18, 2) NULL DEFAULT 0.00 COMMENT '开通成功金额', `region_snapshot` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '地区快照', `product_snapshot` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '商品快照', `inviter_user_id` bigint(20) NULL DEFAULT NULL COMMENT '一级邀请人', `parent_inviter_user_id` bigint(20) NULL DEFAULT NULL COMMENT '二级邀请人', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `pay_time` datetime NULL DEFAULT NULL COMMENT '支付时间', `open_time` datetime NULL DEFAULT NULL COMMENT '开通时间', `finish_time` datetime NULL DEFAULT NULL COMMENT '完成时间', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', `compensation_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `compensation_retry_count` int(11) NULL DEFAULT NULL, `compensation_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `last_compensation_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_order_user_time`(`user_id` ASC, `create_time` ASC) USING BTREE, INDEX `idx_order_status`(`order_status` ASC, `pay_status` ASC, `open_status` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代理订单主表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_proxy_order_item -- ---------------------------- DROP TABLE IF EXISTS `xxk_proxy_order_item`; CREATE TABLE `xxk_proxy_order_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `order_id` bigint(20) NOT NULL COMMENT '订单ID', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单号', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL, `product_id` bigint(20) NOT NULL COMMENT '商品ID', `product_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品类型', `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家编码', `country_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家名称', `quantity` int(11) NOT NULL DEFAULT 1 COMMENT '数量', `duration_days` int(11) NOT NULL COMMENT '时长天数', `duration_multiplier` decimal(10, 4) NOT NULL DEFAULT 1.0000 COMMENT '时长倍率', `unit_price` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '单价', `line_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '小计金额', `flow_gb` decimal(12, 3) NULL DEFAULT NULL COMMENT '动态流量GB', `upstream_payload` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '上游请求快照', `item_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'INIT' COMMENT '订单项状态', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_order_item_order_id`(`order_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代理订单项表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_proxy_order_pay -- ---------------------------- DROP TABLE IF EXISTS `xxk_proxy_order_pay`; CREATE TABLE `xxk_proxy_order_pay` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `pay_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '支付单号', `order_id` bigint(20) NOT NULL COMMENT '业务订单ID', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务订单号', `payment_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '支付方式(BALANCE/ALIPAY/WECHAT/EXTERNAL)', `pay_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'INIT' COMMENT '支付单状态(INIT/PAYING/PAID/FAIL/CLOSED/REFUNDED)', `channel_order_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '渠道支付单号', `channel_response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '渠道原始响应', `client_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客户端类型(PC/H5/APP/MINI_PROGRAM)', `return_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '支付完成跳转地址', `amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '支付金额', `currency` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '币种', `paid_time` datetime NULL DEFAULT NULL COMMENT '支付成功时间', `expire_time` datetime NULL DEFAULT NULL COMMENT '支付过期时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_proxy_order_pay_no`(`pay_order_no` ASC) USING BTREE, INDEX `idx_xxk_proxy_order_pay_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_xxk_proxy_order_pay_status`(`pay_status` ASC, `update_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '订单支付记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_proxy_payment_notify_log -- ---------------------------- DROP TABLE IF EXISTS `xxk_proxy_payment_notify_log`; CREATE TABLE `xxk_proxy_payment_notify_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `pay_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '支付单号', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '业务订单号', `payment_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '支付方式', `notify_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '通知类型(PAY/REFUND/CLOSE)', `notify_body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '通知原文', `verify_status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'INIT' COMMENT '验签状态(INIT/SUCCESS/FAIL)', `process_status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'INIT' COMMENT '处理状态(INIT/SUCCESS/FAIL)', `error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '失败原因', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_xxk_proxy_payment_notify_order_no`(`order_no` ASC) USING BTREE, INDEX `idx_xxk_proxy_payment_notify_status`(`verify_status` ASC, `process_status` ASC, `update_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '支付回调日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_proxy_region -- ---------------------------- DROP TABLE IF EXISTS `xxk_proxy_region`; CREATE TABLE `xxk_proxy_region` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `region_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '地区编号', `region_name_zh` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '地区中文名', `region_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '地区名称', `icon_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地区图标', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-启用 0-禁用)', `sort` int(11) NULL DEFAULT 0 COMMENT '排序', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0000 COMMENT '是否删除(1-已删 0-未删)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_proxy_region_code_deleted`(`region_code` ASC, `is_deleted` ASC) USING BTREE, INDEX `idx_proxy_region_status`(`status` ASC, `is_deleted` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 206 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代理平台地区管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_static_proxy_asset -- ---------------------------- DROP TABLE IF EXISTS `xxk_static_proxy_asset`; CREATE TABLE `xxk_static_proxy_asset` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '会员ID', `order_id` bigint(20) NOT NULL COMMENT '订单ID', `order_item_id` bigint(20) NULL DEFAULT NULL COMMENT '订单项ID', `product_id` bigint(20) NOT NULL COMMENT '商品ID', `upstream_provider_id` bigint(20) NOT NULL COMMENT '上游供应商ID', `upstream_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上游订单号', `upstream_proxy_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '上游代理ID', `proxy_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '代理IP', `port` int(11) NOT NULL COMMENT '端口', `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '账号', `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码', `protocols` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '协议', `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家编码', `country_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家名称', `city_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市名称', `proxy_status` tinyint(4) NULL DEFAULT 1 COMMENT '代理状态(1-正常 2-禁用 3-维护)', `is_auto_renew` tinyint(4) NULL DEFAULT 0 COMMENT '自动续费(1-开 0-关)', `expired_at` datetime NULL DEFAULT NULL COMMENT '到期时间', `last_sync_time` datetime NULL DEFAULT NULL COMMENT '最后同步时间', `raw_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '原始数据快照', `status` tinyint(4) NULL DEFAULT 1 COMMENT '业务状态(1-有效 0-无效)', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_static_upstream_proxy_id`(`upstream_proxy_id` ASC) USING BTREE, INDEX `idx_static_user_status`(`user_id` ASC, `status` ASC) USING BTREE, INDEX `idx_static_expired_at`(`expired_at` ASC) USING BTREE, INDEX `idx_xxk_static_proxy_asset_member_user_id`(`member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '静态代理资产表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_static_proxy_change_log -- ---------------------------- DROP TABLE IF EXISTS `xxk_static_proxy_change_log`; CREATE TABLE `xxk_static_proxy_change_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `asset_id` bigint(20) NOT NULL COMMENT '静态资产ID', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `change_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '变更类型', `before_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '变更前', `after_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '变更后', `operator_id` bigint(20) NULL DEFAULT NULL COMMENT '操作人ID', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_static_change_asset_id`(`asset_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '静态代理变更日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_static_proxy_whitelist -- ---------------------------- DROP TABLE IF EXISTS `xxk_static_proxy_whitelist`; CREATE TABLE `xxk_static_proxy_whitelist` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL COMMENT '会员ID', `product_id` bigint(20) NULL DEFAULT NULL COMMENT '商品ID', `proxy_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '静态代理类型', `whitelist_ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '白名单IP', `upstream_address_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上游白名单记录ID', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-有效 0-删除)', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_user_whitelist_ip`(`user_id` ASC, `whitelist_ip` ASC) USING BTREE, UNIQUE INDEX `uk_member_whitelist_ip`(`member_user_id` ASC, `whitelist_ip` ASC) USING BTREE, INDEX `idx_xxk_static_proxy_whitelist_member_user_id`(`member_user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '静态代理白名单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_upstream_provider -- ---------------------------- DROP TABLE IF EXISTS `xxk_upstream_provider`; CREATE TABLE `xxk_upstream_provider` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `provider_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '供应商编码', `provider_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '供应商名称', `provider_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '供应商类型', `base_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '接口基础地址', `auth_user_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上游UserId', `auth_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上游Token', `success_codes` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '1000,2001' COMMENT '成功业务码集合', `http_timeout_ms` int(11) NULL DEFAULT 10000 COMMENT '超时时间(毫秒)', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-启用 0-禁用)', `is_default` tinyint(4) NULL DEFAULT 0 COMMENT '默认供应商(1-是 0-否)', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_provider_code`(`provider_code` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '上游供应商配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_upstream_request_log -- ---------------------------- DROP TABLE IF EXISTS `xxk_upstream_request_log`; CREATE TABLE `xxk_upstream_request_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `provider_id` bigint(20) NOT NULL COMMENT '供应商ID', `biz_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务类型', `api_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '接口名称', `request_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '请求地址', `request_headers` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '请求头', `request_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '请求体', `response_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '响应体', `http_status` int(11) NULL DEFAULT NULL COMMENT 'HTTP状态码', `biz_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '业务码', `success_flag` tinyint(4) NULL DEFAULT 0 COMMENT '是否成功(1-是 0-否)', `duration_ms` int(11) NULL DEFAULT NULL COMMENT '耗时毫秒', `error_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '异常信息', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_request_provider_time`(`provider_id` ASC, `create_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 128 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '上游请求日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_user_profile -- ---------------------------- DROP TABLE IF EXISTS `xxk_user_profile`; CREATE TABLE `xxk_user_profile` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NOT NULL COMMENT '关联sys_user.id', `user_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'CUSTOMER' COMMENT '用户类型', `invite_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请码', `register_source` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '注册来源', `register_ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '注册IP', `last_login_ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '最后登录IP', `last_login_time` datetime NULL DEFAULT NULL COMMENT '最后登录时间', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-正常 0-禁用)', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `is_deleted` tinyint(4) NULL DEFAULT 0 COMMENT '逻辑删除(1-已删除 0-未删除)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_user_id`(`user_id` ASC) USING BTREE, UNIQUE INDEX `uk_invite_code`(`invite_code` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户业务扩展表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_wallet_account -- ---------------------------- DROP TABLE IF EXISTS `xxk_wallet_account`; CREATE TABLE `xxk_wallet_account` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `member_user_id` bigint(20) NULL DEFAULT NULL, `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '可用余额', `frozen_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '冻结余额', `total_recharge_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计充值金额', `total_consume_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计消费金额', `total_refund_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '累计退款金额', `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态(1-正常 0-禁用)', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_wallet_user_id`(`user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '钱包账户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_wallet_flow -- ---------------------------- DROP TABLE IF EXISTS `xxk_wallet_flow`; CREATE TABLE `xxk_wallet_flow` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `flow_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '流水号', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `member_user_id` bigint(20) NULL DEFAULT NULL, `biz_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务类型', `change_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '变动类型(IN/OUT)', `change_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动金额', `before_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动前余额', `after_balance` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '变动后余额', `related_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联订单号', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `operate_by` bigint(20) NULL DEFAULT NULL COMMENT '操作人ID', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_flow_no`(`flow_no` ASC) USING BTREE, INDEX `idx_wallet_user_time`(`user_id` ASC, `create_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '钱包流水表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxk_wallet_recharge_order -- ---------------------------- DROP TABLE IF EXISTS `xxk_wallet_recharge_order`; CREATE TABLE `xxk_wallet_recharge_order` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `recharge_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '充值单号', `pay_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '支付单号', `member_user_id` bigint(20) NOT NULL COMMENT '会员ID', `payment_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '支付方式(ALIPAY/WECHAT)', `pay_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'INIT' COMMENT '支付状态(INIT/PAYING/PAID/FAIL/CLOSED)', `channel_order_no` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '渠道支付单号', `channel_response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '渠道原始响应', `client_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客户端类型(PC/H5/APP/MINI_PROGRAM)', `return_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '支付完成跳转地址', `amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '充值金额', `gift_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '充值赠送金额', `credited_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '实际到账金额', `promotion_rule_snapshot` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '命中的充值活动规则快照', `currency` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'CNY' COMMENT '币种', `paid_time` datetime NULL DEFAULT NULL COMMENT '支付成功时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除(0否 1是)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_xxk_wallet_recharge_no`(`recharge_no` ASC) USING BTREE, UNIQUE INDEX `uk_xxk_wallet_recharge_pay_order_no`(`pay_order_no` ASC) USING BTREE, INDEX `idx_xxk_wallet_recharge_member_status`(`member_user_id` ASC, `pay_status` ASC, `create_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '钱包在线充值单' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;