CREATE TABLE hwr_profile_indexing_events (
    INDEXING_EVENT_ID        NUMBER        ,
    ACTION                   VARCHAR2(160) ,
    STATUS                   VARCHAR2(160) ,
    ENTITY                   VARCHAR2(320) ,
    START_DATE               DATE          ,
    END_DATE                 DATE          ,
    SNAPSHOT                 CLOB          ,
    DOCS_IN_STREAM_COUNT     NUMBER        ,
    DOCS_IN_INDEX            NUMBER        ,
    INDEX_SIZE               NUMBER        ,
    TOTAL_TIME               NUMBER            NOT NULL,
    ERROR_MESSAGE            CLOB          ,
    SERVER_NAME              VARCHAR2(4000),
    CREATED_BY               VARCHAR2(256)     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) ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    INDEXING_EVENT_ID        NUMBER        ,
    ACTION                   VARCHAR2(160) ,
    STATUS                   VARCHAR2(160) ,
    ENTITY                   VARCHAR2(320) ,
    START_DATE               DATE          ,
    END_DATE                 DATE          ,
    SNAPSHOT                 CLOB          ,
    DOCS_IN_STREAM_COUNT     NUMBER        ,
    DOCS_IN_INDEX            NUMBER        ,
    INDEX_SIZE               NUMBER        ,
    TOTAL_TIME               NUMBER            NOT NULL,
    ERROR_MESSAGE            CLOB          ,
    SERVER_NAME              VARCHAR2(4000),
    CREATED_BY               VARCHAR2(256)     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) ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    CONSTRAINT pk_hwr_profile_indexing_events PRIMARY KEY (INDEXING_EVENT_ID, INDEXING_EVENT_ID)
);
