Medical appointment system ER diagram modeling patient registration, appointment scheduling, and clinical workflows across six core entities. Patient records link to Appointments, which reference Services and generate XRay imaging data, Notifications, and post-visit Evaluations. Doctor and Secretary entities manage Services and AppointmentActions, while Reports enable analytics on appointment trends and outcomes. This normalized schema supports HIPAA-aligned healthcare operations with role-based access, audit trails via created_at timestamps, and flexible appointment states (pending, confirmed, cancelled, noshow). Fork this diagram on Diagrams.so to customize for your clinic's specializations, add insurance or billing tables, or export as .drawio for database migration planning. Consider adding a Prescription or MedicalHistory entity for comprehensive patient care documentation.