StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POskype main.db - difference between Chats and Conversations
text
Body
copied!<p>I've been dissecting Skype database main.db for a couple of days, and this is something which I haven't yet figured out. Naturally, this question will be very specifically for Skype main.db structure.(disclaimer)</p> <p>It seems that all the necessary information that I need are in tables <code>Conversations</code>, <code>Messages</code>, <code>Participants</code>.</p> <p><code>Message</code> table contains actual log that has been said, the recipient(s), timestamp, and the <code>convo_id</code> foreign key(although not enforced) to connect to a <code>Conversation</code> which the message belongs to.</p> <p><code>Conversation</code> exists to hold the aggregates of <code>Message</code> and the Contacts that participate in.</p> <p><code>Participants</code> table works to a many-to-many connector table between the <code>Conversations</code> table and <code>Contacts</code> table.</p> <p>What gets me are <code>Chats</code> and <code>Chatmembers</code> table. <code>Chatmembers</code> works to <code>Chats</code> what <code>Participants</code> table works to <code>Conversations</code> table; connecting Contacts and the conversations-or 'chats'.</p> <p>What's in <code>Chats</code> is similar to <code>Conversations</code> except that it does not have any aggregate to <code>Message</code> table. It is impossible to map from <code>Messages</code> table to <code>Chats</code> table to which the message log(row of <code>Messages</code> table) belongs.</p> <p><code>Chats</code> and <code>Conversations</code> share a foreign key, <code>Conversations</code> table has a column named <code>chat_dbid</code> which joins to the <code>Chats</code> table. But there are rows in <code>Conversations</code> table which have a null <code>chat_dbid</code> field, and not all rows in <code>Chats</code> have <code>id</code> field which corresponds to <code>chat_dbid</code> field in <code>Chats</code> table.</p> <p>The <code>Chats</code> table is still being updated and I recognize some of the chats-or conversations- I've had recently based on the timestamp and the members in it.</p> <p>Does anyone know exactly what <code>Chats</code> table does? Or rather, what's the difference and justification for <code>Chats</code> table and <code>Conversations</code> table?</p> <p>When I looked frantically for this I could find only <a href="http://betrayedspousesclub.blogspot.ca/2012/07/skype-maindb.html" rel="noreferrer">one like that talked about main.db structure</a>, and it wasn't very helpful.</p> <p>According to the link <code>Chats</code></p> <blockquote> <p>Provides the chats in which the user participated.</p> </blockquote> <p>and <code>Conversations</code></p> <blockquote> <p>Provides a list of the conversations in which the user participated. </p> </blockquote> <p>What's their terminology about Chats and Conversations? How are they different?</p> <p>It's been driving me crazy.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload