Patients

PatientIDFirstNameLastNameDateOfBirthInsuranceProviderAddress
1JohnDoe1985-07-30Blue Cross Blue Shield123 Main St
2JaneSmith1990-06-15Aetna456 Elm St

Doctors

DoctorIDFirstNameLastNameSpecializationPhoneNumberEmailAddress
1Dr.JonesCardiology555-1234drjones@example.com
2Dr.WilliamsNeurology555-5678dwilliams@example.com

Appointments

AppointmentIDPatientIDDoctorIDAppointmentDateReasonForVisit
(→ Patients.PatientID)(→ Doctors.DoctorID)
1112022-01-15 10:00:00Routine Checkup
2222022-02-10 14:00:00Headache

Prescriptions

PrescriptionIDAppointmentIDMedicationNameDosageInstructions
(→ Appointments.AppointmentID)
11Ibuprofen2 tablets every 6 hoursTake with food
22Amoxicillin500mg twice a dayTake with water on an empty stomach

SurgicalProcedures

ProcedureIDDescriptionInsuranceCoveredOutOfPocketExpenseTimeRequired
1Knee Arthroscopy500010002 hours
2Appendectomy400020001 hour