In SQL: I have a table FACILITIES $($FacilityID PRIMARY KEY, FacilityName, FacilityAddress, FacilityPhone, FacilyType$)$

FacilityType refers to subtype tables of

$1)$AFFILIATION $($FacilityID PK$,$ AffiliationStartDate, AffiliationEndDate, StaffType, AffiliationVerified$)$;

$2)$EMPLOYER $($FacilityID PK$,$ HireDate, TermDate, Position, HRContactName$)$

$3)$ CLIENT $($FacilityID PK$,$ ContactName, ContactEmail, ConstractStart, ContractEnd, ContractActive$)$

As is$,$ the FACILITY can be $1$ or more of the subtypes $-$ which is true. A facility can be both a client and an employer. How do I write a script tying the subtypes to FACILITY? Do I need to add a junction table?