CREATE TABLE cso_normalized_questions (
    NORMALIZED_QUESTION_ID     NUMBER(18, 0) ,
    CREATION_DATE              TIMESTAMP(6)      NOT NULL,
    CREATED_BY                 VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)      NOT NULL,
    NORMALIZED_QUESTION        VARCHAR2(1024)    NOT NULL,
    LOCALE_ID                  VARCHAR2(128)     NOT NULL,
    RECOGNIZED_TOKENS          VARCHAR2(1024),
    UNRECOGNIZED_TOKENS        VARCHAR2(1024),
    RECOGNIZED_TOKENS_CSV      VARCHAR2(1024),
    UNRECOGNIZED_TOKENS_CSV    VARCHAR2(1024),
    DEPARTMENT_ID              VARCHAR2(128) ,
    NORMALIZED_QUESTION_ID     NUMBER(18, 0) ,
    CREATION_DATE              TIMESTAMP(6)      NOT NULL,
    CREATED_BY                 VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)      NOT NULL,
    NORMALIZED_QUESTION        VARCHAR2(1024)    NOT NULL,
    LOCALE_ID                  VARCHAR2(128)     NOT NULL,
    RECOGNIZED_TOKENS          VARCHAR2(1024),
    UNRECOGNIZED_TOKENS        VARCHAR2(1024),
    RECOGNIZED_TOKENS_CSV      VARCHAR2(1024),
    UNRECOGNIZED_TOKENS_CSV    VARCHAR2(1024),
    DEPARTMENT_ID              VARCHAR2(128) ,
    CONSTRAINT pk_cso_normalized_questions PRIMARY KEY (NORMALIZED_QUESTION_ID, NORMALIZED_QUESTION_ID)
);
