Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
{“what”:“Unique numeric identifier for each log entry.”,“why”:“Without it, entries cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:32.392673912+00:00”} |
|
| path | text | 2147483647 | null |
|
|
{“what”:“Filesystem path of the classified file.”,“why”:“Without it, cannot know which file was classified or group by path.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:32.433910720+00:00”} |
||
| device | text | 2147483647 | null |
|
|
{“what”:“Device identifier where the file resides.”,“why”:“Without it, same path on different devices becomes ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:32.476463560+00:00”} |
||
| primary_category | text | 2147483647 | null |
|
|
{“what”:“Assigned category label for the file.”,“why”:“Without it, classification result is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:32.674224479+00:00”} |
||
| confidence | float8 | 17,17 | null |
|
|
{“what”:“Confidence score between 0 and 1 for the category.”,“why”:“Without it, cannot filter low-confidence classifications or assess reliability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:32.826661369+00:00”} |
||
| symlinks_created | int4 | 10 | 0 |
|
|
{“what”:“Number of symlinks created during classification.”,“why”:“Without it, cannot track side effects or cleanup needs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:33.660677099+00:00”} |
||
| classified_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp when classification occurred.”,“why”:“Without it, cannot order events or audit time-based changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:33.696776805+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| classification_log_pkey | Primary key | Asc | id |
| idx_classlog_path | Performance | Asc/Asc | path + device |