notification


Description

{“what”:“A notification record with type, state, and audit timestamps.”,“why”:“Centralizes notification data so it can be queried, filtered, and managed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:26.526668295+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
notification_handler.notification_id fk_notification_handler_notification_id C
notification_subscription.notification_id fk_notification_subscription_notification_id C

{“what”:“Unique numeric identifier for each notification row.”,“why”:“Enables referencing a notification from other tables and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:26.665193154+00:00”}

payload_type varchar 64 null

{“what”:“String naming the notification kind, e.g. email or push.”,“why”:“Determines how the notification is rendered and routed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:26.693060158+00:00”}

active bool 1 true

{“what”:“Flag indicating whether the notification is currently enabled.”,“why”:“Allows disabling a notification without deleting it.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:26.909669668+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp when the notification row was inserted.”,“why”:“Provides audit trail and ordering of notifications.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:26.935780333+00:00”}

updated_at timestamptz 35,6 null

{“what”:“Timestamp of the last update to this row.”,“why”:“Shows when the notification was last modified, useful for sync.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:27.036164521+00:00”}

internal_id varchar 254 √ null
core_session.id Implied Constraint R

{“what”:“Optional external system identifier for the notification.”,“why”:“Maps to an external reference when the notification originates elsewhere.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:27.051467569+00:00”}

payload_id int4 10 √ null

{“what”:“Foreign key to a payload table holding notification content.”,“why”:“Links to the specific data used to generate the notification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:27.073616831+00:00”}

creator_id int4 10 √ null
core_user.id fk_notification_creator_id C

{“what”:“User ID of the account that created the notification.”,“why”:“Tracks ownership and allows filtering by creator.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:27.089784976+00:00”}

Indexes

Constraint Name Type Sort Column(s)
notification_pkey Primary key Asc id
idx_notification_creator_id Performance Asc creator_id
notification_internal_id_key Must be unique Asc internal_id

Relationships