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 NULL, the caller was a PSTN user.

ConnectedNumberId

int

Foreign

PhoneId of the call receiver, reference to the Phones Table. If NULL, the receiver was a PSTN user.

FromGatewayId

int

Foreign

The gateway the call is coming from, reference to the Gateways Table.

ToGatewayId

Int

Foreign

Gateway called 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 if the call was disconnected from a phone. Reference to the Phones Table.