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 |