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 |