With Datadmin, our data maintenance tool you can edit and extend the database of OpenHomeopath.
For using Datadmin you've first to log in.
You can choose the database table for editing in a drop-down menue.
You can view and edit the following tables:
Materia Medica – contains the remedy descriptions of the Materia Medica with source references.
Symptoms – contains the symptoms and their relations among each other.
Sources – contains the sources with a detailed description.
Remedies – contains the remedies.
Main rubrics – contains the main rubrics.
I will give you a detailed description of each table:
Table Materia Medica
In the table Materia Medica you find the following fields:
Remedy – you can choose the remedy from a drop-down list related to the Remedies table.
Source – you can choose the source of the materia medica from a drop-down list related to the Sources table.
Details about preparation, origin and synonyms of the remedy.
Description – for a detailed description of the remedy in general.
Related remedies, Incompatible remedies and Antidotes – as abbreviations separated by semicolon (';').
Leading symptoms in the categories Genarel, Mind and Body – for a detailed description of the leading symptoms.
The fields Remedy and Source are mandatory. The other fields only show up in the Materia Medica, when they're filled in.
The table Symptoms contains 3 mandatory fields:
Symptom – the symptom description,
Main rubric – here you can choose the main rubric from a drop-down list,
Language – here you can choose the language from a drop-down list.
The table Sources contains 6 mandatory fields:
Source ID – a short name for the source. Up to 12 alphanumeric characters are allowed.
Title – the title of the source.
Language – choose from a drop-down list,
Source type – choose from a drop-down list,
Maximum grade – choose the maximum grade that is used in the source,
In the table Remedies you've also the possibility to select the records by the first letter of the remedy abbreviation.
In the table Symptoms you can select records by main rubric.
With "Export to CSV" you can export the current record selection to a semicolon seperated CSV-file.
Edit and insert of records
You can reach the edition form from the -Symbol in front of each table row and the insert form from "Insert" in the menue bar.
The difference between the two form is, that the insert form is a blank form and in the edit form you find the data of the current record with the possibility to jump with "<< Previous" to the previous and with "Next >>" to the next record.
Mandatory fields are signed by an asterisk (*) before the field name.
There're 3 types of fields:
multi-line textareas – line feeds are generally preserved,
You find hints to fill out the fields behind the fields. Details for each table you find in the corresponding table chapter.