Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“UUID that uniquely identifies this history row.”,“why”:“Without it, duplicate or ambiguous history entries cannot be distinguished.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.130911887+00:00”} |
|||||
| job_id | uuid | 2147483647 | null |
|
|
{“what”:“UUID of the compaction job that produced this history entry.”,“why”:“Without it, cannot associate history with the originating job or filter by job.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.144629563+00:00”} |
|||||
| input_snapshot | jsonb | 2147483647 | null |
|
|
{“what”:“JSON document capturing the pre-compaction state of the affected data.”,“why”:“Without it, cannot compare before/after or roll back to previous state.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.155524617+00:00”} |
|||||
| output_snapshot | jsonb | 2147483647 | null |
|
|
{“what”:“JSON document capturing the post-compaction state of the affected data.”,“why”:“Without it, cannot verify compaction result or audit changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.170582260+00:00”} |
|||||
| pinned_content | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON document listing content explicitly kept unchanged during compaction.”,“why”:“Without it, cannot know which items were protected from compaction or reproduce the same pinning.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.181216665+00:00”} |
||||
| outcome | text | 2147483647 | √ | null |
|
|
{“what”:“Text describing the result of the compaction, such as success or failure reason.”,“why”:“Without it, cannot tell if compaction succeeded or failed, or diagnose errors.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.213712484+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp of when the compaction history entry was recorded.”,“why”:“Without it, cannot order events or know when compaction occurred.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.223910358+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| compaction_history_pkey | Primary key | Asc | id |
| idx_history_job | Performance | Asc | job_id |