CREATE TABLE hwr_ehw_sources_b (
    SOURCE_ID             NUMBER(18, 0) ,
    DESCRIPTION           VARCHAR2(4000),
    TYPE_ID               NUMBER(18, 0)     NOT NULL,
    STATUS_ID             NUMBER(18, 0)     NOT NULL,
    LOCAL_SOURCE_ID       NUMBER(18, 0) ,
    DEVICE                VARCHAR2(1024),
    VENDOR                VARCHAR2(1024),
    AUTHORIZATION_URL     VARCHAR2(2048),
    ADMINISTRATION_URL    VARCHAR2(2048),
    DATA_SRC_CONFIG       VARCHAR2(1024),
    CREATION_DATE         TIMESTAMP(6)      NOT NULL,
    SEED_DATA_SOURCE      VARCHAR2(2048),
    CREATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE      TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN     VARCHAR2(128) ,
    ORA_SEED_SET1         VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2         VARCHAR2(4)       NOT NULL,
    SOURCE_ID             NUMBER(18, 0) ,
    TYPE_ID               NUMBER(18, 0)     NOT NULL,
    STATUS_ID             NUMBER(18, 0)     NOT NULL,
    LOCAL_SOURCE_ID       NUMBER(18, 0) ,
    DEVICE                VARCHAR2(1024),
    VENDOR                VARCHAR2(1024),
    AUTHORIZATION_URL     VARCHAR2(2048),
    ADMINISTRATION_URL    VARCHAR2(2048),
    CREATION_DATE         TIMESTAMP(6)      NOT NULL,
    CREATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE      TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN     VARCHAR2(128) ,
    SEED_DATA_SOURCE      VARCHAR2(2048),
    DESCRIPTION           VARCHAR2(4000),
    DATA_SRC_CONFIG       VARCHAR2(1024),
    ORA_SEED_SET1         VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2         VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_hwr_ehw_sources_b PRIMARY KEY (SOURCE_ID, SOURCE_ID)
);
