notification_card


Description

{“what”:“Settings controlling when and how a notification is sent for a card.”,“why”:“Without it, card notifications would have no defined trigger or delivery rules.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.642770607+00:00”}

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
report_card.id fk_notification_card_card_id C

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

Relationships