Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | text | 2147483647 | null |
|
|
{“what”:“Unique identifier for the build, e.g., UUID.”,“why”:“Without it, builds cannot be referenced or linked to other records.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.230469408+00:00”} |
|||||
| repo | text | 2147483647 | null |
|
|
{“what”:“Repository identifier such as ‘owner/name’.”,“why”:“Without it, builds cannot be grouped per repository.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.242329975+00:00”} |
|||||
| profile | text | 2147483647 | null |
|
|
{“what”:“Build profile name, e.g., ‘release’ or ‘debug’.”,“why”:“Without it, different build configurations become indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.263849361+00:00”} |
|||||
| language | text | 2147483647 | null |
|
|
{“what”:“Primary programming language, e.g., ‘Go’.”,“why”:“Without it, language-specific tooling or metrics cannot be applied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.298897457+00:00”} |
|||||
| target | text | 2147483647 | √ | null |
|
|
{“what”:“Target platform or architecture, e.g., ‘linux/amd64’.”,“why”:“Without it, cross-compilation targets are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.321189439+00:00”} |
||||
| device | text | 2147483647 | null |
|
|
{“what”:“Device model the build targets, e.g., ‘rpi4’.”,“why”:“Without it, device-specific builds cannot be filtered.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.339438824+00:00”} |
|||||
| status | text | 2147483647 | 'queued'::text |
|
|
{“what”:“Current state: queued, running, succeeded, failed, etc.”,“why”:“Without it, build progress and failures cannot be tracked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.388633721+00:00”} |
|||||
| backend | text | 2147483647 | √ | null |
|
|
{“what”:“Build backend or CI system, e.g., ‘github-actions’.”,“why”:“Without it, backend-specific error handling is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.399732809+00:00”} |
||||
| backend_build_id | text | 2147483647 | √ | null |
|
|
{“what”:“Identifier of the build in the backend system.”,“why”:“Without it, cannot correlate with backend logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.410900608+00:00”} |
||||
| binary_name | text | 2147483647 | √ | null |
|
|
{“what”:“Name of the produced binary file, e.g., ‘app’.”,“why”:“Without it, artifact identification is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.422092508+00:00”} |
||||
| binary_path | text | 2147483647 | √ | null |
|
|
{“what”:“Path to the binary within the artifact or workspace.”,“why”:“Without it, artifact location is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.445362679+00:00”} |
||||
| binary_hash | text | 2147483647 | √ | null |
|
|
{“what”:“Hash of the binary, e.g., SHA256 hex.”,“why”:“Without it, binary integrity cannot be verified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.485747824+00:00”} |
||||
| artifact_size_bytes | int8 | 19 | √ | null |
|
|
{“what”:“Size of the artifact in bytes.”,“why”:“Without it, storage costs and download sizes are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.503379905+00:00”} |
||||
| version | text | 2147483647 | √ | null |
|
|
{“what”:“Version string of the build, e.g., ‘1.2.3’.”,“why”:“Without it, release versioning is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.531993069+00:00”} |
||||
| error | text | 2147483647 | √ | null |
|
|
{“what”:“Error message if the build failed.”,“why”:“Without it, failure cause is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.546797532+00:00”} |
||||
| started_at | text | 2147483647 | √ | null |
|
|
{“what”:“Timestamp when build started, ISO 8601.”,“why”:“Without it, build duration cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.611570855+00:00”} |
||||
| finished_at | text | 2147483647 | √ | null |
|
|
{“what”:“Timestamp when build finished, ISO 8601.”,“why”:“Without it, completion time is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.649015710+00:00”} |
||||
| duration_secs | float8 | 17,17 | √ | null |
|
|
{“what”:“Build duration in seconds.”,“why”:“Without it, performance trends cannot be analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.691765301+00:00”} |
||||
| created_at | text | 2147483647 | (now())::text |
|
|
{“what”:“Timestamp when build record was created, ISO 8601.”,“why”:“Without it, record ordering is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.703628501+00:00”} |
|||||
| failed_step | text | 2147483647 | √ | null |
|
|
{“what”:“Name of the build step that failed, e.g., ‘compile’.”,“why”:“Without it, failure point is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.726179900+00:00”} |
||||
| failed_reason | text | 2147483647 | √ | null |
|
|
{“what”:“Reason for failure, e.g., ‘timeout’.”,“why”:“Without it, failure cause is not actionable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.773822631+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| builds_pkey | Primary key | Asc | id |
| idx_builds_created | Performance | Asc | created_at |
| idx_builds_device | Performance | Asc | device |
| idx_builds_repo | Performance | Asc | repo |
| idx_builds_status | Performance | Asc | status |