[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: Karsten Hilbert
Subject: Re: [Gnumed-devel] Questions re database schema:street:address:urb:country
Date: Tue, 31 Aug 2004 11:53:16 +0200
User-agent: Mutt/

> > 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)

> suburb was not there in the original version, don't know who put it there, 
> it's a mistake.
Well, no one spoke up when I put it there. I recently even
asked how to handle it right here on the list. Also, WHY is it
a mistake ? It makes perfect sense in DE.

> id_street is indeed a foreign key and there should be a "references 
> street(id)" after the deinition of the id_street column.
There is. Deficient viewers are in use here.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

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