timeline_event


Description

{“what”:“Events belonging to a timeline, each with a name, timestamp, and display options.”,“why”:“Without it, timelines would have no content to show.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.344876760+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique integer identifier for each event.”,“why”:“Without it, events cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.401508390+00:00”}

timeline_id int4 10 null
timeline.id fk_events_timeline_id C

{“what”:“Foreign key to the timeline this event belongs to.”,“why”:“Without it, events cannot be associated with a specific timeline.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.464822192+00:00”}

name varchar 255 null

{“what”:“Short display name for the event, e.g., ‘Release v1.0’.”,“why”:“Without it, the event has no label to show in the timeline.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.592376999+00:00”}

description varchar 255 √ null

{“what”:“Optional longer text describing the event details.”,“why”:“Without it, additional context about the event is unavailable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.635418487+00:00”}

timestamp timestamptz 35,6 null

{“what”:“The event’s date and time in UTC, with timezone offset.”,“why”:“Without it, the event cannot be placed chronologically on the timeline.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.663432872+00:00”}

time_matters bool 1 null

{“what”:“Whether the exact time is significant; false means only the date matters.”,“why”:“Without it, the UI cannot decide whether to display time or just date.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.699043742+00:00”}

timezone varchar 255 null

{“what”:“IANA timezone name (e.g., ‘America/New_York’) for displaying the timestamp.”,“why”:“Without it, the timestamp cannot be shown in the user’s local time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.823203829+00:00”}

icon varchar 128 null

{“what”:“Icon identifier (e.g., FontAwesome class) for the event’s visual marker.”,“why”:“Without it, the event lacks a distinct icon in the timeline UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.836127943+00:00”}

archived bool 1 false

{“what”:“Whether the event is hidden from normal view; true means archived.”,“why”:“Without it, archived events would still appear, cluttering the timeline.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.864109180+00:00”}

creator_id int4 10 null
core_user.id fk_event_creator_id C

{“what”:“Foreign key to the user who created the event.”,“why”:“Without it, ownership and audit trails for the event are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.875740976+00:00”}

created_at timestamptz 35,6 now()

{“what”:“UTC timestamp when the event row was inserted.”,“why”:“Without it, the creation time is lost, affecting audit and sorting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.905447782+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“UTC timestamp of the last update to the event row.”,“why”:“Without it, stale data cannot be detected or resolved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.931235920+00:00”}

Indexes

Constraint Name Type Sort Column(s)
timeline_event_pkey Primary key Asc id
idx_timeline_event_creator_id Performance Asc creator_id
idx_timeline_event_timeline_id Performance Asc timeline_id
idx_timeline_event_timeline_id_timestamp Performance Asc/Asc timeline_id + timestamp

Relationships