On 4/8/2010 9:30 AM, Bill Moran wrote:
> In response to Ognjen Blagojevic:
>
>>
>> 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
In response to Ognjen Blagojevic :
> 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 Sat
On Thu, Apr 08, 2010 at 10:16:57PM +0900, Ian Barwick wrote:
> > How do you name a table which sole purpose is to store a list of values?
> (...)
> > Is this:
> > a. Lookup table
> > b. Classifier
> > c. Cypher(er)?
lookup (*_lu, lu_*) or enum or just what it is (gender,
document_type, ...)
Kars
Ognjen Blagojevic wrote:
Hi,
How do you name a table which sole purpose is to store a list of
values? E.g.
Is this:
a. Lookup table
b. Classifier
c. Cypher(er)?
d. valueset?
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
2010/4/8 Ognjen Blagojevic :
> Hi,
>
> How do you name a table which sole purpose is to store a list of values?
(...)
> Is this:
> a. Lookup table
> b. Classifier
> c. Cypher(er)?
>
> I'm looking for the appropriate term in English.
I'd call it a lookup-table.
Ian Barwick
--
Sent via pgsql-gen
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 fo
