The patients' data are stored in thirteen tables. All of them can be
joined using the primary key, the patient's number. Each patient gets a
unique number assigned by the program, and the user is not able to
influence or change this number. The personal information including
date of birth, sex, address, date of first diagnoses, and the type of
diabetes mellitus is stored in a table called
diabetik . Each patient has
exactly one set of data in this table. The main information about the
treatment of his illness is stored in the table
verlauf
. Each time a patient
is in a surgery or hospital a new entry in this table is created. It
contains the majority of data including size, weight, blood pressure,
quality of the patient's eyes, number of hypoglycemic episodes, insulin
therapy, number of injections, and the quality of the patient's
self-monitoring. If this treatment was done in a hospital, one
additional set of data is stored in the table
stat1 . It contains the reason for the
patient's presence in the hospital and the time he stayed there. For
each day in the hospital, an entry in the table
stat3 is produced. It basically
contains the amount of insulin given, the calories eaten, and the
glucose concentration in the blood. There are further tables for
additional examinations and information like extra eye checks, neuronal
tests, the psychosocial environment the patient lives in, pregnancy,
information about his urine, and special treatments like schooling.
For the exact structure of those tables please check the appendix A.