About This Architecture
Hospital management system ERD with five core entities: DOKTER (doctors), PASIEN (patients), ADMINISTRATOR (staff), PEMERIKSAAN (medical examinations), and RESEP (prescriptions). Doctors conduct examinations and issue prescriptions to patients, while administrators manage patient records through foreign key relationships. The schema enforces referential integrity with primary and foreign keys, capturing clinical workflows from patient intake through diagnosis and medication dispensing. Fork this diagram on Diagrams.so to customize field names, add new entities like billing or lab results, or export as .drawio for use in your database design documentation. This normalized structure supports multi-user healthcare operations with clear separation of roles and audit trails.