|Subject:||[Gnumed-devel] Orgs and providers was Re: GNUmed status 0.9.6 going forward|
|Date:||Wed, 29 Jun 2011 17:57:56 -0700|
On 2011-06-29, at 2:19 PM, Karsten Hilbert wrote:
Org handling is one of the two things I would like to
I would like us to define a table
Following is a comma-limited set of columns sourced for doctor information in BC.CA:
We can see that the above is non-normalized, providing per-doctor for
- multiple (up to 5) specialty statuses and
- multiple (up to 3) full "locations" (complete address, phone, fax)
adopt a similar (non-normalized) structure? Or would we fold it back on itself and instead:
- repeat one provider possibly multiple (up to 3 times) when they have more than one location, making each unique on
external_org_id + external_id_code + Address line 1 (Addr1)
but normalizing-out the qualifications?
- or normalizing out the address and phone channels?
|[Prev in Thread]||Current Thread||[Next in Thread]|