channel


Description

{“what”:“A record that defines a named channel with a type and configuration details.”,“why”:“Without it, channel definitions and their active state cannot be persisted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.517980644+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
notification_handler.channel_id fk_notification_handler_channel_id C
pulse_channel.channel_id fk_pulse_channel_channel_id C

{“what”:“Integer primary key; unique identifier for each channel row.”,“why”:“Without it, channels cannot be uniquely referenced by foreign keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.539855065+00:00”}

name varchar 254 null

{“what”:“Short name for the channel; the primary label.”,“why”:“Without it, there is no human-friendly way to refer to the channel.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.552563578+00:00”}

description text 2147483647 √ null

{“what”:“Free-form text describing the channel’s purpose or usage.”,“why”:“Without it, the channel’s intended use is undocumented.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.565894508+00:00”}

type varchar 32 null

{“what”:“Channel type string; defines the kind of channel and how details are parsed.”,“why”:“Without it, the format of details is ambiguous and cannot be processed correctly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.578468635+00:00”}

details text 2147483647 null

{“what”:“Configuration payload for the channel; format depends on type.”,“why”:“Without it, the channel cannot be connected or used for delivery.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.595498910+00:00”}

active bool 1 true

{“what”:“Flag indicating whether the channel is currently enabled for use.”,“why”:“Without it, disabled channels would still be used, causing errors or unintended sends.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.606700717+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp when the channel record was created.”,“why”:“Without it, audit history and ordering of channel creation is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.621535450+00:00”}

updated_at timestamptz 35,6 null

{“what”:“Timestamp of the last update to the channel record.”,“why”:“Without it, it is unknown when the channel configuration was last changed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.635580229+00:00”}

Indexes

Constraint Name Type Sort Column(s)
channel_pkey Primary key Asc id
channel_name_key Must be unique Asc name

Relationships