Tables


SchemaSpy Analysis of bufferrhythm.public

Generated on Tue Sep 22 22:51 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 7
VIEWS 0
COLUMNS 51
Constraints 0
Anomalies 0
Routines 0

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