From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | Ognjen Blagojevic <ognjen(at)etf(dot)bg(dot)ac(dot)rs> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [offtopic] How do you name a table... |
Date: | 2010-04-08 13:30:33 |
Message-ID: | 20100408093033.cfd78b27.wmoran@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to Ognjen Blagojevic <ognjen(at)etf(dot)bg(dot)ac(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Graf | 2010-04-08 14:19:33 | Re: [offtopic] How do you name a table... |
Previous Message | Karsten Hilbert | 2010-04-08 13:22:30 | Re: [offtopic] How do you name a table... |