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 |
|---|---|---|---|---|---|
| generated_clis | 0 | 0 | 10 | Table | |
| page_cache | 0 | 0 | 12 | Table | {“what”:“Cache of fetched web pages keyed by URL hash.”,“why”:“Without it, repeated fetches of same URL are redundant and slow.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:24.597086054+00:00”} |
| read_metrics | 0 | 0 | 8 | Table | {“what”:“One row per read event, with token usage and cache status.”,“why”:“Without it, no record of read performance or cache effectiveness exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.251615060+00:00”} |
| _sqlx_migrations | 0 | 0 | 6 | Table | {“what”:“Table recording each applied migration for the sqlx migration tool.”,“why”:“Without it, the migration tool cannot know which migrations have run, causing re-runs or skips.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:19.507414486+00:00”} |
| read_sessions | 0 | 0 | 13 | Table | {“what”:“A reading session for a URL, with status, progress, and token counts.”,“why”:“Without it, there is no record of which URLs have been read, their status, or token consumption.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:32.339510317+00:00”} |
| route_decisions | 0 | 0 | 8 | Table | {“what”:“Historical log of routing decisions, each with rule version and reason.”,“why”:“Without it, past routing decisions and their rationale are lost, making debugging and compliance impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.269824194+00:00”} |
| site_configs | 0 | 0 | 7 | Table | {“what”:“One row per host with its site-specific configuration.”,“why”:“Without it, there is no single place to look up host-specific settings for shortcuts, headers, and rewriting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.627451758+00:00”} |