CREATE TABLE TB_HOST (
    HOST_ID VARCHAR(512) NOT NULL
    , HOST_NAME VARCHAR(1024) NOT NULL
    , HOST_TYPE VARCHAR(64) NOT NULL
    , PRIMARY KEY (HOST_ID)
);

CREATE TABLE TB_RECEIVE_MESSAGE (
    SENDER_HOST_ID VARCHAR(512) NOT NULL
    , SENDER_TIMESTAMP TIMESTAMP NOT NULL
    , MESSAGE_UUID VARCHAR(36) NOT NULL
    , MESSAGE_TYPE VARCHAR(128) NOT NULL
    , RECEIVED_TIMESTAMP TIMESTAMP NOT NULL
    , RECIPIENT_HOST_ID VARCHAR(512) NOT NULL
    , RECIPIENT_DROP_BOX VARCHAR(256) NOT NULL
    , DATA CLOB
    , PROCESS_STATUS VARCHAR(128) NOT NULL
    , PRIMARY KEY (SENDER_HOST_ID, MESSAGE_UUID)
);
