Face Recognition, missing link between sqlite database "metadata_string_table and "tag_table"
In order to understand the face recognition database I understood, the face recognition data of a catalog is stored in C:\ProgramData\Adobe\Elements Organizer\Catalogs\...\FaceAnalysis\json in json-files. Each file matches one foto found in the catalog and consists of a json structure containing
"faces" : [
{
"id" : "0",
"asset_id" : "709077", # <- this is the file-id in media_table
"person_id" : "57c869cf-eb65-4dba-9150-6bc3914d0240", # <<<<-- link to tag_table ??????
"confirmed" : false, ... and so on ...The person_id seems to link the file (asset_id = media_id) to the face names.
I also opened the catalog file in sqlite3 and found a couple of tables, of which the table "metadata_string_table" stores the json person_id: in this case e. g. "57c869cf-eb65-4dba-9150-6bc3914d0240".
Questions:
What is the missing link between "metadata_string_table" and the face-tags in "tag_table"? There seems to be no FOREIGN KEY Chain between the 2 tables. The metadata-tables seem to form an island not connected to the rest of the tables.
What is the meaning o a hex-string like "57c869cf-eb65-4dba-9150-6bc3914d0240"? It seems to be no UTFxy-encoding or numbers.
Could anybody answer my question or handover this question to the appropriate developper?
Regards, thank-you,
AA4
AdChoices