timeline


Description

{“what”:“A named timeline that groups time-ordered items under a common context.”,“why”:“Without it, there is no entity to attach time-ordered items to, so they cannot be grouped or referenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.510128577+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
timeline_event.timeline_id fk_events_timeline_id C

{“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
collection.id fk_timeline_collection_id C

{“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
core_user.id fk_timeline_creator_id C

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

Relationships