[Digikam-devel] Schema update in branch

[Johannes Wienke]

Am 04.07.2010 16:30 schrieb Marcel Wiesweg:
> 
>> Sounds good! I tried to come up with some property names and added them
>> to the wiki page. [1]
>>
>> So far, I have only one open question: How do we store region
>> annotations which are not associated with a tag? For example, if the
>> user describes something other than a person, for which he just wants
>> some sort of description, but no tag?
> 
> What's the usecase?
> 
> This is the kind of stuff which you dont think about when designing the SQL 
> tables.
> 
> Normally, this would be a comment/description and should go into the 
> ImageComments table.
> Any of the traditional types of comment - Comment, Headline, Title - do not 
> have associated region information.
> We can add a type of comment which comes with region information. This 
> information can be stored
> a) in a separate field in the table. Problem: would this field be allowed for 
> a normal comment, which usually applies to the whole picture? Second problem: 
> The UNIQUE clause would allow only one of such entries per picture
> b) with the current schema, in XML in the comment field. Problem: Once again, 
> the UNIQUE clause interferes, limiting to one entry per picture and author.
> 
> The ImageProperties table has a UNIQUE clause as well.
> 
> We could abuse the ImageTagProperties table, with a tagid of 0. But here, 
> there is no author / date information.

To my mind this is something generally not covered by the db so far. An
annotated region is definitely more than a normal comment. So this needs
a completely new table that associates each picture with n such region
annotations (1-N relation).

Johannes

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20100704/dc857117/attachment.sig>