tracked_files


Description

{“what”:“A file that was detected and processed; each row is one file.”,“why”:“Without it, there is no record of which files were handled and their outcomes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.868369581+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null

{“what”:“Unique numeric identifier for each tracked file.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.884686276+00:00”}

session_uuid text 2147483647 null

{“what”:“UUID of the session that discovered the file.”,“why”:“Without it, files from different runs cannot be separated or grouped.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.905657323+00:00”}

agent_name text 2147483647 √ null

{“what”:“Name of the agent that processed the file, if any.”,“why”:“Without it, it’s unknown which agent handled the file, making attribution impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.917602333+00:00”}

source_path text 2147483647 null

{“what”:“Original file path on the source system.”,“why”:“Without it, the origin of the file is unknown, so mirroring or cleaning cannot be traced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.931123264+00:00”}

mirror_path text 2147483647 null

{“what”:“Path where the file was mirrored or copied to.”,“why”:“Without it, the mirrored location is unknown, so retrieval or verification fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.945335292+00:00”}

archive_path text 2147483647 null

{“what”:“Path where the file is stored in the archive.”,“why”:“Without it, the archived copy cannot be located for restoration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.958251574+00:00”}

content_hash text 2147483647 null

{“what”:“Hash of file content, e.g., SHA-256.”,“why”:“Without it, duplicate detection or integrity verification is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.971305369+00:00”}

size_bytes int8 19 null

{“what”:“File size in bytes.”,“why”:“Without it, storage usage and transfer progress cannot be estimated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:57.986140381+00:00”}

detected_by text 2147483647 null

{“what”:“Method or rule that detected the file.”,“why”:“Without it, the detection source is unknown, so false positives cannot be traced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:58.025434616+00:00”}

tool_name text 2147483647 √ null

{“what”:“Name of the tool that processed the file.”,“why”:“Without it, the processing tool is unknown, making debugging or auditing difficult.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:58.039667908+00:00”}

bash_command text 2147483647 √ null

{“what”:“Shell command used to process the file.”,“why”:“Without it, the exact operation performed cannot be reproduced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:58.062776957+00:00”}

mirrored_at timestamptz 35,6 now()

{“what”:“Timestamp when the file was mirrored, in UTC.”,“why”:“Without it, the mirroring time is unknown, so freshness or scheduling cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:58.084445018+00:00”}

cleaned_at timestamptz 35,6 √ null

{“what”:“Timestamp when the file was cleaned, if cleaned.”,“why”:“Without it, it’s unknown whether and when cleanup occurred, leaving retention ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:58.110191820+00:00”}

Indexes

Constraint Name Type Sort Column(s)
tracked_files_pkey Primary key Asc id
idx_tf_session Performance Asc session_uuid
idx_tf_source Performance Asc source_path
tracked_files_session_uuid_source_path_content_hash_key Must be unique Asc/Asc/Asc session_uuid + source_path + content_hash

Relationships