| 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 |
| DoctorID | FirstName | LastName | Specialization | PhoneNumber | EmailAddress |
|---|---|---|---|---|---|
| 1 | Dr. | Jones | Cardiology | 555-1234 | drjones@example.com |
| 2 | Dr. | Williams | Neurology | 555-5678 | dwilliams@example.com |
| 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 |
| 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 |
| ProcedureID | Description | InsuranceCovered | OutOfPocketExpense | TimeRequired |
|---|---|---|---|---|
| 1 | Knee Arthroscopy | 5000 | 1000 | 2 hours |
| 2 | Appendectomy | 4000 | 2000 | 1 hour |