## Patients

id | firstName | lastName | dateOfBirth | gender | contactNumber | address
--- | --- | --- | --- | --- | --- | ---
1 | John | Doe | 1980-06-15 | M | +1234567890 | 123 Main St
2 | Jane | Smith | 1990-07-25 | F | +0987654321 | 456 Elm St

## Doctors

doctorID | firstName | lastName | specialty | yearsExperience
--- | --- | --- | --- | ---
1 | Dr. | Jones | Cardiology | 10
2 | Dr. | Williams | Pediatrics | 15

## Illnesses

illnessID | name | description | fiveYearSurvivalRate | tenYearSurvivalRate | treatmentOption
--- | --- | --- | --- | --- | ---
1 | Breast Cancer | A disease where malignant cells form in the breast tissue. | 85.0 | 75.0 | Chemotherapy and radiation therapy
2 | Diabetes | A chronic condition characterized by high blood sugar levels. | 85.0 | 75.0 | Diet, exercise, and insulin therapy

## Diagnoses

diagnosisID | patientId | illnessId | diagnosedDate
--- | --- | --- | ---
| (→ Patients.id) | (→ Illnesses.illnessID) |
1 | 1 | 1 | 2022-01-15
2 | 2 | 2 | 2021-09-01

## Prescriptions

prescriptionId | diagnosisId | medication | dosage | frequency | startDate | endDate
--- | --- | --- | --- | --- | --- | ---
| (→ Diagnoses.diagnosisID) |  |  |  |  |
1 | 1 | Tamoxifen | 20mg | Once daily | 2022-01-16 | 2022-12-31
2 | 2 | Metformin | 500mg | Twice daily | 2021-09-02 | 2022-08-31

## Appointments

appointmentId | patientId | doctorId | appointmentDate | reasonForAppointment | outcome
--- | --- | --- | --- | --- | ---
| (→ Patients.id) | (→ Doctors.doctorID) |  |  |
1 | 1 | 1 | 2022-02-01 10:00:00 | Regular checkup | Healthy
2 | 2 | 2 | 2021-11-15 14:00:00 | Flu symptoms | Recovering