Database Properties
Database Type: PostgreSQL - 18.4 (Ubuntu 18.4-1.pgdg24.04+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| tasks | 0 | 0 | 19 | Table | {“what”:“Work items awaiting or undergoing execution, with retry and scheduling metadata.”,“why”:“Without it, no durable record of pending or in-flight work exists, so failures lose tasks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:42.744615550+00:00”} |
| consumer_groups | 0 | 0 | 4 | Table | {“what”:“A consumer group with a single shared offset for its members.”,“why”:“Without it, consumer progress cannot be persisted across restarts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:21.860390688+00:00”} |
| device_health | 0 | 0 | 5 | Table | {“what”:“Per-device health snapshot: reachability, last contact, and failure streak.”,“why”:“Without it, no single place to see device status for monitoring and alerting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.568151823+00:00”} |
| dead_letters | 0 | 0 | 9 | Table | {“what”:“Table holding tasks that failed permanently after retries.”,“why”:“Without it, failed tasks would be lost, preventing investigation and manual recovery.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:30.956600029+00:00”} |
| consumer_offsets | 0 | 0 | 3 | Table | {“what”:“Tracks the last consumed message offset per device for a queue.”,“why”:“Without it, a device restart would re-read old messages or skip new ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:39.296633216+00:00”} |
| device_uptime_log | 0 | 0 | 4 | Table | |
| metrics_snapshots | 0 | 0 | 7 | Table |