Tables


SchemaSpy Analysis of cleanrhythm.public

Generated on Tue Sep 22 22:52 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 16
VIEWS 0
COLUMNS 144
Constraints 1
Anomalies 1
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
session_names 0 0 4 Table

{“what”:“Maps each session UUID to its agent name and directory slug.”,“why”:“Without it, session context (agent and directory) is unknown; cannot route or debug.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:48.187886591+00:00”}

overrides 0 0 6 Table
cleanup_log 0 0 8 Table

{“what”:“One row per cleanup run, with timing, trigger, and byte counts.”,“why”:“Needed to audit cleanup activity and track disk-space recovery over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:36.802235434+00:00”}

dir_observed 0 0 9 Table

{“what”:“Snapshot of a directory’s contents on a device at a point in time.”,“why”:“Without it, no record of directory state for historical comparison or drift detection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.112245220+00:00”}

scan_findings 0 0 8 Table

{“what”:“A single issue detected by a scan, with location and metadata.”,“why”:“Without it, scan results would be lost and cannot be tracked or resolved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.761969823+00:00”}

classification_log 0 0 7 Table

{“what”:“Log of each file classification event with category and confidence.”,“why”:“Without it, no audit trail of classification decisions or ability to reprocess.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:32.274134753+00:00”}

symlink_registry 0 0 10 Table

{“what”:“Central registry of symlink entries with source/target paths, categories, and status.”,“why”:“Without it, symlink mappings and their validation state would be unknown, breaking link management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.662701772+00:00”}

tracked_files 0 0 13 Table

{“what”:“A file that was detected and processed; each row is one file.”,“why”:“Without it, there is no record of which files were handled and their outcomes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.868369581+00:00”}

proposal_impacts 0 0 11 Table

{“what”:“One row per proposal, holding the outcome of an automated impact scan.”,“why”:“Without it, there is no record of what a proposal touches, so approval cannot be based on risk.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:38.216823016+00:00”}

repo_descriptions 0 0 6 Table

{“what”:“Per-device repository metadata: description, category, model, and generation time.”,“why”:“Without it, no record of what each device knows about a repo.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:34.489870394+00:00”}

proposals 1 0 17 Table

{“what”:“Code change proposals with analysis and review metadata.”,“why”:“Without it, proposed changes and their review status cannot be tracked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:47.820662566+00:00”}

placement_flags 0 0 11 Table

{“what”:“A proposed category change for an item identified by source_path and device, with confidence and resolution status.”,“why”:“Tracks proposed category moves so they can be reviewed, approved, and applied; without it, proposed changes are unknown and cannot be acted on.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.089123565+00:00”}

dir_schema 0 0 13 Table
execution_log 0 1 6 Table

{“what”:“One row per proposal execution attempt with outcome and rollback data.”,“why”:“Without it, there is no audit trail for proposal executions or data to undo partial changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:58.114868740+00:00”}

deletability_scores 0 0 11 Table

{“what”:“Per-file scores and metadata used to rank files for deletion.”,“why”:“Without it, there is no persistent record of which files are safe to delete and in what order.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.258608116+00:00”}

session_descriptions 0 0 4 Table

{“what”:“One row per session description, linking a session to its summary and agent.”,“why”:“Without it, session summaries and their generating agent are not recorded, losing provenance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:55.509136365+00:00”}