[digiKam-users] Face database

[Maik Qualmann]

Look in the thumbnail database in the "CustomIdentifiers" table. You can't just 
join it via SQL.

In the digiKam core database in the "ImageTagProperties" table you can find the 
faces, unconfirmed, confirmed etc.
You can use the imageid to assemble the album path with the root path. The 
rectangle coordinates of the face are in the "value" table. Then you can build 
a "CustomIdentifiers" string to get the corresponding thumbid.

Maik

Am Donnerstag, 16. März 2023, 12:17:01 CET schrieb tomtom:
> Hello,
> I need to make join betewen  the attribute Id of the thumbnail and
> the image id corresponding.
> Witch table and witch attribut is it?
> I don't find it in the DBSCHEMA file.
> Thank's for all your answer
> 
> Gilles Caulier <caulier.gilles at gmail.com> a écrit :
> > Hi,
> > 
> > The database schema is described in libre office spreadsheet located here
> > :
> > 
> > https://invent.kde.org/graphics/digikam/-/blob/master/project/documents/DB
> > SCHEMA.ODS
> > 
> > Best
> > 
> > Gilles Caulier
> > 
> > Le jeu. 2 mars 2023 à 14:22, tomtom <tomtom at samizdat.net> a écrit :
> >> Hello
> >> I'm thomas
> >> I don't know if it's the rignt place to ask this very database oriented.
> >> If it's not, could someone tell me where I can ask.
> >> I want to extract face thumbnails.
> >> I need to make the difference between thumbnail image and  thumbnail
> >> face.
> >> I searche in the database of digikam witch table and witch  array I
> >> can use to find it.
> >> Witch primary or foreign key I can use to extract blob in the
> >> thumbnail data base.
> >> Thank's you for your time.