Patients

PatientIDFirstNameLastNameDOBPhoneNumberEmailAddress
1JohnDoe1987-06-15+1234567890john.doe@example.com

Doctors

DoctorIDFirstNameLastNameSpecialtyLicenseNumberOfficePhone
1JaneSmithCardiologyLIC001234567+0987654321

Medications

DrugIDNameClassificationManufacturerSide_EffectsEffectiveness
1AspirinAnalgesicBayerGastrointestinal upsetHigh

Prescriptions

PrescriptionIDPatientIDDoctorIDMedicationIDStartDateEndDateQuantity
(→ Patients.PatientID)(→ Doctors.DoctorID)(→ Medications.MedicationID)
11112022-01-012022-01-3110

Diagnoses

DiagnosisIDPatientIDDoctorIDCodeDescription
(→ Patients.PatientID)(→ Doctors.DoctorID)
111A123Hypertension

Appointments

AppointmentIDPatientIDDoctorIDAppointmentDateTimeReasonForVisitIsCancelled
(→ Patients.PatientID)(→ Doctors.DoctorID)
1112024-02-19 12:14:44Routine checkup0