webhook_deliveries


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
webhooks.id webhook_deliveries_webhook_id_fkey C

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

Relationships