Topic Last Modified: 2012-09-28

Each record represents one two-party call in which at least one user is a VoIP user.

Column Data Type Key/Index Details

SessionIdTime

datetime

Primary

Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs Table for more information.

SessionIdSeq

int

Primary

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs Table for more information.

FromNumberId

int

Foreign

PhoneId of the caller. See the Phones Table for more information. If not NULL and FromGatewayId is not NULL, then the caller was a PSTN user.

ConnectedNumberId

int

Foreign

PhoneId of the call receiver. See the Phones Table for more information. If not NULL and ToGatewayId is not NULL, then the call receiver was a PSTN user.

FromMediationServerId

int

Foreign

The Mediation Server the call is coming from. See the MediationServers Table for more information.

ToMediationServerId

int

Foreign

The Mediation Server called is going to. See the MediationServers Table for more information.

FromGatewayId

int

Foreign

Gateway the call is coming from. See the Gateways Table for more information.

ToGatewayId

int

Foreign

Gateway the call is going to. See the Gateways Table for more information.

DisconnectedbyURIId

int

Foreign

URI of the user who disconnected the call, if the user has a URI. See the Users Table for more information.

DisconnectedbyPhoneId

int

Foreign

ID of the phone that disconnected the call was disconnected from a phone. See the Phones Table for more information.