VoipDetails Table

 

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.