deployments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null

{“what”:“Unique identifier for this deployment record.”,“why”:“Without it, there is no stable key to reference a deployment for status updates or cancellation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:21.663265827+00:00”}

build_id text 2147483647 null

{“what”:“Identifier of the build that produced the binary.”,“why”:“Without it, you cannot trace which source code version or CI job generated the deployed binary.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:21.695098278+00:00”}

repo text 2147483647 null

{“what”:“Source repository name (e.g., ‘org/repo’) for the build.”,“why”:“Without it, you cannot know which codebase the binary came from for debugging or rollback.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:21.733926986+00:00”}

device text 2147483647 null

{“what”:“Target device identifier (e.g., serial or hostname) for the deployment.”,“why”:“Without it, you cannot know which device received the binary or target it for retries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:21.797741403+00:00”}

target_triple text 2147483647 null

{“what”:“Target platform triple (e.g., ‘x86_64-unknown-linux-gnu’) for the binary.”,“why”:“Without it, you cannot verify the binary matches the device architecture or OS.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:21.920460451+00:00”}

binary_name text 2147483647 null
_migrations.name Implied Constraint R

{“what”:“Name of the deployed binary file (e.g., ‘myapp’).”,“why”:“Without it, you cannot identify which executable was deployed or construct its path.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:21.957189184+00:00”}

binary_hash text 2147483647 √ null

{“what”:“Content hash of the binary, used to verify integrity.”,“why”:“Without it, you cannot detect corrupted or tampered binaries after deployment.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:21.972595854+00:00”}

binary_path text 2147483647 √ null

{“what”:“Filesystem path where the binary was placed on the device.”,“why”:“Without it, you cannot locate the binary on the device for updates or removal.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:21.996568019+00:00”}

status text 2147483647 'pending'::text

{“what”:“Deployment lifecycle state, defaulting to ‘pending’.”,“why”:“Without it, you cannot know if a deployment is in progress, succeeded, or failed, or filter on it.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:22.030472233+00:00”}

stale_pids_killed int4 10 √ 0

{“what”:“Number of stale process IDs killed before deployment.”,“why”:“Without it, you cannot know if old processes were cleaned up, which affects rollback decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:22.069517306+00:00”}

codesigned int4 10 √ 0

{“what”:“Flag (0 or 1) indicating whether the binary was code-signed.”,“why”:“Without it, you cannot know if the binary passed signing checks, which may be required for execution.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:22.100355978+00:00”}

error text 2147483647 √ null

{“what”:“Error message from a failed deployment, if any.”,“why”:“Without it, you cannot diagnose why a deployment failed or report it to users.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:22.112084950+00:00”}

started_at text 2147483647 √ null

{“what”:“Timestamp (text) when the deployment started.”,“why”:“Without it, you cannot measure deployment duration or detect stuck deployments.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:22.127519019+00:00”}

finished_at text 2147483647 √ null

{“what”:“Timestamp (text) when the deployment finished.”,“why”:“Without it, you cannot compute duration or know if a deployment is still running.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:22.141954819+00:00”}

created_at text 2147483647 (now())::text

{“what”:“Creation timestamp of this record, set to now() by default.”,“why”:“Without it, you cannot order deployments by creation time or audit when they were initiated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:22.154630631+00:00”}

Indexes

Constraint Name Type Sort Column(s)
deployments_pkey Primary key Asc id
idx_deployments_build Performance Asc build_id
idx_deployments_device Performance Asc device

Relationships