notification_subscription

{“what”:“Unique integer identifier for the subscription row.”,“why”:“Needed as primary key for stable references and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:41.703000477+00:00”}

{“what”:“Foreign key to the notification being subscribed to.”,“why”:“Identifies which notification this subscription applies to; without it the subscription is meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:41.718206272+00:00”}

{“what”:“Subscription kind, e.g. ‘cron’ or ‘event’, selecting the schedule field.”,“why”:“Determines whether cron_schedule or event_name is used; without it the subscription’s trigger is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:41.732411839+00:00”}

{“what”:“Name of the event that triggers this subscription when type is ‘event’.”,“why”:“Without it, event-based subscriptions have no trigger condition.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:41.793249888+00:00”}

{“what”:“Timestamp when the subscription was created, in UTC.”,“why”:“Enables audit and ordering of subscriptions; without it we cannot know when it was set up.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:41.814438691+00:00”}

{“what”:“Cron expression defining the recurring schedule when type is ‘cron’.”,“why”:“Without it, cron-based subscriptions have no schedule to execute on.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:41.925628509+00:00”}

{“what”:“UI presentation hint for the subscription, e.g. ‘banner’ or ‘email’.”,“why”:“Without it, the frontend cannot decide how to render the subscription’s notifications.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:41.947334262+00:00”}