Topic Last Modified: 2010-11-07

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

FromNumberId

int

Foreign

PhoneId of the caller. Reference to the Phones Table. If not NULL and FromGatewayId is not NULL, then the caller was a PSTN user.

ConnectedNumberId

int

Foreign

PhoneId of the call receiver. Reference to the Phones Table. If not NULL and ToGatewayId is not NULL, then the call receiver was a PSTN user.

FromGatewayId

int

Foreign

The Gateway the call is coming from. Reference to the Gateways Table.

ToGatewayId

Int

Foreign

The Gateway the call is going to. Reference to the Gateways Table.

FromMediationServerId

int

Foreign

The Mediation Server the call is coming from. Reference to the MediationServers Table.

ToMediationServerId

int

Foreign

The Mediation Server called is going to. Reference to the MediationServers Table.

DisconnectedbyURIId

int

Foreign

URI of the user who disconnected the call, if the user has a URI. Reference to the Users Table.

DisconnectedbyPhoneId

int

Foreign

ID of the phone that disconnected the call was disconnected from a phone. Reference to the Phones Table.