[CAFCASS_CASECLOSURE] links to [CAFCASS_INCIDENT] via [CASEID_PE] = [INCIDENTID_PE]
[CAFCASS_CASECLOSURE] also links to [CAFCASS_CONTACT] via [CHILDID_PE] = [CONTACTID_PE] -- (although there were 2 records where [CHILDID_PE] had no corresponding records in [CONTACTID_PE]; there were also some NULL values in [CHILDID_PE])
The other 3 tables ([CAFCASS_CASECLOSUREEXPERTS], [CAFCASS_CASECLOSUREORDERS] and [CAFCASS_CASECLOSURETOOLS]) all link to [CAFCASS_CASECLOSURE] via CASECLOSUREID_PE = CASECLOSUREID_PE
and also to [CAFCASS_INCIDENT] via [CASEID_PE] = [INCIDENTID_PE]