channel_template


Description

{“what”:“A named template that defines a channel’s type and optional details.”,“why”:“Without it, each channel would need its own ad-hoc configuration, risking inconsistent channel types and details.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:50.318934164+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
notification_handler.template_id fk_notification_handler_template_id N

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

Relationships