Media Table

 

Topic Last Modified: 2010-12-13

Each record represents one media type used in a peer-to-peer session. One session would be represented by multiple records in the table, if more than one media type is used.

You should not use the Media table to calculate the media duration for a call. This table contains the signaling details of media exchange in a call. Media exchange is done by the INVITE request, and StartTime indicates the time that the INVITE was sent out. The invite time does not necessarily mean the media start time, because media starts only after the callee accepts the call. The EndTime usually means the end time of this call.

Column Data Type Key/Index Details

SessionIdTime

datetime

Primary, Foreign

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. Reference to the Dialogs Table.

SessionIdSeq

int

Primary, Foreign

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. Reference to the Dialogs Table.

MediaId

tinyint

Primary, Foreign

Unique number identifying this media type. Reference to the MediaList Table.

StartTime

datetime

Primary

This is the time that a media request was sent out, not the real media start time. StartTime includes the setup time.

EndTime

datetime

 

This is the end time of the call.