[Digikam-devel] What do we want to store in the database?

[Marcel Wiesweg]

Am Freitag 31 August 2007 schrieb Gilles Caulier:
> 2007/8/31, Marcel Wiesweg <marcel.wiesweg at gmx.de>:
> > > I think Multiple Comments is essential. But also comments need to be
> > > qualified more than just a simple text stream. Gilles mentioned 4
> > > strings to be stored but I'm not sure what they all are. My suggestion
> > > would be:
> > >  * Source
> > >  * Who/Author
> > >  * Language
> > >  * Comment
> >
> > Gilles, was that what you meant with 4, a table for multiple comments
> > with four columns like the ones above?
>
> I thinking 4 (more if you want) different comments as UTF-8 strings.
> Nothing special about that. We can use like we want, for example to store
> text in many language, or text come different photographers.
>
> You course this still to define more. What the advantage to use a table we
> host all strings against 4 separate strings ?

Ok, in this case we will store each comment in its own row in a table like 
this:
imageid INTEGER
description TEXT
value TEXT

Colin suggested to store (instead of "description" above) source, author and 
language for each comment.