Integrity certificate for Factory sensors with failure labels
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  sites.site_id: 0 duplicate(s), 0 null(s)
  PASS  assets.asset_id: 0 duplicate(s), 0 null(s)
  PASS  assets.site_id -> sites.site_id: 0 orphan(s) of 6 rows
  PASS  sensor_readings.reading_id: 0 duplicate(s), 0 null(s)
  PASS  sensor_readings.asset_id -> assets.asset_id: 0 orphan(s) of 52,560 rows
  PASS  failure_events.failure_id: 0 duplicate(s), 0 null(s)
  PASS  failure_events.asset_id -> assets.asset_id: 0 orphan(s) of 39 rows
  PASS  work_orders.work_order_id: 0 duplicate(s), 0 null(s)
  PASS  work_orders.asset_id -> assets.asset_id: 0 orphan(s) of 63 rows
  PASS  no row is dated before the row it belongs to

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