[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:coun

From: J Busser
Subject: Re: [Gnumed-devel] Questions re database schema:street:address:urb:country
Date: Wed, 1 Sep 2004 00:04:59 -0700

At 7:26 AM +1000 9/1/04, E Dodd wrote:
We definitely have sub-urbs
in our town as well as villages outside the town
we use the town (urb) name and the village name in an address but not the
sub-urb name. They exist on signs and people use them to describe which part
of the town, but there are no overlapping road names within the town....

Wading in...

Liz mentioned that a Village name can be important inside an URB for example for mailing purposes.

In Canada, line 2 of the address requires the form:
<building number> <street name> <street type> <direction> [comma] <within-building info>

my office address would be
Dr J Busser
575 8th Ave W, Suite 350
Vancouver BC  V5Z 1C6

(in Canada, line 2 could alternatively have been 350-575 8th Ave W)

Sometimes it is necessary for mailing to provide Postal Box information and in Canada this must be provided on a separate line below the address line. IOW it cannot be accommodated within the current "addendum". One extra field, perhaps called "addr_line2", would better support "village" or "postal box".

If we are refining usage of the "addendum" field, can the field be renamed "unit number"
(it is the official designation in Canada).

Also, the schema presently requires me to store "8th Ave W" all together as the street name. This seems workable and may even be desirable. Adding separate fields <street type> and <direction> would be more fiddly although without such fields more care is required by the office staff during the creation (input) of new street values.

I just realized what a tremendous headache it will be trying to import non-normalized patient demographic data into GnuMed - groan!

reply via email to

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