CREATE TABLE bm_hrs_cache (
    ID               NUMBER(18, 0),
    REF_ID           NUMBER(18, 0)    NOT NULL,
    REF_TYPE         NUMBER(5, 0)     NOT NULL,
    HRS_XML          CLOB         ,
    DATE_ADDED       DATE         ,
    DATE_MODIFIED    DATE         ,
    ID               NUMBER(18, 0),
    REF_ID           NUMBER(18, 0)    NOT NULL,
    REF_TYPE         NUMBER(5, 0)     NOT NULL,
    HRS_XML          CLOB         ,
    DATE_ADDED       DATE         ,
    DATE_MODIFIED    DATE         ,
    CONSTRAINT pk_bm_hrs_cache PRIMARY KEY (ID, ID)
);
