Patients

patient_idnameage
1John Smith30
2Jane Doe28
3Tom Brown40
4Emily White26
5Michael Johnson32

Doctors

doctor_idnamespecialty
1Dr. John DoeCardiology
2Dr. Jane SmithNeurology
3Dr. Tom WilliamsPsychiatry
4Dr. Emily JonesEndocrinology
5Dr. Michael TaylorGastroenterology

Medications

medication_idantibioticcommon_side_effectsserious_side_effectsdosage
1AmoxicillinDiarrhea, nauseaRash, liver damage500mg every 12 hours
2CiprofloxacinNausea, diarrheaTendonitis, allergies500mg twice daily
3AzithromycinHeadache, dizzinessHearing loss, liver damage500mg once daily
4LevofloxacinDizziness, headacheAllergies, tendonitis750mg once daily
5MetronidazoleNausea, vomitingPeripheral neuropathy, seizures500mg three times a day

Prescriptions

prescription_idpatient_iddoctor_idmedication_idstart_dateend_date
(→ Patients.patient_id)(→ Doctors.doctor_id)(→ Medications.medication_id)
11112023-01-012023-01-10
22222023-01-152023-01-25

DoctorPatient

doctor_patient_iddoctor_idpatient_idrelationship
(→ Doctors.doctor_id)(→ Patients.patient_id)
111Primary Care Physician
222Specialist Referral

Diagnosis

diagnosis_idpatient_iddiagnosis_textdiagnosis_code
(→ Patients.patient_id)
11HypertensionI10.9
22Type 2 diabetes mellitusE11.9