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. |