(Great changes skipped)
On 17/03/12 18:34, Maarten Dammers wrote:
I'm thinking about creating a table monument_templates with the fields: lang, country and template. This would be a really small table based on https://fisheye.toolserver.org/browse/erfgoed/erfgoedbot/monuments_config.py... with (lang, country) as primary key.
Good idea. But take into account that some of them contain several parameters (eg. they can point to several monument dbs).
The second table would be monument_images with the fields: template, id, image. This would be a much bigger table containing all the images tagged with a tracker template. Not really sure what keys to set here for performance. Any thoughts?
I'd include all the data from the image. The keys should be based on the queries to perform. Something like template_id, upload_time perhaps.