[Digikam-devel] [digikam] [Bug 355831] MySQL Schema Improvements

via KDE Bugzilla bugzilla_noreply at kde.org
Tue Apr 5 21:20:19 BST 2016


swatilodha27 at gmail.com changed:

           What    |Removed                     |Added
                 CC|                            |swatilodha27 at gmail.com

--- Comment #63 from swatilodha27 at gmail.com ---
Hello Richard.

I'm Swati, currently working on digiKam MySQL database support project. I read
this open bug for MySQL Schema improvements and thought of a plausible solution
to handle the tags (rename, move or delete)

An image can have many tags and a tag can belong to multiple image. So to
handle this many-many relationship between the two, we could take use of the
following tables:

 Table: Image
Columns: Image_ID, Image_Title

Table: Tag
Columns: Tag_ID, Tag_Title

Table: Image_Tag
Columns: Tag_ID, Image_ID

Setting the Image_ID and Tag_ID as foreign keys would help in linking the

Maybe this will help. 


You are receiving this mail because:
You are the assignee for the bug.

More information about the Digikam-devel mailing list