CREATE TABLE hey_web_service_request_atmpt (
    ATTEMPT_ID                NUMBER(18, 0),
    WEB_SERVICE_REQUEST_ID    NUMBER(18, 0)    NOT NULL,
    STATUS_CODE               VARCHAR2(120)    NOT NULL,
    ATTEMPT_SEQUENCE          NUMBER(9, 0)     NOT NULL,
    ATTEMPT_START_DATETIME    TIMESTAMP(6)     NOT NULL,
    ATTEMPT_END_DATETIME      TIMESTAMP(6) ,
    RESPONSE_STATUS_CODE      NUMBER(9, 0) ,
    RESPONSE_HEADERS          CLOB         ,
    RESPONSE_BODY             CLOB         ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    ATTEMPT_ID                NUMBER(18, 0),
    WEB_SERVICE_REQUEST_ID    NUMBER(18, 0)    NOT NULL,
    STATUS_CODE               VARCHAR2(120)    NOT NULL,
    ATTEMPT_SEQUENCE          NUMBER(9, 0)     NOT NULL,
    ATTEMPT_START_DATETIME    TIMESTAMP(6)     NOT NULL,
    ATTEMPT_END_DATETIME      TIMESTAMP(6) ,
    RESPONSE_STATUS_CODE      NUMBER(9, 0) ,
    RESPONSE_HEADERS          CLOB         ,
    RESPONSE_BODY             CLOB         ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    CONSTRAINT pk_hey_web_service_request_atmpt PRIMARY KEY (ATTEMPT_ID, ATTEMPT_ID)
);
