build_files


Description

{“what”:“One row per file discovered in a build, with content hash and scan metadata.”,“why”:“Without it, you cannot know which files were present in a build or verify their integrity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.035712972+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('build_files_id_seq'::regclass)

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

build_id text 2147483647 null

{“what”:“Build identifier (e.g., CI run ID) that groups files from one build.”,“why”:“Without it, files from different builds would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.086323156+00:00”}

file_path text 2147483647 null

{“what”:“Absolute or relative path within the build.”,“why”:“Without it, you cannot locate the file or compare paths across builds.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.099778780+00:00”}

file_hash text 2147483647 null

{“what”:“Hash of file contents (e.g., SHA-256) used for integrity checks.”,“why”:“Without it, you cannot detect content changes or duplicates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.112745575+00:00”}

language text 2147483647 null

{“what”:“Programming language such as Python or Go.”,“why”:“Without it, you cannot filter files by language for analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.127461379+00:00”}

size_bytes int8 19 0

{“what”:“Numeric size of the file in bytes; zero if unknown.”,“why”:“Without it, you cannot estimate storage or detect empty files.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.141244381+00:00”}

source_device text 2147483647 null

{“what”:“Device or hostname where the file was scanned.”,“why”:“Without it, you cannot trace which machine produced the file.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.154385937+00:00”}

scanned_at text 2147483647 (now())::text

{“what”:“Timestamp of scan, stored as text in ISO format.”,“why”:“Without it, you cannot know when the file was collected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:16.179394153+00:00”}

Indexes

Constraint Name Type Sort Column(s)
build_files_pkey Primary key Asc id
idx_build_files_build Performance Asc build_id
idx_build_files_path Performance Asc file_path

Relationships