CREATE TABLE cmr_po_events_archive (
    PO_HEADER_ID         NUMBER(18, 0),
    EVENT_DATE           TIMESTAMP(6) ,
    EVENT_TYPE           VARCHAR2(120)    NOT NULL,
    PROCESS_FLAG         VARCHAR2(4)      NOT NULL,
    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),
    PO_HEADER_ID         NUMBER(18, 0),
    EVENT_DATE           TIMESTAMP(6) ,
    EVENT_TYPE           VARCHAR2(120)    NOT NULL,
    PROCESS_FLAG         VARCHAR2(4)      NOT NULL,
    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),
    CONSTRAINT pk_cmr_po_events_archive PRIMARY KEY (PO_HEADER_ID, EVENT_DATE, PO_HEADER_ID, EVENT_DATE)
);
