## Founding_Year

id | year
--- | ---
1 | 1980
2 | 2003
3 | 1965
4 | 1978
5 | 1992

## Past_Owners

id | owner_name | acquisition_year
--- | --- | ---
1 | Owner A | 2000
2 | Owner B | 2005
3 | Owner C | 2010
4 | Owner D | 2015
5 | Owner E | 2020

## Healthcare_Facilities

id | name | address | founding_id | past_owner_id
--- | --- | --- | --- | ---
|  |  | (→ Founding_Year.id) | (→ Past_Owners.id)
1 | Facility 1 | Address 1 | 1 | 1
2 | Facility 2 | Address 2 | 2 | 2
3 | Facility 3 | Address 3 | 3 | 3
4 | Facility 4 | Address 4 | 4 | 4
5 | Facility 5 | Address 5 | 5 | 5

## Employees

id | employee_name | position | healthcare_facility_id
--- | --- | --- | ---
|  |  | (→ Healthcare_Facilities.id)
1 | Emp 1 | Doctor | 1
2 | Emp 2 | Nurse | 1
3 | Emp 3 | Receptionist | 2
4 | Emp 4 | Pharmacist | 2
5 | Emp 5 | Housekeeper | 3

## Patients

id | patient_name | age | healthcare_facility_id
--- | --- | --- | ---
|  |  | (→ Healthcare_Facilities.id)
1 | Patient 1 | 45 | 1
2 | Patient 2 | 60 | 1
3 | Patient 3 | 30 | 2
4 | Patient 4 | 55 | 2
5 | Patient 5 | 25 | 3

## Treatments

id | treatment_name | start_date | end_date | patient_id | healthcare_facility_id
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Patients.id) | (→ Healthcare_Facilities.id)
1 | Surgery | 2022-01-01 | 2022-01-05 | 1 | 1
2 | Physiotherapy | 2022-01-01 | 2022-01-31 | 2 | 1
3 | Medication | 2022-02-01 | 2022-02-28 | 3 | 2
4 | Dialysis | 2022-02-01 | 2022-02-28 | 4 | 2
5 | Checkup | 2022-03-01 | 2022-03-01 | 5 | 3