event_card_templates


Description

{“what”:“Templates defining event card content, trigger signals, and display order.”,“why”:“Without it, no event card definitions exist to render or trigger.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.010829197+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
slug text 2147483647 null
event_cards.template_slug event_cards_template_slug_fkey R

{“what”:“Unique text identifier for the template; the primary key.”,“why”:“Without it, templates cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.032011543+00:00”}

category_slug text 2147483647 null
card_categories.slug event_card_templates_category_slug_fkey R

{“what”:“Slug of the category this template belongs to.”,“why”:“Without it, category-based grouping or filtering is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.046238203+00:00”}

name text 2147483647 null

{“what”:“Human-readable display name for the template.”,“why”:“Without it, users cannot identify the template in lists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.058768795+00:00”}

narrative text 2147483647 null

{“what”:“Text describing the event scenario shown on the card.”,“why”:“Without it, the card has no descriptive content to display.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.094870859+00:00”}

action_hint text 2147483647 √ null

{“what”:“Optional text suggesting a user action for the event.”,“why”:“Without it, the card lacks an actionable prompt.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.109199890+00:00”}

required_signals text 2147483647 null

{“what”:“Signal identifiers that must be present for the card to appear.”,“why”:“Without it, the trigger condition for the card is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.161568311+00:00”}

min_signals int4 10 2

{“what”:“Minimum count of required signals that must be met.”,“why”:“Without it, the trigger threshold is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.178445351+00:00”}

time_window_days int4 10 90

{“what”:“Number of days over which signals are considered.”,“why”:“Without it, the observation period for signals is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.195514095+00:00”}

sort_order int4 10 0

{“what”:“Integer used to order templates in display.”,“why”:“Without it, the display order of templates is arbitrary.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.215766377+00:00”}

Indexes

Constraint Name Type Sort Column(s)
event_card_templates_pkey Primary key Asc slug

Relationships