Integrity certificate for Clinical trial: sites, patients, visits and adverse events
Re-run against these exact files.

Every line below was measured, not asserted. The CSVs are right here and the checks are ordinary joins.

  PASS  trials.trial_id: 0 duplicate(s), 0 null(s)
  PASS  sites.site_id: 0 duplicate(s), 0 null(s)
  PASS  sites.trial_id -> trials.trial_id: 0 orphan(s) of 9 rows
  PASS  patients.patient_id: 0 duplicate(s), 0 null(s)
  PASS  patients.site_id -> sites.site_id: 0 orphan(s) of 314 rows
  PASS  patients.trial_id -> trials.trial_id: 0 orphan(s) of 314 rows
  PASS  treatment_visits.visit_id: 0 duplicate(s), 0 null(s)
  PASS  treatment_visits.patient_id -> patients.patient_id: 0 orphan(s) of 3,083 rows
  PASS  treatment_visits.trial_id -> trials.trial_id: 0 orphan(s) of 3,083 rows
  PASS  treatment_visits.site_id -> sites.site_id: 0 orphan(s) of 3,083 rows
  PASS  dose_administrations.admin_id: 0 duplicate(s), 0 null(s)
  PASS  dose_administrations.visit_id -> treatment_visits.visit_id: 0 orphan(s) of 2,967 rows
  PASS  dose_administrations.patient_id -> patients.patient_id: 0 orphan(s) of 2,967 rows
  PASS  lab_biomarkers.lab_id: 0 duplicate(s), 0 null(s)
  PASS  lab_biomarkers.visit_id -> treatment_visits.visit_id: 0 orphan(s) of 17,802 rows
  PASS  lab_biomarkers.patient_id -> patients.patient_id: 0 orphan(s) of 17,802 rows
  PASS  adverse_events.ae_id: 0 duplicate(s), 0 null(s)
  PASS  adverse_events.patient_id -> patients.patient_id: 0 orphan(s) of 716 rows
  PASS  adverse_events.visit_id -> treatment_visits.visit_id: 0 orphan(s) of 716 rows
  PASS  adverse_events.trial_id -> trials.trial_id: 0 orphan(s) of 716 rows
  PASS  no row is dated before the row it belongs to

21 checks, 21 passing.
Generated by Misata Studio -- https://www.misata.studio
