Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for the segment.”,“why”:“Without it, rows cannot be referenced or joined uniquely.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.795324788+00:00”} |
||||
| table_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the source table this segment is defined on.”,“why”:“Without it, the segment’s scope is unknown and cannot be applied to the correct data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.806708308+00:00”} |
|||||
| creator_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the user who created the segment.”,“why”:“Without it, ownership and audit trail are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.825363495+00:00”} |
|||||
| name | varchar | 254 | null |
|
|
{“what”:“Short human-readable name for the segment, e.g., ‘Active Users’.”,“why”:“Without it, segments cannot be distinguished in lists or UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.850989457+00:00”} |
|||||
| description | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form explanation of the segment’s purpose or contents.”,“why”:“Without it, future users cannot understand the segment’s intent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.861719918+00:00”} |
||||
| archived | bool | 1 | false |
|
|
{“what”:“Flag indicating whether the segment is hidden from active use (true) or available (false).”,“why”:“Without it, retired segments would clutter the interface and confuse users.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.887863129+00:00”} |
|||||
| definition | text | 2147483647 | null |
|
|
{“what”:“Query or condition logic that selects the segment’s rows from the source table.”,“why”:“Without it, the segment has no actual data and cannot be executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.922937887+00:00”} |
|||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when the segment was created, in UTC.”,“why”:“Without it, creation order and audit history are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.955883291+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the last modification to the segment, in UTC.”,“why”:“Without it, stale or conflicting edits cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.974886088+00:00”} |
|||||
| points_of_interest | text | 2147483647 | √ | null |
|
|
{“what”:“Notes about notable rows or patterns within the segment.”,“why”:“Without it, analysts lose context on interesting data points.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.003203748+00:00”} |
||||
| caveats | text | 2147483647 | √ | null |
|
|
{“what”:“Warnings or limitations about the segment’s data or definition.”,“why”:“Without it, users may misinterpret results or apply the segment incorrectly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.025321209+00:00”} |
||||
| show_in_getting_started | bool | 1 | false |
|
|
{“what”:“Flag indicating whether the segment appears in the getting-started guide (true) or not (false).”,“why”:“Without it, onboarding content cannot be curated for new users.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.070635095+00:00”} |
|||||
| entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“Single-character code for the entity type the segment is associated with.”,“why”:“Without it, the segment’s target entity type is ambiguous when multiple entity types exist.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.113278123+00:00”} |
||||
| dependency_analysis_version | int4 | 10 | 0 |
|
|
{“what”:“Integer version number for the dependency analysis algorithm used on this segment.”,“why”:“Without it, changes in analysis logic cannot be tracked or invalidated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.143018171+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| segment_pkey | Primary key | Asc | id |
| idx_segment_creator_id | Performance | Asc | creator_id |
| idx_segment_show_in_getting_started | Performance | Asc | show_in_getting_started |
| idx_segment_table_id | Performance | Asc | table_id |
| segment_entity_id_key | Must be unique | Asc | entity_id |