Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“what”:“UUID v4 identifier, unique per webhook.”,“why”:“Without it, webhook rows cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:11.879546826+00:00”} |
|||||
| url | text | 2147483647 | null |
|
|
{“what”:“Destination URL that receives the HTTP POST payload.”,“why”:“Without it, the system does not know where to deliver the event notification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:11.935098208+00:00”} |
|||||
| secret | text | 2147483647 | √ | null |
|
|
{“what”:“HMAC signing key used to authenticate the webhook request.”,“why”:“Without it, receivers cannot verify the request actually came from this system.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:11.958412259+00:00”} |
||||
| events | _text | 2147483647 | '{assessment.completed}'::text[] |
|
|
{“what”:“Array of event type strings that trigger this webhook.”,“why”:“Without it, the system would not know which events to forward to this endpoint.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:11.981422515+00:00”} |
|||||
| enabled | bool | 1 | true |
|
|
{“what”:“Whether this webhook is active and will receive events.”,“why”:“Without it, a webhook cannot be temporarily suspended without losing its configuration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:12.009794461+00:00”} |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone of when the webhook was registered.”,“why”:“Without it, audit and debugging of webhook lifecycle is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:12.098444613+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| webhooks_pkey | Primary key | Asc | id |