Founding_Year

idyear
11980
22003
31965
41978
51992

Past_Owners

idowner_nameacquisition_year
1Owner A2000
2Owner B2005
3Owner C2010
4Owner D2015
5Owner E2020

Healthcare_Facilities

idnameaddressfounding_idpast_owner_id
(→ Founding_Year.id)(→ Past_Owners.id)
1Facility 1Address 111
2Facility 2Address 222
3Facility 3Address 333
4Facility 4Address 444
5Facility 5Address 555

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