Expand All Collapse All

IR_EventKeywordInfo 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
EventId int False No

4.0.106.453 4.0 Release
KeywordSetId int False No

4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_EventKeywordInfo Clustered EventId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_EventKeywordInfo_EventId EventId IR_Event EventId Yes
FK_IR_EventKeywordInfo_KwsId KeywordSetId IR_KeywordSet KeywordSetId Yes

Index Name Type Column Name (sort order)
IX_IR_EventKeywordInfo_KwsId Non-clustered KeywordSetId (Ascending)