Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each template.”,“why”:“Without it, templates cannot be referenced reliably by other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:50.375478803+00:00”} |
||||
| name | varchar | 64 | null |
|
|
{“what”:“Human-readable name for the template.”,“why”:“Without it, templates cannot be identified in user interfaces or logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:50.408507376+00:00”} |
|||||
| channel_type | varchar | 64 | null |
|
|
{“what”:“Type of channel this template applies to, e.g., ‘email’ or ‘slack’.”,“why”:“Without it, the template cannot be matched to a specific channel type, making it ambiguous which channels it configures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:50.427727124+00:00”} |
|||||
| details | text | 2147483647 | √ | null |
|
|
{“what”:“Optional free-form text with type-specific configuration details.”,“why”:“Without it, type-specific settings would be lost, forcing hardcoded defaults.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:50.449337175+00:00”} |
||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp with time zone when the template was created.”,“why”:“Without it, audit trails and ordering of template changes are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:50.502064021+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp with time zone when the template was last modified.”,“why”:“Without it, you cannot detect stale templates or track recent changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:50.524572176+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| channel_template_pkey | Primary key | Asc | id |