CREATE TABLE hwr_cat_topic_b (
    TOPIC_ID             NUMBER(18, 0) ,
    CATEGORY_ID          NUMBER(18, 0)     NOT NULL,
    CATEGORY_KEY         VARCHAR2(800)     NOT NULL,
    TOPIC_KEY            VARCHAR2(800)     NOT NULL,
    AVERAGE_SCORE        NUMBER        ,
    URL_LINK             VARCHAR2(4000),
    IS_SEEDED_DATA       VARCHAR2(16)      NOT NULL,
    ACCURACY_VALUE       NUMBER        ,
    IMPORTANCE_VALUE     NUMBER        ,
    PRECISION_VALUE      NUMBER        ,
    RELEVANCE_VALUE      NUMBER        ,
    IS_ACTIVE            VARCHAR2(16)      NOT NULL,
    SEED_DATA_SOURCE     VARCHAR2(2048),
    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) ,
    ORA_SEED_SET1        VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2        VARCHAR2(4)       NOT NULL,
    TOPIC_ID             NUMBER(18, 0) ,
    CATEGORY_ID          NUMBER(18, 0)     NOT NULL,
    CATEGORY_KEY         VARCHAR2(800)     NOT NULL,
    TOPIC_KEY            VARCHAR2(800)     NOT NULL,
    AVERAGE_SCORE        NUMBER        ,
    URL_LINK             VARCHAR2(4000),
    IS_SEEDED_DATA       VARCHAR2(16)      NOT NULL,
    ACCURACY_VALUE       NUMBER        ,
    IMPORTANCE_VALUE     NUMBER        ,
    PRECISION_VALUE      NUMBER        ,
    RELEVANCE_VALUE      NUMBER        ,
    IS_ACTIVE            VARCHAR2(16)      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) ,
    SEED_DATA_SOURCE     VARCHAR2(2048),
    ORA_SEED_SET1        VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2        VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_hwr_cat_topic_b PRIMARY KEY (TOPIC_ID, TOPIC_ID)
);
