Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“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 |