Hospital Management System ER Diagram
ER diagram for a hospital management system: patients, doctors, departments, appointments, admissions, rooms, prescriptions and billing, with keys and relationships.
How it flows
- doctors → departments
- rooms → departments
- appointments → patients
- appointments → doctors
- admissions → patients
- admissions → rooms
- admissions → doctors
- prescriptions → appointments
- prescriptions → doctors
- prescriptions → patients
- prescription_medicines → prescriptions
- prescription_medicines → medicines
- bills → patients
- bills → admissions
Components
patients · departments · doctors · rooms · appointments · admissions · prescriptions · medicines · prescription_medicines · bills