classification_log


Description

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

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

Relationships