Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |