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

[Karsten Hilbert]

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

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346