builds


Description

{“what”:“A build attempt: one row per execution of a build pipeline.”,“why”:“Without it, there is no trace of build history or artifact provenance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:38.189428199+00:00”}

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
_migrations.name Implied Constraint R

{“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

Relationships