CREATE TABLE cso_survey_result_detail (
    ANSWER_ID                VARCHAR2(128)     NOT NULL,
    DATE_ADDED               TIMESTAMP(6)      NOT NULL,
    DATE_MODIFIED            TIMESTAMP(6)      NOT NULL,
    QUESTION_ID              VARCHAR2(128)     NOT NULL,
    RECORD_ID                VARCHAR2(128) ,
    SURVEY_RESULT_ID         VARCHAR2(128)     NOT NULL,
    USER_ANSWER_TEXT         VARCHAR2(4000),
    VALUE                    NUMBER        ,
    USER_ANSWER_TEXT_LONG    CLOB          ,
    ANSWER_ID                VARCHAR2(128)     NOT NULL,
    DATE_ADDED               TIMESTAMP(6)      NOT NULL,
    DATE_MODIFIED            TIMESTAMP(6)      NOT NULL,
    QUESTION_ID              VARCHAR2(128)     NOT NULL,
    RECORD_ID                VARCHAR2(128) ,
    SURVEY_RESULT_ID         VARCHAR2(128)     NOT NULL,
    USER_ANSWER_TEXT         VARCHAR2(4000),
    VALUE                    NUMBER        ,
    USER_ANSWER_TEXT_LONG    CLOB          ,
    CONSTRAINT pk_cso_survey_result_detail PRIMARY KEY (RECORD_ID, RECORD_ID)
);
