assignment_events


Description

{“what”:“Log of assignment status transitions, including failed attempts.”,“why”:“Without it, there is no audit trail to reconstruct assignment status history or diagnose failed transitions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.208444657+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('assignment_events_id_seq'::regclass)

{“what”:“Unique numeric identifier for the event; auto-generated sequence.”,“why”:“Without it, events cannot be uniquely identified or referenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.228591064+00:00”}

assignment_id int8 19 null
assignments.id assignment_events_assignment_id_fkey C

{“what”:“Identifier of the assignment this event belongs to.”,“why”:“Without it, it is unknown which assignment the event refers to, making the log useless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.250393896+00:00”}

from_status text 2147483647 √ null

{“what”:“Status value the assignment was in before the transition; null when no prior status.”,“why”:“Without it, the starting point of the transition is unknown, so the change cannot be reconstructed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.269128990+00:00”}

to_status text 2147483647 √ null

{“what”:“Status value the assignment moved to; null if no new status was set.”,“why”:“Without it, the outcome of the transition is unknown, so the final state cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.297198035+00:00”}

detail text 2147483647 √ null

{“what”:“Free-form text with extra context about the event, such as reason or message.”,“why”:“Without it, context beyond status change is lost, making debugging and auditing incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.327447333+00:00”}

error text 2147483647 √ null

{“what”:“Error message if the transition failed; null on success.”,“why”:“Without it, failed transitions are indistinguishable from successful ones, hiding problems.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.445040845+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone of when the event was logged.”,“why”:“Without it, the order and timing of events is unknown, breaking chronological analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:10.500236624+00:00”}

Indexes

Constraint Name Type Sort Column(s)
assignment_events_pkey Primary key Asc id
idx_assignment_events_assignment Performance Asc/Desc assignment_id + created_at

Relationships