MediaList table
The MediaList table is a static table that stores the list of various media types.
Column | Data Type | Key/Index | Details |
---|---|---|---|
MediaId |
tinyint |
Primary |
Values: 1-7 |
Media |
nvarchar(256) |
Static mapping of MediaID and Media values: 1 -- IM 2 - File Transfer 3 - Remote Assistance 4 - Application Sharing 5 -- Audio 6 -- Video 7 - App Invite |
If you are trying to determine the modality type for the values in LcsCDR.SessionDetailsView.MediaTypes, then you need to use the following Join snippet:
LEFT JOIN on Media.MediaId = MediaList.MediaId