[Tagging] football or soccer ?

John F. Eldredge john at jfeldredge.com
Mon Aug 2 17:56:36 BST 2010


Well, in this particular case, the issue was regional preferences about whether to call a particular game football, association football, soccer, etc., and the reason for using a link to an associated table was so that multiple names could map to the same field value.



-------Original Email-------
Subject :Re: [Tagging] football or soccer ?
From  :mailto:osm at inbox.org
Date  :Mon Aug 02 10:28:34 America/Chicago 2010


On Mon, Aug 2, 2010 at 10:56 AM, Anthony <osm at inbox.org> wrote:
> If I wanted the list of colors to be controlled and
> finite I'd use a check constraint.

By the way, if I were going to use a separate table for the list of
colors, for instance for performance purposes, I'd still use the name
of the color as the key, thus avoiding doing a join every single time
you do a select.  The lookup would only be necessary when doing adds,
in order to check the foreign key constraint.  The lookup table on
color would have only one column, the color name.

_______________________________________________
Tagging mailing list
Tagging at openstreetmap.org
http://lists.openstreetmap.org/listinfo/tagging

-- 
John F. Eldredge -- john at jfeldredge.com
"Reserve your right to think, for even to think wrongly is better than not to think at all." -- Hypatia of Alexandria


More information about the Tagging mailing list