Historical_Context

idyear
11980
22003
31965
41978
51992

Employees

idemployee_namepositionhealthcare_facility_id
(→ Healthcare_Facilities.id)
1Emp 1Doctor1
2Emp 2Nurse1
3Emp 3Receptionist2
4Emp 4Pharmacist2
5Emp 5Housekeeper3

Patients

idpatient_nameagehealthcare_facility_id
(→ Healthcare_Facilities.id)
1Patient 1451
2Patient 2601
3Patient 3302
4Patient 4552
5Patient 5253

Treatments

idtreatment_namestart_dateend_datepatient_idhealthcare_facility_id
(→ Patients.id)(→ Healthcare_Facilities.id)
1Surgery2022-01-012022-01-0511
2Physiotherapy2022-01-012022-01-3121
3Medication2022-02-012022-02-2832
4Dialysis2022-02-012022-02-2842
5Checkup2022-03-012022-03-0153

Healthcare_Facilities

idnameaddressfounding_id
(→ Historical_Context.id)
1Facility 1Address 11
2Facility 2Address 22
3Facility 3Address 33
4Facility 4Address 44
5Facility 5Address 55