[Top][All Lists]

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

Re: [Gnumed-devel] gmgis additional view

From: Horst Herb
Subject: Re: [Gnumed-devel] gmgis additional view
Date: Sun, 28 Apr 2002 21:22:12 +1000

There seems to be a lot of confusion regarding the view v_basic_address in 
reagard to the "type" of the address (like home address, work address etc)

The view is there to abstract the complexity of the normalized address 
components (like country, state, postcode, urb, street ...)

The type of an address is relative to the context of an identity (a person 
in most cases). A specific address might be one person's hoe addres, 
another person's holioday address, and yet another person's work address.

Thus, there is no benefit in a view listing only addresses of a certain 
"type" (like all "home addresses"), as this type has no meaning when taken 
out of the context of the concerning identity

If you need a person's home address, you need to create a query selecting 
from v_basic_address where addr_id = the person's home address

Creating a new view for this makes only sense when integrating the 
identity/person into the same view (such as the classic "patient pick 
list", where name and address are listed in the same row.
I would propose to name such a view v_addressbook


reply via email to

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