Face Recognition, missing link between sqlite database "metadata_string_table and "tag_table"

[and.alef]

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:

1. 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.

2. 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

[Sahil.Chawla]

Hi there,

Welcome to the Community!

I believe the best forum to ask this question is https://feedback.photoshop.com/photoshop_family/categories/photoshop_family_photoshop_elements This forum nis directly moniotred by our developers and engineers, they might give you some facts and relevant answers regarding the missing link between "metadata_string_table" and the meaning of the hex-string you've shared.

Regards,
Sahil

[and.alef]

Thank-you!!