Re: Chat history progress - GSoC 2017

Paulo Lieuthier <[email protected]> Tue, 20 Jun 2017 08:38:01 -0300

Newsgroups	gmane.comp.kde.devel.kopete
Message-ID	<[email protected]>

On 20-06-2017 05:20, Pali Rohár wrote:
> On Tuesday 20 June 2017 01:24:10 Paulo Lieuthier wrote:
>> The new iteration:
>>
>> Conversations:
>> * id
>> * subconversation_id
>> * account
>> * type (1:1, group, channel)
>> * entity_identifier (id of contact, group or channel)
>> * entity_display_name
>>
>> Messages:
>> * id
>> * conversation_id
>> * subconversation_id
>> * timestamp
>> * sender_id (contact id, if available)
>> * sender_display_name (sender name, if name not available through id)
>> * type (text, event, file, voice clip)
>> * content (html)
>> * importance
>> * state
> 
> This looks like a synthetic split. Via "Conversations" there are stored
> two relations (id + subconversation_id), so it in final it N:M relation
> via two tables?

I'm thinking of using two tables, or maybe setting both id and
subconversation_id as the primary key.

signature.asc (application/pgp-signature, 833 B)