Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“what”:“Unique identifier for this delivery attempt.”,“why”:“Needed as primary key to reference individual attempts reliably.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.636912448+00:00”} |
|||||
| webhook_id | uuid | 2147483647 | null |
|
|
{“what”:“Foreign key to the webhook configuration that this delivery belongs to.”,“why”:“Without it, cannot know which webhook endpoint was targeted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.651204871+00:00”} |
|||||
| event | text | 2147483647 | null |
|
|
{“what”:“Event type that triggered this delivery, e.g. ‘issue.created’.”,“why”:“Needed to correlate delivery with the originating event and filter by event type.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.667008451+00:00”} |
|||||
| payload | jsonb | 2147483647 | null |
|
|
{“what”:“JSON body sent to the webhook endpoint.”,“why”:“Without it, cannot inspect or replay the exact data delivered.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.688794857+00:00”} |
|||||
| status_code | int4 | 10 | √ | null |
|
|
{“what”:“HTTP status code returned by the endpoint, null if no response.”,“why”:“Determines success/failure and retry logic; missing means unknown outcome.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.727026924+00:00”} |
||||
| attempt | int4 | 10 | 1 |
|
|
{“what”:“Current attempt number, starting at 1, incremented on each retry.”,“why”:“Needed to enforce max retry count and track retry progression.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.745026894+00:00”} |
|||||
| next_retry_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Scheduled time for the next retry, null if no retry pending.”,“why”:“Without it, retry scheduler cannot know when to attempt again.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.764159697+00:00”} |
||||
| delivered | bool | 1 | false |
|
|
{“what”:“Whether the delivery was ultimately successful (true) or not.”,“why”:“Provides a quick flag to filter successful deliveries without parsing status codes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.805162507+00:00”} |
|||||
| error_message | text | 2147483647 | √ | null |
|
|
{“what”:“Human-readable error description from the last failed attempt.”,“why”:“Needed for debugging delivery failures; without it, failure reason is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.831631795+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when this delivery attempt record was created.”,“why”:“Enables time-based auditing and ordering of attempts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:06.864319434+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| webhook_deliveries_pkey | Primary key | Asc | id |
| idx_webhook_deliveries_retry | Performance | Asc | next_retry_at |