Re: [Gnumed-devel] Schema dem.org versus clin.test_org

[Karsten Hilbert]

> dem.org versus clin.test_org

> Am just wondering about these tables...
The first important fact to know is that dem.org isn't at all developed
into what it really should be. It serves as a stub other things
can point to which eventually want or have to point to a full-fledged
organization record.

> ... in dem.org is the field "description" intended to hold the name  
> of the organization?
Let's call it a "label" for now, yes.

> ... are the two tables intended to separate the organizations in  
> which patients may happen to work (into dem.org) but to keep separate  
> any health-care-related organizations?
Not "separate" in Cinderella terms but rather in SQL master-detail
table terms - the actual org is to be in dem.org while making it known
to the system as a lab happens in test.org which, quite incidentally,
holds a foreign key fk_org ;-)  That FK doesn't really have any relational
keyness yet as I figured we'd have to support test_orgs before fully
supporting dem.orgs. One can use the "comment" field to sort of name
test_orgs. And there's the field internal_name which can be used
to store a lab's idea of what it should identify itself in data
it sends out - which may not be a string useful for consumption by a
user on-screen.

> ... in which table would hospitals, pharmacies and medical clinic  
> orgs be created?
Eventually in dem.org. The main problem I am having is with the
granularity which to provide. I am thinking of a minimum hierarchy
akin to identity -> names. When we get around to adding orgs I'd
suggest having:

dem.org which holds the *concept* of an org, eg "Leipzig GP Group Inc"
and dem.org_unit which foreign keys to dem.org and holds the concept
of branches, departments, whatnot, say, "Karsten's Praxis at 65 Riebeck
Street".

In effect for the use case at hand: If a lab importer feels confident
about adding a missing lab it should do so in clin.test_org. I guess
that was the RFE ? ;-)

Karsten
-- 
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail