Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| file_id | int8 | 19 | null |
|
|
{“what”:“Identifier of the scored file; matches the file’s primary key.”,“why”:“Without it, scores cannot be linked back to the actual file to act on.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.286660937+00:00”} |
||
| device | text | 2147483647 | null |
|
|
{“what”:“Name or identifier of the device or volume containing the file.”,“why”:“Without it, scores from different devices are indistinguishable and deletion actions cannot target the right storage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.298825854+00:00”} |
||
| file_path | text | 2147483647 | null |
|
|
{“what”:“Absolute path of the file on the device, including directories.”,“why”:“Without it, the file cannot be located for deletion or inspection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.317790840+00:00”} |
||
| file_name | text | 2147483647 | null |
|
|
{“what”:“Base name of the file, without directory components.”,“why”:“Without it, display and filtering by filename is impossible; path alone is unwieldy.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.382598979+00:00”} |
||
| size_bytes | int8 | 19 | null |
|
|
{“what”:“File size in bytes, as reported by the filesystem.”,“why”:“Without it, deletion impact (freed space) cannot be estimated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.409395626+00:00”} |
||
| content_type | text | 2147483647 | null |
|
|
{“what”:“MIME type or file extension category, e.g. ‘image/png’.”,“why”:“Without it, deletion policies cannot exclude or prioritize by file type.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.547493608+00:00”} |
||
| score | float8 | 17,17 | null |
|
|
{“what”:“Computed deletability score; higher means more likely to be deleted.”,“why”:“Without it, there is no ranking to decide which files to delete first.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.560061414+00:00”} |
||
| cleanup_priority | float8 | 17,17 | null |
|
|
{“what”:“Numeric priority for cleanup order; lower values are deleted earlier.”,“why”:“Without it, the order of deletion within same score is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.594689686+00:00”} |
||
| category | text | 2147483647 | null |
|
|
{“what”:“Bucket such as ‘temp’, ‘cache’, ‘user’ that groups files by purpose.”,“why”:“Without it, deletion rules cannot be applied per category.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.660641919+00:00”} |
||
| signals | text | 2147483647 | '[]'::text |
|
|
{“what”:“JSON array of signal names that contributed to the score, e.g. ‘"old","large"’.”,“why”:“Without it, the reason behind a score is opaque and cannot be audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.671057438+00:00”} |
||
| scored_at | text | 2147483647 | null |
|
|
{“what”:“Timestamp when the score was computed, in ISO 8601 format.”,“why”:“Without it, stale scores cannot be detected and refreshed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:11.684146048+00:00”} |