CREATE TABLE IF NOT EXISTS `bim_stg_job_result` (
    `pk_bim_stg_job_result` INT NOT NULL AUTO_INCREMENT,
    `job_id` varchar(255)  not null,
    `job_name` varchar(255),
    `job_type` varchar(255),
    `dataset_id` int,
    `dataset_name` varchar(255),
    `started_at` BIGINT  DEFAULT NULL,
    `finished_at` BIGINT DEFAULT NULL,
    `execution_result` varchar(255),
    `message` text,
    `output` varchar(255),
    `input` varchar(255),
    `processing_time` int,
    `processed_records` int,
    `memory_usage` bigint,
    `memory_diff` bigint,
  PRIMARY KEY (`pk_bim_stg_job_result`)
) ENGINE = InnoDB DEFAULT CHARSET=utf8;
