report_dashboardcard


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
dashboardcard_series.dashboardcard_id fk_dashboardcard_series_ref_dashboardcard_id C
pulse_card.dashboard_card_id fk_pulse_card_ref_pulse_card_id C

{“what”:“Unique integer identifier for each dashboard-card placement.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:35.967713320+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the placement row was created, in UTC.”,“why”:“Without it, audit history and ordering by creation time are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:35.988467929+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of the last update to this placement row, in UTC.”,“why”:“Without it, concurrent edits cannot be detected or reconciled.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.004122247+00:00”}

size_x int4 10 null

{“what”:“Width of the card in grid columns (e.g., 1-12).”,“why”:“Without it, the card’s horizontal extent on the dashboard is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.023653825+00:00”}

size_y int4 10 null

{“what”:“Height of the card in grid rows (e.g., 1-12).”,“why”:“Without it, the card’s vertical extent on the dashboard is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.041669217+00:00”}

row int4 10 null

{“what”:“Vertical grid position of the card’s top edge, starting at 0.”,“why”:“Without it, cards would overlap or have no defined vertical placement.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.050886724+00:00”}

col int4 10 null

{“what”:“Horizontal grid position of the card’s left edge, starting at 0.”,“why”:“Without it, cards would have no defined horizontal placement.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.098585171+00:00”}

card_id int4 10 √ null
report_card.id fk_dashboardcard_ref_card_id C

{“what”:“Foreign key to the card being placed; null if the card is an action.”,“why”:“Without it, the placed content cannot be identified as a card.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.132389641+00:00”}

dashboard_id int4 10 null
report_dashboard.id fk_dashboardcard_ref_dashboard_id C

{“what”:“Foreign key to the dashboard that contains this placement.”,“why”:“Without it, the placement is not associated with any dashboard.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.147794907+00:00”}

parameter_mappings text 2147483647 null

{“what”:“JSON text mapping dashboard parameters to card parameters.”,“why”:“Without it, dashboard-level filters cannot propagate to the card.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.157236254+00:00”}

visualization_settings text 2147483647 null

{“what”:“JSON text with card-specific visualization options (e.g., chart type, axes).”,“why”:“Without it, the card’s display configuration is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.184967606+00:00”}

entity_id bpchar 21 √ null

{“what”:“Stable unique identifier for the placement, used for external references.”,“why”:“Without it, external systems cannot refer to this placement without exposing the integer id.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.202603026+00:00”}

action_id int4 10 √ null
action.id fk_report_dashboardcard_ref_action_id C

{“what”:“Foreign key to an action associated with this placement; null if none.”,“why”:“Without it, click actions on the card cannot be defined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.219931954+00:00”}

dashboard_tab_id int4 10 √ null
dashboard_tab.id fk_report_dashboardcard_ref_dashboard_tab_id C

{“what”:“Foreign key to the dashboard tab that contains this placement; null if single-tab.”,“why”:“Without it, multi-tab dashboards cannot place cards on specific tabs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.233411118+00:00”}

inline_parameters text 2147483647 √ null

{“what”:“JSON text of parameters defined directly on the card, overriding dashboard parameters.”,“why”:“Without it, card-specific parameter overrides are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:36.252073311+00:00”}

Indexes

Constraint Name Type Sort Column(s)
report_dashboardcard_pkey Primary key Asc id
idx_dashboardcard_card_id Performance Asc card_id
idx_dashboardcard_dashboard_id Performance Asc dashboard_id
idx_report_dashboardcard_action_id Performance Asc action_id
idx_report_dashboardcard_dashboard_tab_id Performance Asc dashboard_tab_id
report_dashboardcard_entity_id_key Must be unique Asc entity_id

Relationships