IoT
Devices, sensor channels, telemetry, alerts, heartbeats and health or predictive signals.
160
Source rows at Day-0
27
Populated tables
27
Exported tables
Collections
Devices2
Sensors, and the MES machine each is mounted on.
Sensor Channels2
What each device measures, and its expected range.
Measurements9
Sensor readings and their quality.
Alerts3
Threshold alerts raised by devices.
Heartbeats5
Device liveness checks.
Predictive Flags2
Health signals raised from trends in device readings.
Representative records
What these records become
Device ×2
Canonical records projected from IoT source records. A source record's own page links to the canonical record it resolves or projects to.
Cross-system journeys
Technical schema — 27 exported tables in iot_src
- alert3
- alert_acknowledgement1
- alert_event10
- audit_event34
- daily_aggregate1
- device2
- device_type4
- document_sequence2
- gateway1
- health_score1
- heartbeat5
- hourly_aggregate1
- idempotency_key44
- machine_state_observation1
- maintenance_recommendation_ref2
- measurement9
- measurement_quality1
- outbox_event6
- predictive_flag2
- role6
- sensor_channel2
- site_ref2
- threshold_rule2
- trend_signal1
- unit5
- user_account6
- user_role6