[Top][All Lists]

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

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

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Schema versus clin.test_org
Date: Fri, 08 Feb 2008 15:52:53 +0100

> versus clin.test_org

> Am just wondering about these tables...
The first important fact to know is that 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 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 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 while making it known
to the system as a lab happens in 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 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: which holds the *concept* of an org, eg "Leipzig GP Group Inc"
and dem.org_unit which foreign keys to and holds the concept
of branches, departments, whatnot, say, "Karsten's Praxis at 65 Riebeck

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 ? ;-)

GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung:

reply via email to

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