Patients

idfirstNamelastNamedateOfBirthgendercontactNumberaddress
1JohnDoe1980-06-15M+1234567890123 Main St
2JaneSmith1990-07-25F+0987654321456 Elm St

Doctors

doctorIDfirstNamelastNamespecialtyyearsExperience
1Dr.JonesCardiology10
2Dr.WilliamsPediatrics15

Illnesses

illnessIDnamedescriptionfiveYearSurvivalRatetenYearSurvivalRatetreatmentOption
1Breast CancerA disease where malignant cells form in the breast tissue.85.075.0Chemotherapy and radiation therapy
2DiabetesA chronic condition characterized by high blood sugar levels.85.075.0Diet, exercise, and insulin therapy

Diagnoses

diagnosisIDpatientIdillnessIddiagnosedDate
(→ Patients.id)(→ Illnesses.illnessID)
1112022-01-15
2222021-09-01

Prescriptions

prescriptionIddiagnosisIdmedicationdosagefrequencystartDateendDate
(→ Diagnoses.diagnosisID)
11Tamoxifen20mgOnce daily2022-01-162022-12-31
22Metformin500mgTwice daily2021-09-022022-08-31

Appointments

appointmentIdpatientIddoctorIdappointmentDatereasonForAppointmentoutcome
(→ Patients.id)(→ Doctors.doctorID)
1112022-02-01 10:00:00Regular checkupHealthy
2222021-11-15 14:00:00Flu symptomsRecovering