| 123456789101112131415161718192021 |
- -- 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 业务动作运行日志';
|
