dashboard_tab


Description

{“what”:“A tab within a dashboard, grouping related widgets or views.”,“why”:“Without it, dashboards cannot present multiple named views; navigation between sections is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.446339774+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
report_dashboardcard.dashboard_tab_id fk_report_dashboardcard_ref_dashboard_tab_id C

{“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
report_dashboard.id fk_dashboard_tab_ref_dashboard_id C

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

Relationships