/*
 Navicat Premium Dump SQL

 Source Server         : dev4_192.168.1.127
 Source Server Type    : MySQL
 Source Server Version : 80020 (8.0.20)
 Source Host           : 192.168.1.127:3606
 Source Schema         : oa_bridge

 Target Server Type    : MySQL
 Target Server Version : 80020 (8.0.20)
 File Encoding         : 65001

 Date: 10/03/2026 14:36:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for oa_files
-- ----------------------------
DROP TABLE IF EXISTS `oa_files`;
CREATE TABLE `oa_files`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '文件名称（含扩展名）',
  `file_path` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '文件存储路径（本地/共享盘/URL/对象存储）',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  `upload_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上传时间',
  `upload_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '上传人（姓名或账号）',
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '软删除标记：0正常 1已删除',
  `delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间（软删除时写入）',
  `file_size` bigint UNSIGNED NULL DEFAULT NULL COMMENT '文件字节数',
  `hash_sha256` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件SHA-256十六进制小写',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `tenant_id` json NOT NULL COMMENT '企业id',
  `is_system_default` tinyint NULL DEFAULT 0 COMMENT '0非系统1系统',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_upload_time`(`upload_time` ASC) USING BTREE,
  INDEX `idx_upload_by`(`upload_by` ASC) USING BTREE,
  INDEX `idx_file_name`(`file_name` ASC) USING BTREE,
  INDEX `idx_is_deleted_time`(`is_deleted` ASC, `upload_time` ASC) USING BTREE,
  INDEX `idx_hash`(`hash_sha256` ASC) USING BTREE,
  CONSTRAINT `chk_h  CONSTR56_format` CHECK ((`hash_sha256` is null) or regexp_like(`hash_sha256`,_utf8mb4'^[0-9a-f]{64}$'))
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Excel dll 插件用的文件元数据表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_files_extensions
-- ----------------------------
DROP TABLE IF EXISTS `oa_files_extensions`;
CREATE TABLE `oa_files_extensions`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `oa_files_id` bigint UNSIGNED NOT NULL COMMENT '关联oa_files表主键',
  `company_id` bigint NOT NULL COMMENT '企业id',
  `is_active` tinyint NULL DEFAULT 0 COMMENT '0非激活1激活',
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '软删除标记：0正常 1已删除',
  `delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间（软删除时写入）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_oa_files_id`(`oa_files_id` ASC) USING BTREE,
  INDEX `idx_company_file_active`(`company_id` ASC, `oa_files_id` ASC, `is_deleted` ASC, `is_active` ASC) USING BTREE,
  INDEX `idx_file_active`(`oa_files_id` ASC, `is_deleted` ASC, `is_active` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 180 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Excel dll 插件用的文件元数据表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_partner_config
-- ----------------------------
DROP TABLE IF EXISTS `oa_partner_config`;
CREATE TABLE `oa_partner_config`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `tenant_id` bigint NOT NULL COMMENT '企业租户ID',
  `partner_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '对方系统简称',
  `api_host_test` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '域名（IP+端口）测试用',
  `api_host_production` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '域名（IP+端口）正式用',
  `zpy_token` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'zpy token（账号、密码）',
  `oa_token` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'oa token（账号、密码）',
  `ip_allow_list` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IP白名单（逗号分隔）',
  `max_retry_count` int NULL DEFAULT 3 COMMENT '最大重试次数',
  `retry_interval_seconds` int NULL DEFAULT 60 COMMENT '重试间隔秒',
  `status` tinyint NULL DEFAULT 1 COMMENT '0-停用，1-启用',
  `created_by` bigint NULL DEFAULT NULL COMMENT '创建人',
  `updated_by` bigint NULL DEFAULT NULL COMMENT '更新人',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `capacity_uid` bigint NOT NULL COMMENT '企业配置ID',
  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 oa_partner_token_log
-- ----------------------------
DROP TABLE IF EXISTS `oa_partner_token_log`;
CREATE TABLE `oa_partner_token_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `tenant_id` bigint NOT NULL COMMENT '企业租户ID',
  `token` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '生成的 token',
  `expire_time` datetime NOT NULL COMMENT '过期时间',
  `status` tinyint NOT NULL COMMENT '0-失效，1-有效',
  `created_by` bigint NULL DEFAULT NULL COMMENT '创建人',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `capacity_uid` bigint NOT NULL COMMENT '企业配置ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Token生成记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_process
-- ----------------------------
DROP TABLE IF EXISTS `oa_process`;
CREATE TABLE `oa_process`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `uuid` bigint NOT NULL COMMENT '数据唯一标识(UUID)',
  `process_type` int NOT NULL COMMENT '流程分类类型：1初评、2正评',
  `process_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '流程显示名称',
  `process_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '流程唯一标识符',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录最后更新时间',
  `created_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建者用户ID或名称',
  `sort_order` int NOT NULL DEFAULT 0 COMMENT '显示排序序号',
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否启用(1启用/0禁用)',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` timestamp NULL DEFAULT NULL COMMENT '删除时间',
  `tenant_id` json NOT NULL COMMENT '企业id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_oa_process_uuid`(`uuid` ASC) USING BTREE,
  INDEX `idx_oa_process_type`(`process_type` ASC) USING BTREE,
  INDEX `idx_oa_is_active_sort`(`is_active` ASC, `sort_order` ASC) USING BTREE,
  CONSTRAINT `chk_oa_is_active` CHECK (`is_active` in (0,1)),
  CONSTRAINT `chk_oa_process_type` CHECK (`process_type` in (1,2))
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '流程表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_project_create_receive
-- ----------------------------
DROP TABLE IF EXISTS `oa_project_create_receive`;
CREATE TABLE `oa_project_create_receive`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `tenant_id` bigint NOT NULL COMMENT '企业租户ID',
  `token_log_id` bigint NULL DEFAULT NULL COMMENT '关联oa_partner_token_log.id',
  `push_receive_id` bigint NOT NULL COMMENT '关联oa_push_receive_log.id',
  `project_group_uuid` bigint NULL DEFAULT NULL COMMENT '项目组唯一ID',
  `project_name` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目名称',
  `project_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目编号',
  `do_organ` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组织',
  `project_main_person` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目负责人',
  `project_main_person_mobile` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目负责人手机号',
  `status` tinyint NULL DEFAULT 0 COMMENT '0-待处理，1-已处理，2-处理失败',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `do_organ_zpy` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '智评云组织',
  `oa_project_create_receive_main_id` bigint NOT NULL COMMENT '主表ID',
  `create_by` bigint NULL DEFAULT NULL COMMENT '创建人',
  `source_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求来源IP',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_main_id`(`oa_project_create_receive_main_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目创建接收表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_project_create_receive_main
-- ----------------------------
DROP TABLE IF EXISTS `oa_project_create_receive_main`;
CREATE TABLE `oa_project_create_receive_main`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `tenant_id` bigint NOT NULL COMMENT '企业租户ID',
  `project_group_uuid` bigint NULL DEFAULT NULL COMMENT '项目组唯一ID',
  `project_group_create_by` bigint NULL DEFAULT NULL COMMENT '项目组创建人ID',
  `project_group_create_time` datetime NULL DEFAULT NULL COMMENT '项目组创建时间',
  `project_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目编号',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` bigint NULL DEFAULT NULL COMMENT '创建人',
  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 oa_project_group_details
-- ----------------------------
DROP TABLE IF EXISTS `oa_project_group_details`;
CREATE TABLE `oa_project_group_details`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `tenant_id` bigint NOT NULL COMMENT '企业租户ID',
  `project_group_uuid` bigint NOT NULL COMMENT '项目组唯一ID',
  `project_group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目组名称',
  `project_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目编号',
  `is_associated` tinyint NULL DEFAULT 0 COMMENT '关联类型：0-未关联 1-已关联',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `deleted_by` bigint NULL DEFAULT NULL COMMENT '删除人',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` bigint NULL DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_oa_project_group_details_group_uuid`(`project_group_uuid` ASC) USING BTREE,
  INDEX `idx_oa_project_group_details_project_code`(`project_code` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目创建推送主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_project_group_relation
-- ----------------------------
DROP TABLE IF EXISTS `oa_project_group_relation`;
CREATE TABLE `oa_project_group_relation`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `tenant_id` bigint NOT NULL COMMENT '企业租户ID',
  `project_group_uuid` bigint NOT NULL COMMENT '项目组唯一ID',
  `project_group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目组名称',
  `old_project_group_uuid` bigint NULL DEFAULT NULL COMMENT '旧的项目组唯一ID',
  `old_project_group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '旧的项目组名称',
  `project_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目编号',
  `oa_project_create_receive_main_id` bigint NULL DEFAULT NULL COMMENT '关联的OA项目创建接收主表ID',
  `relation_type` tinyint NULL DEFAULT 0 COMMENT '关联类型：-1-未关联 0-项目组创建，1-项目组关联',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `deleted_by` bigint NULL DEFAULT NULL COMMENT '删除人',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` bigint NULL DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_oa_project_group_relation_group_uuid`(`project_group_uuid` ASC) USING BTREE,
  INDEX `idx_oa_project_create_receive_main_id`(`oa_project_create_receive_main_id` ASC) USING BTREE,
  INDEX `idx_oa_project_group_relation_project_code`(`project_code` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目创建推送主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_push_receive_log
-- ----------------------------
DROP TABLE IF EXISTS `oa_push_receive_log`;
CREATE TABLE `oa_push_receive_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `tenant_id` bigint NOT NULL COMMENT '企业租户ID',
  `token_log_id` bigint NULL DEFAULT NULL COMMENT '关联oa_partner_token_log.id',
  `request_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '接收的JSON请求体',
  `receive_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '接收时间',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `response_body` json NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'OA推送接收记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_push_retry_log
-- ----------------------------
DROP TABLE IF EXISTS `oa_push_retry_log`;
CREATE TABLE `oa_push_retry_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `tenant_id` bigint NOT NULL COMMENT '企业租户ID',
  `partner_id` bigint NOT NULL COMMENT '关联oa_partner_config.id',
  `oa_project_create_receive_main_id` bigint NOT NULL COMMENT '关联oa_project_create_receive_main.id',
  `oa_project_create_receive_id` bigint NOT NULL COMMENT '关联oa_project_create_receive.id',
  `project_group_uuid` bigint NOT NULL COMMENT '项目组唯一ID',
  `push_type` enum('初审推送','正评推送') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '推送类型',
  `request_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '推送内容',
  `response_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '返回内容',
  `status` tinyint NOT NULL COMMENT '0-待重试，1-成功，2-失败',
  `retry_count` int NULL DEFAULT 0 COMMENT '已重试次数',
  `max_retry_count` int NULL DEFAULT 3 COMMENT '最大重试次数快照',
  `next_retry_time` datetime NULL DEFAULT NULL COMMENT '下次重试时间',
  `last_retry_time` datetime NULL DEFAULT NULL COMMENT '上次重试时间',
  `draft_file_id` bigint NULL DEFAULT NULL COMMENT '底稿文件包在TJ_Files表中的ID，OA方需求变更为不提交压缩包，因此该字段暂不使用',
  `report_file_id` bigint NULL DEFAULT NULL COMMENT '报告文件包在TJ_Files表中的ID，OA方需求变更为不提交压缩包，因此该字段暂不使用',
  `desc_file_id` bigint(20) UNSIGNED ZEROFILL NULL DEFAULT NULL COMMENT '说明文件包在TJ_Files表中的ID，OA方需求变更为不提交压缩包，因此该字段暂不使用',
  `is_deleted` tinyint NULL DEFAULT 0 COMMENT '是否删除',
  `deleted_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` bigint NULL DEFAULT NULL COMMENT '创建人',
  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE,
  INDEX `idx_project_group_uuid`(`project_group_uuid` ASC) USING BTREE,
  INDEX `idx_oa_project_create_receive_id`(`oa_project_create_receive_id` ASC) USING BTREE,
  INDEX `idx_oa_project_create_receive_main_id`(`oa_project_create_receive_main_id` ASC) USING BTREE,
  INDEX `idx_status_next_retry`(`status` ASC, `next_retry_time` ASC) USING BTREE,
  INDEX `idx_status`(`status` ASC) USING BTREE,
  INDEX `idx_create_time`(`create_time` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '推送失败与重试记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oa_push_retry_log_detail
-- ----------------------------
DROP TABLE IF EXISTS `oa_push_retry_log_detail`;
CREATE TABLE `oa_push_retry_log_detail`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tenant_id` bigint UNSIGNED NOT NULL COMMENT '企业租户ID',
  `oa_push_retry_log_id` bigint UNSIGNED NOT NULL COMMENT '项目组提交记录ID',
  `oa_project_create_receive_main_id` bigint NOT NULL COMMENT '关联oa_project_create_receive_main.id',
  `oa_project_create_receive_id` bigint NOT NULL COMMENT '关联oa_project_create_receive.id',
  `project_group_uuid` bigint NOT NULL COMMENT '项目组唯一ID',
  `company_project_id` bigint UNSIGNED NOT NULL COMMENT '被评估公司项目ID',
  `company_project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '被评估公司项目名称',
  `income_approach_related_draft_id` bigint NULL DEFAULT NULL COMMENT '收益法关联底稿ID',
  `income_approach_related_draft_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收益法底稿名称',
  `market_approach_related_draft_id` bigint NULL DEFAULT NULL COMMENT '市场法关联底稿ID',
  `market_approach_related_draft_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市场法底稿名称',
  `asset_based_approach_related_draft_id` bigint NULL DEFAULT NULL COMMENT '资产基础法关联底稿ID',
  `asset_based_approach_related_draft_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '资产基础法底稿名称',
  `single_asset_draft_id` bigint NULL DEFAULT NULL COMMENT '单项资产底稿ID',
  `single_asset_draft_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单项资产底稿名称',
  `income_approach_draft_check_status` tinyint NULL DEFAULT 0 COMMENT '收益法底稿检查状态：0-未检，1-通过，2-驳回',
  `market_approach_draft_check_status` tinyint NULL DEFAULT 0 COMMENT '市场法底稿检查状态',
  `asset_based_approach_draft_check_status` tinyint NULL DEFAULT 0 COMMENT '资产基础法底稿检查状态',
  `single_asset_draft_check_status` tinyint NULL DEFAULT 0 COMMENT '单项资产底稿检查状态',
  `related_report_id` bigint NULL DEFAULT NULL COMMENT '关联报告ID',
  `related_report_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联报告名称',
  `related_explanation_id` bigint NULL DEFAULT NULL COMMENT '关联说明ID',
  `related_explanation_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联说明名称',
  `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `created_by` bigint NULL DEFAULT NULL COMMENT '创建人',
  `updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_project_group_submit`(`oa_push_retry_log_id` ASC) USING BTREE,
  INDEX `idx_company_project`(`company_project_id` ASC) USING BTREE,
  INDEX `idx_income_draft_status`(`income_approach_draft_check_status` ASC) USING BTREE,
  INDEX `idx_market_draft_status`(`market_approach_draft_check_status` ASC) USING BTREE,
  INDEX `idx_asset_draft_status`(`asset_based_approach_draft_check_status` ASC) USING BTREE,
  INDEX `idx_single_draft_status`(`single_asset_draft_check_status` ASC) USING BTREE,
  INDEX `idx_related_report`(`related_report_id` ASC) USING BTREE,
  INDEX `idx_related_explanation`(`related_explanation_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目组提交底稿详情表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;