## Patients

patient_id | name | age
--- | --- | ---
1 | John Smith | 30
2 | Jane Doe | 28
3 | Tom Brown | 40
4 | Emily White | 26
5 | Michael Johnson | 32

## Doctors

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

## Medications

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

## Prescriptions

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

## DoctorPatient

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

diagnosis_id | patient_id | diagnosis_text | diagnosis_code
--- | --- | --- | ---
| (→ Patients.patient_id) |  |
1 | 1 | Hypertension | I10.9
2 | 2 | Type 2 diabetes mellitus | E11.9