Expand All Collapse All

IR_KeywordSet Table

  • Table Type - Lookup
  • Last Changed Version - 15.4.0.418
  • Last Changed Reason - Added to store keyword set and category assiociated with each keyword spot.

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
KeywordSetId int False No

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.
DisplayName nvarchar (128) False Depends on customer usage

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.
Category nvarchar (128) True Depends on customer usage

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.
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
KeywordSetId integer False No

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.
DisplayName nvarchar2 (128) False Depends on customer usage

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.
Category nvarchar2 (128) True Depends on customer usage

15.4.0.418 Added to store keyword set and category assiociated with each keyword spot.

Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_KeywordSet Clustered KeywordSetId (Ascending)

Primary Key Name Column Name (sort order)
PK_IR_KeywordSet KeywordSetId (Ascending)


Index Name Type Column Name (sort order)
IX_IR_KeywordSet_Category Non-clustered Category (Ascending)
IX_IR_KeywordSet_DisplayName Non-clustered DisplayName (Ascending)

Index Name Column Name (sort order)
IX_IR_KeywordSet_Category Category (Ascending)
IX_IR_KeywordSet_DisplayName DisplayName (Ascending)