database schema available?

[Tac Tacelosky]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20241104/d8866bad/attachment.htm>