Expand All Collapse All
Survey Question Enumeration

SurveyQuestionEnum Table

Survey Question Enumeration

The SurveyQuestionEnum table contains enumerations for true/false and multiple choice questions. It also contains min/max values for numeric questions.

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
SurveyQuestionEnumId varchar (32) False No

ID of the survey question enumeration.

 4.0.106.453 4.0 Release Survey Question Enum Id Attribute CSSurvey
SurveyQuestionID varchar (32) False No

ID of the question the enumeration value belongs to.

 4.0.106.453 4.0 Release Survey Question Id Attribute CSSurvey
EnumSequence int False No

Sequence number of the value within the enumeration. Numbering starts at zero.

 4.0.106.453 4.0 Release EnumSequence Fact CSSurvey
EnumName nvarchar (255) False No

Name of the enumeration value.

 4.0.106.453 4.0 Release Enum Name Attribute CSSurvey
EnumText nvarchar (255) True Depends on customer usage

Description of the enumeration value.

 4.0.106.453 4.0 Release Enum Text Attribute CSSurvey
EnumScore numeric True No

Score given if this enumeration value is selected.

 4.0.106.453 4.0 Release Enum Score Fact CSSurvey

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_SurveyQuestionEnum Clustered SurveyQuestionEnumId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_SurveyQuestionEnum_SurveyQuestionID SurveyQuestionID SurveyQuestion SurveyQuestionID Yes

Index Name Type Column Name (sort order)
IX_SurveyQuestionEnum_EnumSequence Non-clustered EnumSequence (Ascending)
IX_SurveyQuestionEnum_SurveyQuestionID Non-clustered SurveyQuestionID (Ascending)