Expand All Collapse All

IR_QGroup Table

  • 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
QGroupId uniqueidentifier False No

4.0.106.453 4.0 Release
QuestionnaireId uniqueidentifier True No

4.0.106.453 4.0 Release
GroupName nvarchar (255) False Depends on customer usage

4.0.106.453 4.0 Release
Sequence int False No

4.0.106.453 4.0 Release
Note nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
IsOptional tinyint False No

4.0.106.453 4.0 Release
IsTemplate tinyint False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_QGroup Clustered QGroupId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_QGroup_QuestionnaireId QuestionnaireId IR_Questionnaire QuestionnaireId Yes

Index Name Type Column Name (sort order)
IX_IR_QGroup_QuestionnaireId Non-clustered QuestionnaireId (Ascending)