device_health

{“what”:“Unique device identifier (e.g., hostname or IP) used as primary key.”,“why”:“Identifies which device the health row belongs to; enables lookups and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.619960557+00:00”}

{“what”:“Boolean flag (0/1) indicating if the device responded to the last check.”,“why”:“Without it, cannot quickly filter or alert on unreachable devices.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.646755722+00:00”}

{“what”:“Timestamp (text) of the last successful contact from the device.”,“why”:“Shows staleness; without it, cannot tell if a device is just quiet or truly down.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.667353300+00:00”}

{“what”:“Timestamp (text) of the most recent health check attempt.”,“why”:“Distinguishes ‘never checked’ from ‘checked but unreachable’; needed for scheduling.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.691829307+00:00”}

{“what”:“Count of sequential failed checks since the last success.”,“why”:“Enables threshold-based alerting (e.g., after 3 failures) without scanning history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.713556833+00:00”}