Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| slug | text | 2147483647 | null |
|
|
{“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 |
|
|
{“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 |