notification_recipient


Description

{“what”:“Links a notification handler to a recipient (user or permission group) for delivery.”,“why”:“Without it, which users or groups receive a handler’s notifications is undefined, breaking delivery routing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:00.903036129+00:00”}

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
notification_handler.id fk_notification_recipient_notification_handler_id C

{“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
core_user.id fk_notification_recipient_user_id C

{“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
permissions_group.id fk_notification_recipient_permissions_group_id C

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

Relationships