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