Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |