Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique numeric identifier; foreign key target from other tables.”,“why”:“Without it, rows cannot be uniquely referenced, breaking relationships.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.521367916+00:00”} |
||||
| name | varchar | 255 | null |
|
|
{“what”:“Short human-readable label for the timeline, e.g., ‘Q3 Launch’.”,“why”:“Without it, users cannot distinguish timelines in lists or dropdowns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.546293350+00:00”} |
|||||
| description | varchar | 255 | √ | null |
|
|
{“what”:“Optional free-text explanation of the timeline’s purpose or contents.”,“why”:“Without it, context for the timeline is missing, making it hard to understand its intent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.555612279+00:00”} |
||||
| icon | varchar | 128 | null |
|
|
{“what”:“Icon name or path used for UI display of the timeline.”,“why”:“Without it, the timeline lacks a visual cue in interfaces, reducing usability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.576527726+00:00”} |
|||||
| collection_id | int4 | 10 | √ | null |
|
|
{“what”:“Foreign key to a parent collection that groups timelines.”,“why”:“Without it, timelines cannot be organized into collections, so grouping and filtering by collection is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.597181833+00:00”} |
||||
| archived | bool | 1 | false |
|
|
{“what”:“Flag indicating whether the timeline is hidden from active use; true means archived.”,“why”:“Without it, archived timelines would appear in normal queries, cluttering active views.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.610487343+00:00”} |
|||||
| creator_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the user who created the timeline.”,“why”:“Without it, ownership and audit trail for the timeline is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.622567097+00:00”} |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone of row creation.”,“why”:“Without it, there is no record of when the timeline was created, breaking audit and sorting by creation date.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.635304896+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone of the last update to the timeline row.”,“why”:“Without it, there is no way to know when the timeline was last modified, breaking change tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.665455662+00:00”} |
|||||
| default | bool | 1 | false |
|
|
{“what”:“Flag indicating whether this timeline is the default for its context (e.g., user or collection).”,“why”:“Without it, there is no way to determine which timeline to use when none is explicitly chosen.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.684775747+00:00”} |
|||||
| entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“String identifier of an external entity this timeline belongs to, if any.”,“why”:“Without it, the timeline cannot be associated with a specific entity, making its scope ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.705163490+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| timeline_pkey | Primary key | Asc | id |
| idx_timeline_collection_id | Performance | Asc | collection_id |
| idx_timeline_creator_id | Performance | Asc | creator_id |
| timeline_entity_id_key | Must be unique | Asc | entity_id |