signal_types


Columns

Column Type Size Nulls Auto Default Children Parents Comments
slug text 2147483647 null
signals.signal_type_slug signals_signal_type_slug_fkey R

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

Relationships