Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each notification-card row.”,“why”:“Needed to reference a specific notification configuration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.683860273+00:00”} |
||||
| card_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the card this notification configuration applies to.”,“why”:“Without it, a configuration cannot be linked to its card.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.720543597+00:00”} |
||||
| send_once | bool | 1 | false |
|
|
{“what”:“Flag indicating the notification is sent only once per card.”,“why”:“Prevents duplicate notifications when the condition repeats.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.778226849+00:00”} |
|||||
| send_condition | varchar | 32 | null |
|
|
{“what”:“Expression or rule that must be true to trigger the notification.”,“why”:“Without it, there is no defined moment to send the notification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.794463846+00:00”} |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when this configuration row was created.”,“why”:“Tracks when the notification rule was added.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.815287021+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last modification to this configuration.”,“why”:“Shows how recently the rule was changed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.829477295+00:00”} |
|||||
| disable_links | bool | 1 | √ | false |
|
|
{“what”:“Flag that disables clickable links in the notification content.”,“why”:“Without it, links would always be active, risking unintended navigation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.840126753+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| notification_card_pkey | Primary key | Asc | id |
| idx_notification_card_card_id | Performance | Asc | card_id |