Expand All Collapse All
Survey Question To Question Category

SurveyQstnToQuestionCategory Table

Survey Question To Question Category

The SurveyQstnToQuestionCategory maps questions to question categories. This is a many-to-many relationship.

  • 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
SurveyQuestionCategoryId varchar (32) False No

ID of the survey question category.

 4.0.106.453 4.0 Release Survey Question Category Id Attribute CSSurvey
SurveyQuestionId varchar (32) False No

ID of the survey question.

 4.0.106.453 4.0 Release Survey Question Id Attribute CSSurvey

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_SurveyQstnToQstnCategory Clustered SurveyQuestionId (Ascending)
SurveyQuestionCategoryId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_SurveyQstnToQuestionCategory_SurveyQuestionCategoryId SurveyQuestionCategoryId SurveyQuestionCategory SurveyQuestionCategoryId Yes
FK_SurveyQstnToQuestionCategory_SurveyQuestionId SurveyQuestionId SurveyQuestion SurveyQuestionID Yes

Index Name Type Column Name (sort order)
IX_SurveyQstnToQuestionCategory_SurveyQuestionCategoryId Non-clustered SurveyQuestionCategoryId (Ascending)