Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| slug | text | 2147483647 | null |
|
|
{“what”:“Unique short text identifier for the signal type, the primary key.”,“why”:“Without it, there is no unique key to reference signal types, making joins and updates ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:28.675443257+00:00”} |
|||||
| category | text | 2147483647 | null |
|
|
{“what”:“High-level grouping for the signal type, used to classify signals.”,“why”:“Without it, signal types cannot be grouped or filtered by category, hindering analysis and reporting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:28.691491489+00:00”} |
|||||
| name | text | 2147483647 | null |
|
|
{“what”:“Human-readable display name for the signal type, used in user interfaces.”,“why”:“Without it, users would see only the slug, which may be cryptic; the name provides a clear label for display.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:28.709409130+00:00”} |
|||||
| description | text | 2147483647 | null |
|
|
{“what”:“Detailed explanation of the signal type’s meaning and usage.”,“why”:“Without it, the meaning and intended use of the signal type are ambiguous, risking incorrect usage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:28.726742139+00:00”} |
|||||
| data_source | text | 2147483647 | √ | null |
|
|
{“what”:“Optional origin or source of the signal data, such as a sensor or external system.”,“why”:“Without it, the provenance of signal data is unknown, complicating trust and debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:28.741568380+00:00”} |
||||
| sort_order | int4 | 10 | 0 |
|
|
{“what”:“Numeric ordering for display, lower values appear first.”,“why”:“Without it, the display order of signal types is arbitrary, leading to inconsistent user interfaces.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:28.757300500+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| signal_types_pkey | Primary key | Asc | slug |