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