execution_log


Description

{“what”:“One row per proposal execution attempt with outcome and rollback data.”,“why”:“Without it, there is no audit trail for proposal executions or data to undo partial changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:58.114868740+00:00”}

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
proposals.id execution_log_proposal_id_fkey R

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

Relationships