Expand All Collapse All

IR_QQuestionEnum 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
Sequence int False No

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

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

4.0.106.453 4.0 Release
Score numeric 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
Sequence integer False No

4.0.106.453 4.0 Release
EnumText nvarchar2 (255) False Depends on customer usage

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

4.0.106.453 4.0 Release
Score numeric 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_QQuestionEnum Clustered QQuestionId (Ascending)
Sequence (Ascending)

Primary Key Name Column Name (sort order)
PK_IR_QQuestionEnum QQuestionId (Ascending)
Sequence (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_QQuestionEnu_QQuestionId QQuestionId IR_QQuestion QQuestionId Yes

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_QQuestionEnu_QQuestionId QQuestionId IR_QQuestion QQuestionId Yes