CREATE TABLE gtg_ess_schld_job_dtls (
    ID                   NUMBER(18, 0) ,
    SCHEDULE_ID          NUMBER(18, 0) ,
    ESS_REQ_ID           NUMBER(18, 0) ,
    JOB_DATA             BLOB          ,
    LAST_RUN_DATE        TIMESTAMP(6)  ,
    NEXT_RUN_DATE        TIMESTAMP(6)  ,
    SCHEDULED_BY         VARCHAR2(1020),
    CREATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128) ,
    CREATION_DATE        TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)      NOT NULL,
    ID                   NUMBER(18, 0) ,
    SCHEDULE_ID          NUMBER(18, 0) ,
    ESS_REQ_ID           NUMBER(18, 0) ,
    JOB_DATA             BLOB          ,
    LAST_RUN_DATE        TIMESTAMP(6)  ,
    NEXT_RUN_DATE        TIMESTAMP(6)  ,
    SCHEDULED_BY         VARCHAR2(1020),
    CREATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128) ,
    CREATION_DATE        TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)      NOT NULL,
    CONSTRAINT pk_gtg_ess_schld_job_dtls PRIMARY KEY (ID, ID)
);
