CSO_SURVEY_RESULT_DETAIL

This table contains the answers provided by users for specific questions of a survey.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_SURVEY_RESULT_DETAIL_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
ANSWER_ID	VARCHAR2	32	Yes	This is the GUID for the survey answer.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP		Yes	This is the date that the record was modified.
QUESTION_ID	VARCHAR2	32	Yes	This is the GUID for the survey questions being responded to
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
SURVEY_RESULT_ID	VARCHAR2	32	Yes	This is the GUID for the survey result this answer belongs to
USER_ANSWER_TEXT	VARCHAR2	4000		Text proved by users as part of the answer.
VALUE	NUMBER			This is the value assigned or provided by the user for the specific answer.
USER_ANSWER_TEXT_LONG	CLOB			Large amount of text provided by the user as part of the answer.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_SURVEY_RESULT_DETAIL	cso_survey_answer	ANSWER_ID
CSO_SURVEY_RESULT_DETAIL	cso_survey_question	QUESTION_ID
CSO_SURVEY_RESULT_DETAIL	cso_survey_result	SURVEY_RESULT_ID

Indexes

Index	Uniqueness	Columns
CSO_SURVEY_RESULT_DETAIL_U1	Unique	RECORD_ID
CSO_SURVEY_RESULT_DETAIL_N1	Non Unique	ANSWER_ID
CSO_SURVEY_RESULT_DETAIL_N2	Non Unique	QUESTION_ID
CSO_SURVEY_RESULT_DETAIL_N3	Non Unique	SURVEY_RESULT_ID, ANSWER_ID
CSO_SURVEY_RESULT_DETAIL_N5	Non Unique	DATE_ADDED