Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('build_audit_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each audit row.”,“why”:“Without it, rows cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.100679182+00:00”} |
|
| build_id | text | 2147483647 | null |
|
|
{“what”:“Identifier of the build this step belongs to, e.g. a UUID or CI job ID.”,“why”:“Without it, steps cannot be grouped into a single build’s timeline.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.198883564+00:00”} |
||
| deploy_id | text | 2147483647 | √ | null |
|
|
{“what”:“Identifier of the deployment triggered by this build, if any.”,“why”:“Without it, linking a build to its deployment is impossible when present.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.232396625+00:00”} |
|
| device | text | 2147483647 | √ | null |
|
|
{“what”:“Target device or platform the build ran on, e.g. ‘ios’ or ‘android’.”,“why”:“Without it, build behavior across devices cannot be compared.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.311074413+00:00”} |
|
| step | text | 2147483647 | null |
|
|
{“what”:“Step label such as ‘compile’, ‘test’, or ‘upload’.”,“why”:“Without it, the sequence of actions in a build is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.340805741+00:00”} |
||
| started_at | text | 2147483647 | null |
|
|
{“what”:“ISO 8601 timestamp when the step started.”,“why”:“Without it, step duration and ordering cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.354152978+00:00”} |
||
| finished_at | text | 2147483647 | √ | null |
|
|
{“what”:“ISO 8601 timestamp when the step finished, null if still running.”,“why”:“Without it, step completion and duration are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.409306963+00:00”} |
|
| status | text | 2147483647 | null |
|
|
{“what”:“Outcome of the step, e.g. ‘success’, ‘failure’, ‘running’.”,“why”:“Without it, build health and failure points cannot be identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.487833214+00:00”} |
||
| request_json | text | 2147483647 | √ | null |
|
|
{“what”:“JSON payload of the request sent for this step, if any.”,“why”:“Without it, the exact input to the step is lost for replay or debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.512686261+00:00”} |
|
| response_json | text | 2147483647 | √ | null |
|
|
{“what”:“JSON payload of the response received from the step, if any.”,“why”:“Without it, the step’s output cannot be verified or audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.579485621+00:00”} |
|
| metadata_json | text | 2147483647 | √ | null |
|
|
{“what”:“Arbitrary JSON metadata attached to the step, e.g. environment variables.”,“why”:“Without it, contextual details that may explain step behavior are missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:02.622818930+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| build_audit_pkey | Primary key | Asc | id |
| idx_audit_build | Performance | Asc | build_id |
| idx_audit_step | Performance | Asc | step |