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