## Patients

PatientID | FirstName | LastName | DOB | PhoneNumber | EmailAddress
--- | --- | --- | --- | --- | ---
1 | John | Doe | 1987-06-15 | +1234567890 | john.doe@example.com

## Doctors

DoctorID | FirstName | LastName | Specialty | LicenseNumber | OfficePhone
--- | --- | --- | --- | --- | ---
1 | Jane | Smith | Cardiology | LIC001234567 | +0987654321

## Medications

DrugID | Name | Classification | Manufacturer | Side_Effects | Effectiveness
--- | --- | --- | --- | --- | ---
1 | Aspirin | Analgesic | Bayer | Gastrointestinal upset | High

## Prescriptions

PrescriptionID | PatientID | DoctorID | MedicationID | StartDate | EndDate | Quantity
--- | --- | --- | --- | --- | --- | ---
| (→ Patients.PatientID) | (→ Doctors.DoctorID) | (→ Medications.MedicationID) |  |  |
1 | 1 | 1 | 1 | 2022-01-01 | 2022-01-31 | 10

## Diagnoses

DiagnosisID | PatientID | DoctorID | Code | Description
--- | --- | --- | --- | ---
| (→ Patients.PatientID) | (→ Doctors.DoctorID) |  |
1 | 1 | 1 | A123 | Hypertension

## Appointments

AppointmentID | PatientID | DoctorID | AppointmentDateTime | ReasonForVisit | IsCancelled
--- | --- | --- | --- | --- | ---
| (→ Patients.PatientID) | (→ Doctors.DoctorID) |  |  |
1 | 1 | 1 | 2024-02-19 12:14:44 | Routine checkup | 0