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 |