[This is pre-release documentation and subject to change in future releases. This topic's current status is: Milestone-Ready]

Topic Last Modified: 2010-03-09

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))