## Patients

PatientID | FirstName | LastName | DateOfBirth | InsuranceProvider | Address
--- | --- | --- | --- | --- | ---
1 | John | Doe | 1985-07-30 | Blue Cross Blue Shield | 123 Main St
2 | Jane | Smith | 1990-06-15 | Aetna | 456 Elm St

## Doctors

DoctorID | FirstName | LastName | Specialization | PhoneNumber | EmailAddress
--- | --- | --- | --- | --- | ---
1 | Dr. | Jones | Cardiology | 555-1234 | drjones@example.com
2 | Dr. | Williams | Neurology | 555-5678 | dwilliams@example.com

## Appointments

AppointmentID | PatientID | DoctorID | AppointmentDate | ReasonForVisit
--- | --- | --- | --- | ---
| (→ Patients.PatientID) | (→ Doctors.DoctorID) |  |
1 | 1 | 1 | 2022-01-15 10:00:00 | Routine Checkup
2 | 2 | 2 | 2022-02-10 14:00:00 | Headache

## Prescriptions

PrescriptionID | AppointmentID | MedicationName | Dosage | Instructions
--- | --- | --- | --- | ---
| (→ Appointments.AppointmentID) |  |  |
1 | 1 | Ibuprofen | 2 tablets every 6 hours | Take with food
2 | 2 | Amoxicillin | 500mg twice a day | Take with water on an empty stomach

## SurgicalProcedures

ProcedureID | Description | InsuranceCovered | OutOfPocketExpense | TimeRequired
--- | --- | --- | --- | ---
1 | Knee Arthroscopy | 5000 | 1000 | 2 hours
2 | Appendectomy | 4000 | 2000 | 1 hour