Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique numeric identifier for the tab; internal primary key.”,“why”:“Without it, no stable reference exists for updates, deletions, or foreign keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.469676463+00:00”} |
||||
| dashboard_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the dashboard that owns this tab.”,“why”:“Without it, tabs cannot be scoped to a specific dashboard; a tab would be ambiguous across dashboards.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.513415347+00:00”} |
|||||
| name | text | 2147483647 | null |
|
|
{“what”:“Display name of the tab, e.g., ‘Overview’ or ‘Metrics’.”,“why”:“Without it, users cannot distinguish tabs in the UI; navigation becomes meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.530466548+00:00”} |
|||||
| position | int4 | 10 | null |
|
|
{“what”:“Ordering index of the tab within the dashboard, starting at 0.”,“why”:“Without it, tab order is undefined; UI would display tabs in arbitrary sequence.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.543644467+00:00”} |
|||||
| entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“Optional identifier of a related entity (e.g., a report or saved view) shown in this tab.”,“why”:“Without it, the tab cannot load the specific entity’s data; the tab would be empty or generic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.566409047+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the tab was created, in UTC.”,“why”:“Without it, audit trails and ordering by creation time are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.587714336+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last modification to the tab, in UTC.”,“why”:“Without it, concurrent edits cannot be detected; stale data may be shown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.609570698+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dashboard_tab_pkey | Primary key | Asc | id |
| dashboard_tab_entity_id_key | Must be unique | Asc | entity_id |
| idx_dashboard_tab_dashboard_id | Performance | Asc | dashboard_id |