Expand All Collapse All

IR_QQuestion Table

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

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
QQuestionId uniqueidentifier False No

4.0.106.453 4.0 Release
QGroupId uniqueidentifier False No

4.0.106.453 4.0 Release
QuestionText nvarchar (1024) False Depends on customer usage

4.0.106.453 4.0 Release
QuestionType smallint False No

4.0.106.453 4.0 Release
QuestionPromptType smallint False No

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

4.0.106.453 4.0 Release
Weight numeric False No

4.0.106.453 4.0 Release
Sequence int False No

4.0.106.453 4.0 Release
MaxScore numeric False No

4.0.106.453 4.0 Release
MinScore numeric False No

4.0.106.453 4.0 Release
MinAcceptableScore numeric False No

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

4.0.106.453 4.0 Release
IsTemplate tinyint False No

4.0.106.453 4.0 Release
HasCommentField tinyint False No

4.0.106.453 4.0 Release
CanMarkNA tinyint False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release
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
QQuestionId raw (16) False No

4.0.106.453 4.0 Release
QGroupId raw (16) True No

4.0.106.453 4.0 Release
QuestionText nvarchar2 (1024) False Depends on customer usage

4.0.106.453 4.0 Release
QuestionType smallint False No

4.0.106.453 4.0 Release
QuestionPromptType smallint False No

4.0.106.453 4.0 Release
HelpText nvarchar2 (1024) True Depends on customer usage

4.0.106.453 4.0 Release
Weight number False No

4.0.106.453 4.0 Release
Sequence integer False No

4.0.106.453 4.0 Release
MaxScore number False No

4.0.106.453 4.0 Release
MinScore number False No

4.0.106.453 4.0 Release
MinAcceptableScore number False No

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

4.0.106.453 4.0 Release
IsTemplate smallint False No

4.0.106.453 4.0 Release
HasCommentField smallint False No

4.0.106.453 4.0 Release
CanMarkNA smallint False No

4.0.106.453 4.0 Release
Version integer False No

4.0.106.453 4.0 Release

Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_QQuestion Clustered QQuestionId (Ascending)

Primary Key Name Column Name (sort order)
PK_IR_QQuestion QQuestionId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_QQuestion_QGroupId QGroupId IR_QGroup QGroupId Yes

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_QQuestion_QGroupId QGroupId IR_QGroup QGroupId Yes

Index Name Type Column Name (sort order)
IX_IR_QQuestion_QGroupId Non-clustered QGroupId (Ascending)

Index Name Column Name (sort order)
IX_IR_QQuestion_QGroupId QGroupId (Ascending)