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

[Horst Herb]

On Mon, 30 Aug 2004 08:22, Richard Terry wrote:
> public.address
>
>           id serial NOT NULL,
>           id_street int4 NOT NULL, (presumably for key to public.street??)
>           suburb text,    (then why not for key to public.urb)
>           number char(10) NOT NULL,
>           addendum text, (what is addendum)
>          How come has not got an address type_ID (eg mailing/home/office
> etc
>
> if id_street is aforeign key for public.street, how come public.street has
> id_urb, and id_postcode?

suburb was not there in the original version, don't know who put it there, 
it's a mistake.
id_street is indeed a foreign key and there should be a "references 
street(id)" after the deinition of the id_street column.

street of course needs urb and postcode, because that's needed to uniquely 
identify a street (large urbs can have several streets of the same name, but 
then they are generally allocated different postcods)

Horst