[digiKam-users] Face database

[Gilles Caulier]

Hi Maik,

Perhaps it can be a good idea to host the databases structure to the
online documentation. What do you think about ?

Gilles

Le jeu. 16 mars 2023 à 12:49, Maik Qualmann <metzpinguin at gmail.com> a écrit :
>
> 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.
>
>
>
>