Expand All Collapse All

IR_TagMap 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
RecordingId uniqueidentifier False No

4.0.106.453 4.0 Release
TagId int False No

4.0.106.453 4.0 Release
KeywordSetName nvarchar (128) True Depends on customer usage

4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_TagMap Clustered RecordingId (Ascending)
TagId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_TagMap_RecordingId RecordingId IR_RecordingMedia RecordingId Yes
FK_IR_TagMap_TagId TagId IR_Tag TagId Yes

Index Name Type Column Name (sort order)
IX_IR_TagMap_TagId Non-clustered TagId (Ascending)