Question on Database Columns

[b_gossweiler]

Maybe somebody experienced with the LR database can help me on this one:

By looking at the id_local columns in the different tables, I notice that the id_local for a specific image in table Adobe_images is one lower than the id_local for the same image in table AgLibraryFile.

Is this always the case and is there any logic behind it?

Thanks for your help

Beat

 

[clee01l]

I'd only be guessing but I suspect the counter on one table begins with Zero as the initial value (a common default) while the other begins counting from one. In looking at the table names, I've noted that some begin with the 'Ag' nomenclature while others start with 'Adobe' I suspect that the authors have merged databases at some point in time and one database started the ID fields conventionally (from Zero) while the other used an unconventionall ('One') which is an easier concept for non-technical humans to grasp.