I think is not a good idea at all to mix data-structure information with stored information.
I think that the use of ontologies could be a solution in this issue. Maybe a central ontology repository stored in xml files and then each implementation/adaptation of Care2x using the sub-ontologies needed for each case. This will not only offers flexibility to the clinical record structure but also assure interoperability between different implementations (if they use the same central ontology). regards, Julio Bonis Sanz MD On lun, 2006-07-10 at 13:45 +0300, Reinier wrote: > Hi Robert, > > In general, i think this would add a lot of flexibility to the Registration > of patient, which is good. There might be some performace penalties, we'd > have to see if they are manageble. > > The diagram does not come out very well in my mailclient. Maybe you could > make a small ER or UML diagram with the tables that you propose and the links > between them in a graphic program? > > > rgds, > > reinier > > > On Monday 10 July 2006 12:19, Robert Meggle wrote: > > Hello all, > > > > About the discussion in this list (-> patient registration and the big > > vision to get a very flexible structure in it). I want to talk about the > > data structure here, not about the GUI realisation part. > > > > Nearly all hospitals, counties, countries will have own ideas of storing > > demographic data. > > > > What is the situation right now? The situation is that every programmer what > > have the aim of integration taking the table care_person and add their own > > columns. Or even misusing given ones for their own use. > > For a wider perspective I will suggest an idea. An idea of having a better > > data structure... Please let's talk about it and give your comments to it: > > > > What is the requirement for a patient Table: > > -> The PID must be unique (is now realized of having an auto-increment > > primary key column) > > -> The date-field of the creation date (date_reg) > > -> Optional fields... First name, last name, phone number, street, PO-Box, > > ZIP.... > > > > What do you think about having now following structure? > > > > care_person: > > ID | date_reg | parent | value | data > > 1 | 1998-01-01 00:00:00 | -1 | PID | 1 > > 2 | NULL | 1 | firstname | test > > 3 | NULL | 1 | lastname | nobody > > .. | ... | ... | ... | ... > > 10 | 1998-01-01 00:00:00 | -1 | PID | 1 > > 11 | NULL | 10 | firstname | test person 2 > > 12 | NULL | 10 | lastname | nobody 2 > > ... > > > > > > -> The content (firstname, lastname ...) will be described in an > > additionally table. > > > > Basic idea of this hierarchical structure: A non auto increment-identifier > > (column: PID) will point to the primary key (column: ID) of the table. If > > the “parent” has the value -1 it will describe the root. If you want all > > data’s of this “value” “pid” “1” then you have to select this table to > > ID=parent. > > The last table it is not clear for me (for the moment). Idea is that every > > adaptation can insert there the possible values of the content table. > > Additionally to that even the attribute value like “checkbox”, “input > > field”, “select box”->and their possible values of it (maybe). > > > > This is quite an idea. Let me know what you think about. This change will > > affect nearly all kind of modules of care2x (my hope: basically the > > class_core -> but it is quite a lot of work to be done when it should work!) > > > > What I do not like in my idea are following issues: > > -> The primary key-value points to an key (It´s might be okay, but:) > > -> the data column should have a global data type and I do not like that > > idea. > > > > Any suggestions or ideas? > > Robert > > > > > > > > > > ------------------------------------------------------------------------- > > Using Tomcat but need to do more? Need to support web services, security? > > Get stuff done quickly with pre-integrated technology to make your job > > easier > > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
