[horde] Fwd: [turba]: entity relation ship model of turba database

[Carsten]

Hi,

I have put this to the turba list, but w/o any response.

Maybe somebody on the core list has an idea?!

br

Carsten



-------- Weitergeleitete Nachricht --------
To: 	turba at lists.horde.org
From: 	Carsten <horde-groupware at familie-lahme.de>
Subject: 	[horde][turba]: entity relation ship model of turba database
Message-ID: 	<7b7994a6-6e6d-8f0a-6e62-048724a6b44f at familie-lahme.de>
Date: 	Sat, 24 Feb 2018 14:43:27 +0100
User-Agent: 	Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 
Thunderbird/52.6.0
MIME-Version: 	1.0
Content-Type: 	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 	7bit
Content-Language: 	en-US



Hi all,

I try to create queries for my Cisco phonebook to get phonebooks from
turba.
At the moment I struggle with the relation ship model on the turba tables.

The main issue is, how to decide, whether an object is bound to a
shareng or not.
If I use just .share_owner, I always get the same output, regardless
which share (phonebook) I select.

If the user has more than one phonebook, there is a crypted value in
turba_objects.owner_id, that points to turba_sharesng.share_id.
But unless there is only one phonebook (shareng), the
turba_shareng.share_owner is mapped.

This seems somehow odd to me, if I view from ER-Model perspektive.

Is there any graphical overview (Visio o.s.) in the wild, showing the
ER-Model?

br

Carsten