| patient_id | name | age |
|---|---|---|
| 1 | John Smith | 30 |
| 2 | Jane Doe | 28 |
| 3 | Tom Brown | 40 |
| 4 | Emily White | 26 |
| 5 | Michael Johnson | 32 |
| doctor_id | name | specialty |
|---|---|---|
| 1 | Dr. John Doe | Cardiology |
| 2 | Dr. Jane Smith | Neurology |
| 3 | Dr. Tom Williams | Psychiatry |
| 4 | Dr. Emily Jones | Endocrinology |
| 5 | Dr. Michael Taylor | Gastroenterology |
| medication_id | antibiotic | common_side_effects | serious_side_effects | dosage |
|---|---|---|---|---|
| 1 | Amoxicillin | Diarrhea, nausea | Rash, liver damage | 500mg every 12 hours |
| 2 | Ciprofloxacin | Nausea, diarrhea | Tendonitis, allergies | 500mg twice daily |
| 3 | Azithromycin | Headache, dizziness | Hearing loss, liver damage | 500mg once daily |
| 4 | Levofloxacin | Dizziness, headache | Allergies, tendonitis | 750mg once daily |
| 5 | Metronidazole | Nausea, vomiting | Peripheral neuropathy, seizures | 500mg three times a day |
| prescription_id | patient_id | doctor_id | medication_id | start_date | end_date |
|---|---|---|---|---|---|
| (→ Patients.patient_id) | (→ Doctors.doctor_id) | (→ Medications.medication_id) | |||
| 1 | 1 | 1 | 1 | 2023-01-01 | 2023-01-10 |
| 2 | 2 | 2 | 2 | 2023-01-15 | 2023-01-25 |
| doctor_patient_id | doctor_id | patient_id | relationship |
|---|---|---|---|
| (→ Doctors.doctor_id) | (→ Patients.patient_id) | ||
| 1 | 1 | 1 | Primary Care Physician |
| 2 | 2 | 2 | Specialist Referral |
| diagnosis_id | patient_id | diagnosis_text | diagnosis_code |
|---|---|---|---|
| (→ Patients.patient_id) | |||
| 1 | 1 | Hypertension | I10.9 |
| 2 | 2 | Type 2 diabetes mellitus | E11.9 |