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 |