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 |
|---|---|---|---|---|---|
| compaction_jobs | 2 | 0 | 17 | Table | {“what”:“A record of a single compaction job execution attempt.”,“why”:“Tracks each compaction run to monitor progress, results, and failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:26.738565619+00:00”} |
| validation_verdicts | 0 | 1 | 9 | Table | {“what”:“One row per validation run, capturing whether intent, facts, and constraints were preserved, plus a drift score.”,“why”:“Without it, there is no history of validation outcomes, so regressions in output quality cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:19:22.127260991+00:00”} |
| guidelines | 0 | 0 | 7 | Table | {“what”:“A set of versioned guideline rules, each with a domain, content, and activation status.”,“why”:“Without it, there is no central place to store and retrieve guidelines for enforcement or reference.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:47.566487368+00:00”} |
| sealed_blocks | 0 | 0 | 5 | Table | {“what”:“Immutable content blocks grouped by session; each row is one sealed block.”,“why”:“Preserves a tamper-evident record of session content for later replay or verification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:39.152025471+00:00”} |
| bench_runs | 0 | 0 | 9 | Table | {“what”:“One benchmark execution: fixture, token counts, compression, timing, and quality scores.”,“why”:“Without it, benchmark results are not persisted, so regression tracking is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.807839409+00:00”} |
| pinned_constraints | 0 | 0 | 8 | Table | {“what”:“Pinned constraint definitions with metadata for categorization, priority, and activation.”,“why”:“Without it, the system cannot know which constraints are pinned and their priority for enforcement.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:36.623629579+00:00”} |
| compaction_history | 0 | 1 | 7 | Table | {“what”:“History of compaction runs, each row one operation.”,“why”:“Without it, no audit trail of when and how compaction changed data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.099248647+00:00”} |