database schema available?

[Tac Tacelosky]

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/8e78de90/attachment.htm>