[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

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