database schema available?

[Remco Viëtor]

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?