Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
{“what”:“Surrogate primary key; unique identifier for each log entry.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:58.130489455+00:00”} |
||||
| proposal_id | int8 | 19 | null |
|
|
{“what”:“Identifier of the proposal that this execution belongs to.”,“why”:“Without it, executions cannot be linked to their originating proposal.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:58.161047348+00:00”} |
|||||
| executed_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with time zone) when the execution was attempted; defaults to current time.”,“why”:“Without it, the order and timing of executions is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:58.181243511+00:00”} |
|||||
| success | bool | 1 | null |
|
|
{“what”:“Boolean flag indicating whether the execution completed successfully (true) or failed (false).”,“why”:“Without it, failed executions cannot be distinguished from successful ones for alerting or retry.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:58.208090254+00:00”} |
|||||
| error_message | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text error message from the execution failure; null when success is true.”,“why”:“Without it, the cause of a failure is unavailable for debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:58.224416114+00:00”} |
||||
| rollback_data | text | 2147483647 | √ | null |
|
|
{“what”:“Serialized data needed to undo the execution’s changes; null when no rollback is possible.”,“why”:“Without it, partial changes cannot be reverted after a failure.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:58.256611098+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| execution_log_pkey | Primary key | Asc | id |