Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('webhook_events_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each webhook event.”,“why”:“Without it, events cannot be uniquely identified, breaking deduplication and retry logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:03.037730101+00:00”} |
|
| event | text | 2147483647 | √ | null |
|
|
{“what”:“Event type string sent by the webhook provider.”,“why”:“Without it, the purpose of the payload is ambiguous, preventing correct routing to handlers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:03.058470171+00:00”} |
|
| payload | jsonb | 2147483647 | √ | null |
|
|
{“what”:“Full JSON body of the webhook request, preserving all fields.”,“why”:“Without it, the event details are lost, making it impossible to process or replay the event.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:03.077623526+00:00”} |
|
| received_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Arrival time of the webhook request, with time zone.”,“why”:“Without it, the order and timing of events is unknown, breaking time-based analysis and rate limiting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:03.101772650+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| webhook_events_pkey | Primary key | Asc | id |