Foreign key in Sqlite database (digikam4.db)

[Maik Qualmann]

 Yes, that's right, the SQLite DB does not use foreign keys. digiKam's core
database schema was created at a time when SQLite did not yet support
foreign keys. In the future, if major changes to the database schema are
necessary, we will certainly think about using foreign keys as well.

Maik

Am Mi., 3. März 2021 um 10:36 Uhr schrieb Nikhil Agarwal <
nikhilagarwal at outlook.de>:

> Dear Developers
>
> I was inspecting `digikam4.db`, but I could not find foreign key in and of
> the tables in the Sqlite database (digikam4.db). I was wondering if that's
> how it was intended?
>
>
> Thanks 🙂
> *Nikhil Agarwal*
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20210303/4dc9bc01/attachment.htm>