Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer assigned to each row; primary key.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:00.915593784+00:00”} |
||||
| notification_handler_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the notification handler this recipient belongs to.”,“why”:“Without it, the handler context is missing, making it impossible to know which notification configuration this recipient applies to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:00.934621441+00:00”} |
|||||
| type | varchar | 64 | null |
|
|
{“what”:“Recipient kind: ‘user’ or ‘permissions_group’.”,“why”:“Without it, it is ambiguous whether user_id or permissions_group_id is the actual recipient.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:00.963518797+00:00”} |
|||||
| user_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the user recipient when type is ‘user’.”,“why”:“Without it, the specific user for a user-type recipient is unknown, breaking per-user delivery.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:00.977448801+00:00”} |
||||
| permissions_group_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the permission group recipient when type is ‘permissions_group’.”,“why”:“Without it, group-based recipients cannot be resolved, so notifications to groups are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:00.997000050+00:00”} |
||||
| details | text | 2147483647 | √ | null |
|
|
{“what”:“Additional recipient-specific configuration or metadata as free text.”,“why”:“Without it, any extra per-recipient settings are unavailable, limiting customization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:01.012887832+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the recipient link was created.”,“why”:“Without it, audit history of when recipients were added is missing, complicating debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:01.034029866+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last update to the recipient link.”,“why”:“Without it, it is unknown when the recipient configuration last changed, hindering change tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:01.048377848+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| notification_recipient_pkey | Primary key | Asc | id |
| idx_notification_recipient_notification_handler_id | Performance | Asc | notification_handler_id |
| idx_notification_recipient_permissions_group_id | Performance | Asc | permissions_group_id |
| idx_notification_recipient_user_id | Performance | Asc | user_id |