[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Questions re database schema:street:address:urb:count

From: Horst Herb
Subject: Re: [Gnumed-devel] Questions re database schema:street:address:urb:country
Date: Tue, 31 Aug 2004 00:26:44 +1000
User-agent: KMail/1.6.2

On Mon, 30 Aug 2004 08:22, Richard Terry wrote:
> 1) NOMENCLATURE in table generating queries:
>         -Given that one will be doing various joins (and I'm not sure if
> 8.0 supports outer), is there a reason not to name the ID's and feids
>  better:
> ===================================
> (
>   id serial NOT NULL,  (eg id_country serial NOT NULL)
>   code char(2) NOT NULL, (eg country_code....
>   name text NOT NULL,     (country_name)
>   deprecated date,               (country_deprecated)
> (
>   id_country serial NOT NULL,
>   country_code char(2) NOT NULL,
>   country_name text NOT NULL,   
>   country_deprecated date,..... etc

No, because in the join you have to explicitly name all duplicate columns like
select, from country, urb ...

The way yu would name it would notonly quickly exhaust the 32 byte variable 
length in some cases and cause finger cramps in poor programmers, it would 
also take a lot of reusability out of code (like a code weeding out all 
"deprecated" rows of a table)


reply via email to

[Prev in Thread] Current Thread [Next in Thread]