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 |
doctorID | firstName | lastName | specialty | yearsExperience |
---|---|---|---|---|
1 | Dr. | Jones | Cardiology | 10 |
2 | Dr. | Williams | Pediatrics | 15 |
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 |
diagnosisID | patientId | illnessId | diagnosedDate |
---|---|---|---|
(→ Patients.id) | (→ Illnesses.illnessID) | ||
1 | 1 | 1 | 2022-01-15 |
2 | 2 | 2 | 2021-09-01 |
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 |
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 |