database schema available?

[Tac Tacelosky]

Is this the right place to get it? That repo has been archived.

https://github.com/KDE/digikam/blob/master/project/documents/DBSCHEMA.ODS



On Mon, Nov 4, 2024 at 2:15 PM Tac Tacelosky <tacman at gmail.com> wrote:

> yep, that's the one!  Thanks!!
>
> On Mon, Nov 4, 2024 at 2:11 PM Remco Viëtor <remco.vietor at wanadoo.fr>
> wrote:
>
>> On lundi 4 novembre 2024 19:58:15 CET Tac Tacelosky wrote:
>> > Hi, I've been working on something to read the database directly, using
>> the
>> > sql statements to map to an ORM, and was wondering if there was a schema
>> > document available.
>> >
>> > In particular, something that describes the relationship between the
>> > albumRoot key in Albums and AlbumRoots, imageid property to Images.id,
>> > etc.  Obviously, I can figure it out by looking at it, but if there's a
>> > formal definition somewhere (I have a vague recollection of a
>> spreadsheet
>> > with the tables and properties) it would help with my automated data
>> > mapping.
>> >
>> > On a related note, there's no foreign key references in the sql, and
>> sqlite
>> > used to not support it.  But since recent versions do, might that
>> someday
>> > be included in the sql?
>> >
>> > Thanks,
>> >
>> > Tac
>> In the source code: directory "project/documents", there's a file
>> DBSCEMA.ODS. Perhaps that's useful?
>>
>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20241104/ce4ae437/attachment.htm>