AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.176.sql

-- S1 订单评审编排运行日志表
-- 版本：1.0.176

SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS aidop_action_run_log (
    id BIGINT NOT NULL PRIMARY KEY COMMENT '主键',
    tenant_id BIGINT NULL COMMENT '租户ID',
    action_code VARCHAR(80) NOT NULL COMMENT '动作编码',
    biz_type VARCHAR(80) NOT NULL COMMENT '业务类型',
    biz_id BIGINT NULL COMMENT '业务主键',
    biz_no VARCHAR(128) NULL COMMENT '业务单号',
    status VARCHAR(20) NOT NULL COMMENT 'RUNNING/SUCCESS/FAILED',
    message VARCHAR(1000) NULL COMMENT '结果摘要',
    detail_json JSON NULL COMMENT '明细JSON',
    start_time DATETIME NOT NULL COMMENT '开始时间',
    end_time DATETIME NULL COMMENT '结束时间',
    create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    KEY idx_aidop_action_run_log_tenant_action (tenant_id, action_code, start_time),
    KEY idx_aidop_action_run_log_biz (biz_type, biz_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Ai-DOP 业务动作运行日志';