Tables


SchemaSpy Analysis of compactrhythm.public

Generated on Tue Sep 22 22:56 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 7
VIEWS 0
COLUMNS 62
Constraints 2
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
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”}