Hello guys,
Sorry for the long post, but I needed to explain the full idea of the database so you can know what I am talking about.
I am starting a new database about a public health care center (PHC) which is supported* by the NGO where I work
I first want to start with profiling the PHC, identify the staff with their roles (doctor, nurse, pharmacist), create family files (for the full family) and identify patients per family.*The patient pays a reduced amount of money per consultation while we pay the remaining and provide medicines, laboratory tests and radiology for free
The procedure goes as follows:
- The patient comes to the PHC, he gets registered by a nurse
- If the patient came for pharmacy, he goes directly to the pharmacy.
- If the patient came for vaccination, he could go into two scenarios:
- The nurse will do the triage (Measuring temperature, blood pressure, etc), then:
- He goes directly to vaccination.
- He goes to a consultation (checked by a doctor) and then goes to vaccination.
- If the patient came for consultation:
- The nurse will do the triage (Measuring temperature, blood pressure, etc), then:
- he goes to see the doctor.
- After the consultation is done, we have different scenarios:
- The doctor can directly diagnose the disease
- The doctor is suspicious with a disease so he asks for a lab test
- When the result is received, doctor diagnose the disease
- The doctor is suspicious with a disease so he asks for radiology
- When the result is received, doctor diagnose the disease
- After diagnosing the case, he gives a prescription that will be received at the pharmacy.
- As for the pharmacy, there will be medicines from different suppliers.
- Medicines prescribed will be deducted from the medicines stock.
- If the patient is pregnant:
- We create her a pregnancy file
- Regular antenatal and postnatal check up will be done until delivery or abortion
I started to work on identifying the tables and relationships and created the first draft, what do you think?
Thank you for your support.