OpenEMR development for Clinical research.
How can we devise a searchable relational database with a schema such that a patient’s signs & symptoms, examination findings, and lab results can be entered in a specific format along with the therapeutic treatment and outcome. In this way we query the database to assess clinical therapeutic effectiveness and compare treatment options.
In a similar way to where we have the patient_data file schema, we can have a comprehensive diagnostic schema with all possible signs & symptoms, etc AND have it set up in such a way that the user can input the data from an online health questionnaire and have the data automatically sorted into the database in the appropriate fields columns, rows, etc. In this way every column entry will correspond to the same sign or symptom or left blank if not applicable.
It should then be easier to query and compare ICD-10 diagnosis, Signs & symptoms along with quantifying severity with subjective questionnaires, and objective testing and then be able to track progress in association with specific therapeutic treatment.