Expand All Collapse All
Social Media Recordings Table

IR_SocialMediaRecording Table

Social Media Recordings Table

Table used to store additional metadata for social media recordings.

  • Table Type - Historical
  • Last Changed Version - 18.4.0.0
  • Last Changed Reason - Added for social media recordings.

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

Recording ID referencing IR_RecordingMedia

 18.4.0.0 Added for social media recordings.
Platform smallint False No

Enumeration of the social media platform

 18.4.0.0 Added for social media recordings
ChannelId nvarchar (128) False No

Channel ID of the Social Media Recording.

 18.4.0.0 Added for social media recordings
ChannelName nvarchar (1024) False No

Channel display name of the social media recording.

 18.4.0.0 Added for social media recordings
Page nvarchar (128) True No

Name of the social media page for this recording.

 18.4.0.0 Added for social media recordings

SQL Constraints

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

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_SocialMediaRec_RecId RecordingId IR_RecordingMedia RecordingId Yes

Index Name Type Column Name (sort order)
IX_IR_SocialMediaRec_ChannelId Non-clustered ChannelId (Ascending)
IX_IR_SocialMediaRec_Channel Non-clustered ChannelName (Ascending)
IX_IR_SocialMediaRec_Page Non-clustered Page (Ascending)