I'm looking for some documentation for the Lightroom Catalog (sqlite database) structures.
Here's a simple example of what I'm trying to do. I found a table containing the exif data (AgHarvestedExifMetadata) and now I'm trying to join it with the original image (AgLibraryFile) but can't find a common field to join on. In this example, it seems id_global might do it but I've had no luck so far.
Where can I find documentation or examples using the backend Lightroom catalog / database? I found documentation for sqlite but I'm looking for the Lightroom database structure (tables, foreign keys, referential integrity, etc).