Healthcare IT Data Flow Design

Hello
I had around 6+ years of experience in Healthcare IT Solutions industry with that experience here I am publishing my views of DB Data flow without design.
(High level design)


1. Doctor appointment
2. Doctor Consultation
3. Out patient / In patient
4. If OP -> Doctor Prescription/ General medication
5. If IP - > Admission Process
6. Prescribing Admitting Ward/ Bed
7. General Lab Tests
8. If prescribe Operation -> OT booking date and time
9. Daily Doctor consultation/ Nursing care
10. General medication
11. Discharge.

Notation :
OP - > Out Patient
IP -> In Patient
OT  - > Operation Theatre

DB Master:
Geographic Locations Master
Ward
Bed
Theater
Employee Type
Lab tests
Surgical Master
Medicine Master