|
From: | Jim Busser |
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 ref.providers 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) So… should ref.providers 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) - or normalizing out the address and phone channels? -- Jim |
[Prev in Thread] | Current Thread | [Next in Thread] |