(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.p…
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.