<div dir="ltr">
<div><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span>Yes, that's right, the SQLite DB does not use foreign keys.</span></span> <span class="gmail-JLqJ4b gmail-ChMk0b"><span>digiKam's core database schema was created at a time when SQLite did not yet support foreign keys.</span></span> <span class="gmail-JLqJ4b gmail-ChMk0b"><span>In the future, if major changes to the database schema are necessary, we will certainly think about using foreign keys as well.</span></span></span></div><div><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span><br></span></span></span></div><div><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><span>Maik<br></span></span></span></div> 

</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Am Mi., 3. März 2021 um 10:36 Uhr schrieb Nikhil Agarwal <<a href="mailto:nikhilagarwal@outlook.de">nikhilagarwal@outlook.de</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">




<div dir="ltr">
<div>Dear Developers<br>
</div>
<div><br>
</div>
<div>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?<br>
</div>
<div>
<div id="gmail-m_3556060324456682161Signature">
<div>
<div></div>
<div id="gmail-m_3556060324456682161divtagdefaultwrapper" dir="ltr" style="font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255);font-family:Calibri,Arial,Helvetica,sans-serif">
<p class="MsoNormal" style="margin-top:0px;margin-bottom:12pt;font-size:12pt;font-family:Calibri,Arial,Helvetica,sans-serif">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:16px"></span></p>
<div>
<p style="margin:0px 0px 1.2em"></p>
<div style="font-family:"Droid Sans Mono",monospace,monospace,"Droid Sans Fallback";font-size:14px;line-height:19px;white-space:pre-wrap">
<div><br>
<p style="margin:0px 0px 1.2em"><span style="font-family:Arial,Helvetica,sans-serif">Thanks
<span id="gmail-m_3556060324456682161🙂">🙂</span></span></p>
<strong><span style="font-family:Arial,Helvetica,sans-serif">Nikhil Agarwal</span></strong><br>
<p style="margin:0px 0px 1.2em"></p>
</div>
</div>
<p style="margin-top:0px;margin-bottom:0px"></p>
</div>
<p style="margin-top:0px;margin-bottom:0px"></p>
<span style="font-family:Calibri,Arial,Helvetica,sans-serif,"Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols;font-size:16px"></span>
<div></div>
</div>
</div>
</div>
</div>
</div>

</blockquote></div>