create table sj_job_log_message
(
    id            bigint unsigned auto_increment comment '主键'
        primary key,
    namespace_id  varchar(64)  default '764d604ec6fc45f68cd92514c40e9e1a' not null comment '命名空间id',
    group_name    varchar(64)                                             not null comment '组名称',
    job_id        bigint                                                  not null comment '任务信息id',
    task_batch_id bigint                                                  not null comment '任务批次id',
    task_id       bigint                                                  not null comment '调度任务id',
    message       longtext                                                not null comment '调度信息',
    log_num       int          default 1                                  not null comment '日志数量',
    real_time     bigint       default 0                                  not null comment '上报时间',
    ext_attrs     varchar(256) default ''                                 null comment '扩展字段',
    create_dt     datetime     default CURRENT_TIMESTAMP                  not null comment '创建时间'
)
    comment '调度日志';

create index idx_create_dt
    on sj_job_log_message (create_dt);

create index idx_namespace_id_group_name
    on sj_job_log_message (namespace_id, group_name);

create index idx_task_batch_id_task_id
    on sj_job_log_message (task_batch_id, task_id);

