Re: [offtopic] How do you name a table...

In response to Ognjen Blagojevic <ognjen@etf.bg.ac.rs>:

> Hi,
>
> How do you name a table which sole purpose is to store a list of values?
> E.g.
>
> Table: sex
> id name
> -------
> 1 male
> 2 female
>
> Table: day
> id name
> -------
> 1 Sunday
> 2 Monday
> 3 Tuesday
> 4 Wednesday
> 5 Thursday
> 6 Friday
> 7 Saturday
>
> Is this:
> a. Lookup table
> b. Classifier
> c. Cypher(er)?
>
> I'm looking for the appropriate term in English.

I try to make it an ENUM when it's very unlikely to change, i.e. day of
the week is a good candidate for an enum ... when's the last time that
changed?

For lookup tables that aren't static enough to be an enum, it usually
ends up appended with _list (i.e. gender_list, county_list, etc)

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/