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”} |