|
DREAM 6 Tables
|
description of the main tables used by the dream software
|
|
Patient data
|
Patient data is stored in d_person and d_person_att tables
|
|
Patient treatments
|
The d_status table records the status of a patient's membership in a particular program or service (treatment), or the the state of a particular condition that has a start and end date and can repeat over time
|
|
Appointments
|
Appointments are stored in the d_events table
|
|
Medical visit (appointment)
|
Medical visits are recorded in the table d_events (appointment) and d_events_att (visit details)
|
|
Medical visit --> Details
|
the medical visit details are stored in the D_EVENTS_ATT table with domain "A_VISIT"
|
|
Medical visit --> Symptoms
|
the medical visit symptomps are stored in the D_EVENTS_ATT table with domain "A_VSYMP"
|
|
Medical visit --> Diagnosis
|
the medical visit diagnosis are stored in the D_EVENTS_ATT table with domain "A_VDIAG"
|
|
Medical visit --> Posology
|
the medical visit posology are stored in the D_EVENTS_ATT table with domain "A_DPRES"
|
|
Blood tests (appointment)
|
The blood test appointment is store in the d_events table with domain 'APPOINTMENT' and category 'SAMPLE'
|
|
Blood tests --> Prescription
|
The blood test prescription is a record in the d_events_att table related the examination stored in the d_events table
|
|
Blood test --> Result
|
The blood test results are stored in d_events_att table, with different domains , one for each type of exam
|
|
Various indicators (Events)
|
punctual events that happen on a particular date and are stored in the d_events table
|
|
Urgent checks details (or Defaulter Tracing)
|
Details of urgent checks are stored in in D_Events_att. They are child records of the parent record in D_Events with domain "APPOINTMENT", category "APP" and event_type "APP_VERIFY"
|
|
Pregnancies
|
pregnancies are stored in d_status (start and the stop of the pregnancy (two records))
while in d_events there are all the informations about the pregnancy
|
|
Drug delivery (appointment)
|
Drug delivery are attributes of the domain = APPOINTMENT , event_type = APP_DRUGS in d_events table
|
|
AIDS Stage
|
The aids stage is stored in the d_evaluations table
|
|
Social data
|
Stored in D_Evaluation and D_Evaluation_att
|
|
Forms
|
Additional forms (pregnancy, screening, and others) stored in D_evaluations or D_events table
|
|
Family
|
the relationships between the members of the household are stored in the table d_person_fam
|