CREATE TABLE doo_task_status_history (
    DOO_TASK_STATUS_HISTORY_ID    NUMBER(18, 0),
    DOO_PROCESS_INSTANCE_ID       NUMBER(18, 0)    NOT NULL,
    TASK_INSTANCE_ID              NUMBER(18, 0)    NOT NULL,
    STATUS_CODE                   VARCHAR2(120)    NOT NULL,
    DATE_CHANGED                  DATE         ,
    SCHEDULED_START_DATE          DATE         ,
    SCHEDULED_COMPLETION_DATE     DATE         ,
    REQUIRED_START_DATE           DATE         ,
    REQUIRED_COMPLETION_DATE      DATE         ,
    CREATED_BY                    VARCHAR2(256)    NOT NULL,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)     NOT NULL,
    CREATION_DATE                 TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY               VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE              TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN             VARCHAR2(128),
    DOO_TASK_STATUS_HISTORY_ID    NUMBER(18, 0),
    DOO_PROCESS_INSTANCE_ID       NUMBER(18, 0)    NOT NULL,
    TASK_INSTANCE_ID              NUMBER(18, 0)    NOT NULL,
    STATUS_CODE                   VARCHAR2(120)    NOT NULL,
    DATE_CHANGED                  DATE         ,
    SCHEDULED_START_DATE          DATE         ,
    SCHEDULED_COMPLETION_DATE     DATE         ,
    REQUIRED_START_DATE           DATE         ,
    REQUIRED_COMPLETION_DATE      DATE         ,
    CREATED_BY                    VARCHAR2(256)    NOT NULL,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)     NOT NULL,
    CREATION_DATE                 TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY               VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE              TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN             VARCHAR2(128),
    CONSTRAINT pk_doo_task_status_history PRIMARY KEY (DOO_TASK_STATUS_HISTORY_ID, DOO_TASK_STATUS_HISTORY_ID)
);
