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