CREATE TABLE DAILY_INTEGRATION_BATCH_RECORDS(
    DATETIME_OF_SCRIPT_EXECUTION TEXT,
    DATE_OF_VMQ_JOB TEXT,
    DAY TEXT,
    VMQ_JOB TEXT,
    NUMBER_OF_PRS_IN_JOB INT,
    ACTUAL_PRS TEXT,

    PRS_MERGED INT,
    PRS_NEEDING_FURTHER_INVESTIGATION INT,

    MERGED_BISECT TEXT,

    BUILD_STATUS TEXT,
    BUILD_NOTES TEXT,

    DEPLOY_BUILD_STATUS TEXT,
    DEPLOY_BUILD_NUMBER_OF_RETRIES INT,

    CLANG_STATUS TEXT,
    CLANG_DETECTED_FAILURE TEXT,
    CLANG_NUMBER_OF_RETRIES INT,
    CLANG_READY TEXT,
    CLANG_DURATION_FOR_READY_HRS FLOAT,
    CLANG_DURATION_FOR_SIGNOFF_HRS FLOAT,
    CLANG_TOTAL_DURATION_HRS FLOAT,
    CLANG_NOTES TEXT,

    CPU_DBG_STATUS TEXT,
    CPU_DBG_DETECTED_FAILURE TEXT,
    CPU_DBG_NUMBER_OF_RETRIES INT,
    CPU_DBG_READY TEXT,
    CPU_DBG_DURATION_FOR_READY_HRS FLOAT,
    CPU_DBG_DURATION_FOR_SIGNOFF_HRS FLOAT,
    CPU_DBG_TOTAL_DURATION_HRS FLOAT,
    CPU_DBG_NOTES TEXT,

    CPU_FASTBUILD_STATUS TEXT,
    CPU_FASTBUILD_DETECTED_FAILURE TEXT,
    CPU_FASTBUILD_NUMBER_OF_RETRIES INT,
    CPU_FASTBUILD_READY TEXT,
    CPU_FASTBUILD_DURATION_FOR_READY_HRS FLOAT,
    CPU_FASTBUILD_DURATION_FOR_SIGNOFF_HRS FLOAT,
    CPU_FASTBUILD_TOTAL_DURATION_HRS FLOAT,
    CPU_FASTBUILD_NOTES TEXT,

    GPU_FASTBUILD_STATUS TEXT,
    GPU_FASTBUILD_DETECTED_FAILURE TEXT,
    GPU_FASTBUILD_NUMBER_OF_RETRIES INT,
    GPU_FASTBUILD_READY TEXT,
    GPU_FASTBUILD_DURATION_FOR_READY_HRS FLOAT,
    GPU_FASTBUILD_DURATION_FOR_SIGNOFF_HRS FLOAT,
    GPU_FASTBUILD_TOTAL_DURATION_HRS FLOAT,
    GPU_FASTBUILD_NOTES TEXT,

    PCP_CI_STATUS TEXT,
    PCP_CI_DETECTED_FAILURE TEXT,
    PCP_CI_NUMBER_OF_RETRIES INT,
    PCP_CI_READY TEXT,
    PCP_CI_DURATION_FOR_READY_HRS FLOAT,
    PCP_CI_DURATION_FOR_SIGNOFF_HRS FLOAT,
    PCP_CI_TOTAL_DURATION_HRS FLOAT,
    PCP_CI_NOTES TEXT,

    SIMPLE_SIM_STATUS TEXT,
    SIMPLE_SIM_DETECTED_FAILURE TEXT,
    SIMPLE_SIM_NUMBER_OF_RETRIES INT,
    SIMPLE_SIM_READY TEXT,
    SIMPLE_SIM_DURATION_FOR_READY_HRS FLOAT,
    SIMPLE_SIM_DURATION_FOR_SIGNOFF_HRS FLOAT,
    SIMPLE_SIM_TOTAL_DURATION_HRS FLOAT,
    SIMPLE_SIM_NOTES TEXT,

    LOG_TEST_STATUS TEXT,
    LOG_TEST_DETECTED_FAILURE TEXT,
    LOG_TEST_NUMBER_OF_RETRIES INT,
    LOG_TEST_READY TEXT,
    LOG_TEST_DURATION_FOR_READY_HRS FLOAT,
    LOG_TEST_DURATION_FOR_SIGNOFF_HRS FLOAT,
    LOG_TEST_TOTAL_DURATION_HRS FLOAT,
    LOG_TEST_NOTES TEXT,

    ZIM_BOT_2_5_STATUS TEXT,
    ZIM_BOT_2_5_DETECTED_FAILURE TEXT,
    ZIM_BOT_2_5_NUMBER_OF_RETRIES INT,
    ZIM_BOT_2_5_READY TEXT,
    ZIM_BOT_2_5_DURATION_FOR_READY_HRS FLOAT,
    ZIM_BOT_2_5_DURATION_FOR_SIGNOFF_HRS FLOAT,
    ZIM_BOT_2_5_TOTAL_DURATION_HRS FLOAT,
    ZIM_BOT_2_5_NOTES TEXT,

    ZIM_BOT_3_1_STATUS TEXT,
    ZIM_BOT_3_1_DETECTED_FAILURE TEXT,
    ZIM_BOT_3_1_NUMBER_OF_RETRIES INT,
    ZIM_BOT_3_1_READY TEXT,
    ZIM_BOT_3_1_DURATION_FOR_READY_HRS FLOAT,
    ZIM_BOT_3_1_DURATION_FOR_SIGNOFF_HRS FLOAT,
    ZIM_BOT_3_1_TOTAL_DURATION_HRS FLOAT,
    ZIM_BOT_3_1_NOTES TEXT,

    ZIM_BOT_3_2_STATUS TEXT,
    ZIM_BOT_3_2_DETECTED_FAILURE TEXT,
    ZIM_BOT_3_2_NUMBER_OF_RETRIES INT,
    ZIM_BOT_3_2_READY TEXT,
    ZIM_BOT_3_2_DURATION_FOR_READY_HRS FLOAT,
    ZIM_BOT_3_2_DURATION_FOR_SIGNOFF_HRS FLOAT,
    ZIM_BOT_3_2_TOTAL_DURATION_HRS FLOAT,
    ZIM_BOT_3_2_NOTES TEXT,

    OFFLINE_PIPEDREAM_STATUS TEXT,
    OFFLINE_PIPEDREAM_NOTES TEXT,

    DEPLOY_STATUS TEXT,
    MISSION_STATUS TEXT,

    SF_TOTAL_MISSION_TIME_HRS FLOAT,
    SLAC_TOTAL_MISSION_TIME_HRS FLOAT,

    MISSION_DETECTED_FAILURE TEXT,
    DATA_CATALOG_STATUS TEXT,

    SF_TOTAL_INGEST_TIME_HRS FLOAT,
    SLAC_TOTAL_INGEST_TIME_HRS FLOAT,

    DIAGNOSTIC_ANALYSIS TEXT,
    FLAMEGRAPH_STATUS TEXT,

    MERGE_STATUS TEXT,
    MERGE_TOTAL_DURATION FLOAT,

    COMMENTS TEXT,

    TIME_BATCH_STARTED TEXT,
    TIME_BATCH_COMMITTED TEXT,

    TOTAL_TIME_TO_COMMIT_BATCH FLOAT,

    IAT_MISSION_START_TIME TEXT,

    TIME_IAT_BATCH_SIGNED_OFF TEXT,
    TIME_FOR_DRIVING_TO_SIGNOFF FLOAT,

    TOTAL_TIME_FOR_SIGNOFF FLOAT,
    OTHER_NOTES TEXT
);