> 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 _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
