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:[email protected] Date :Mon Aug 02 10:28:34 America/Chicago 2010 On Mon, Aug 2, 2010 at 10:56 AM, Anthony <[email protected]> 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 [email protected] http://lists.openstreetmap.org/listinfo/tagging -- John F. Eldredge -- [email protected] "Reserve your right to think, for even to think wrongly is better than not to think at all." -- Hypatia of Alexandria _______________________________________________ Tagging mailing list [email protected] http://lists.openstreetmap.org/listinfo/tagging
