Topic Last Modified: 2010-11-05

The Dialogs table is a supporting table that stores the information about DialogIDs for peer-to-peer sessions.

Column Data Type Key/Index Details

SessionIdTime

Datetime

Primary

Time of session request; used in conjunction with SessionIDSeq to uniquely identify a session.

SessionIdSeq

Int

Primary

ID number to identify the session. Used in conjunction with SessionIDTime to uniquely identify a session.

ExternalChecksum

Int

 

Checksum of the ExternalID. This field is used to increase the speed of database searches.

ExternalId

varbinary(775)

 

SIP dialog ID, stored as a binary. The format of the binary is:

dialog;from-tag;to-tag

This data can be converted to text format by using: cast(cast(ExternalId as varbinary(max)) as varchar(max))