placement_flags

{“what”:“Unique numeric ID for this flag; primary key.”,“why”:“Without it, rows cannot be uniquely referenced for updates or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.119872641+00:00”}

{“what”:“Full path of the item being flagged, e.g., /data/file.txt.”,“why”:“Identifies which item the flag applies to; without it, the flag cannot be associated with a specific file or object.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.132758038+00:00”}

{“what”:“Device or host name where the source_path resides.”,“why”:“Disambiguates items with the same path on different devices; without it, the source is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.149386866+00:00”}

{“what”:“Category the item currently belongs to, e.g., ‘documents’.”,“why”:“Provides the baseline for the proposed change; without it, the change cannot be evaluated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.160762240+00:00”}

{“what”:“Category the item is proposed to move to.”,“why”:“Defines the target category; without it, the intended change is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.170270929+00:00”}

{“what”:“Full path or location where the item would be moved to.”,“why”:“Specifies the concrete move target; without it, the move cannot be executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.182839400+00:00”}

{“what”:“Probability (0-1) that the proposed category is correct.”,“why”:“Used to prioritize or filter flags; without it, all flags are equally weighted and low-confidence moves cannot be identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.194035777+00:00”}

{“what”:“Free-text explanation for the proposed change, empty if none.”,“why”:“Provides context for reviewers; without it, the rationale for the flag is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.209738604+00:00”}

{“what”:“Workflow state, e.g., ‘pending’, ‘approved’, ‘rejected’.”,“why”:“Tracks whether the flag is awaiting action or resolved; without it, unresolved flags cannot be distinguished from processed ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.221782701+00:00”}

{“what”:“Timestamp with time zone when the flag was created.”,“why”:“Records when the proposal was made; without it, the age of flags cannot be determined for prioritization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.245266285+00:00”}

{“what”:“Timestamp with time zone when the flag was resolved, null if pending.”,“why”:“Indicates when the flag was processed; without it, resolution time and pending duration are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:13.265140158+00:00”}