CREATE TABLE bm_ssh_known_host (
    ID                   NUMBER(18, 0) ,
    DATE_ADDED           DATE              NOT NULL,
    DATE_MODIFIED        DATE              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) ,
    HOSTNAME             VARCHAR2(1020)    NOT NULL,
    KEY_TYPE             VARCHAR2(512)     NOT NULL,
    PUBLIC_KEY           BLOB              NOT NULL,
    FINGERPRINT          VARCHAR2(1020)    NOT NULL,
    EXPIRATION           TIMESTAMP(6)      NOT NULL,
    IS_DELETED           NUMBER(1, 0)      NOT NULL,
    ID                   NUMBER(18, 0) ,
    DATE_ADDED           DATE              NOT NULL,
    DATE_MODIFIED        DATE              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) ,
    HOSTNAME             VARCHAR2(1020)    NOT NULL,
    KEY_TYPE             VARCHAR2(512)     NOT NULL,
    PUBLIC_KEY           BLOB              NOT NULL,
    FINGERPRINT          VARCHAR2(1020)    NOT NULL,
    EXPIRATION           TIMESTAMP(6)      NOT NULL,
    IS_DELETED           NUMBER(1, 0)      NOT NULL,
    CONSTRAINT pk_bm_ssh_known_host PRIMARY KEY (ID, ID)
);
