Dialogs table in Skype for Business Server 2015
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 this syntax: cast(cast(ExternalId as varbinary(max)) as varchar(max)) |