It is impossible to map from Messages table to Chats table to which the message log(row of Messages table) belongs.Ĭhats and Conversations share a foreign key, Conversations table has a column named chat_dbid which joins to the Chats table. What's in Chats is similar to Conversations except that it does not have any aggregate to Message table. Chatmembers works to Chats what Participants table works to Conversations table connecting Contacts and the conversations-or 'chats'. What gets me are Chats and Chatmembers table. Participants table works to a many-to-many connector table between the Conversations table and Contacts table. Message table contains actual log that has been said, the recipient(s), timestamp, and the convo_id foreign key(although not enforced) to connect to a Conversation which the message belongs to.Ĭonversation exists to hold the aggregates of Message and the Contacts that participate in. It seems that all the necessary information that I need are in tables Conversations, Messages, Participants. Naturally, this question will be very specifically for Skype main.db structure.(disclaimer)

I've been dissecting Skype database main.db for a couple of days, and this is something which I haven't yet figured out.

Open skype main db