| 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 |
| 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 | raw (16) | False | No | 4.0.106.453 | 4.0 Release | ||||
| TagId | integer | False | No | 4.0.106.453 | 4.0 Release | ||||
| KeywordSetName | nvarchar2 (128) | True | Depends on customer usage | 4.0.106.453 | 4.0 Release |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_IR_TagMap | Clustered | RecordingId (Ascending) TagId (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_IR_TagMap | 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 |
| 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) |
| Index Name | Column Name (sort order) |
|---|---|
| IX_IR_TagMap_TagId | TagId (Ascending) |