Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each dashboardcard_series row.”,“why”:“Provides a stable primary key for referencing and updating specific links.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:17.377624368+00:00”} |
||||
| dashboardcard_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the dashboard card that owns this series link.”,“why”:“Identifies which dashboard card the series belongs to; without it, series are orphaned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:17.397806980+00:00”} |
|||||
| card_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the card (series definition) being displayed on the dashboard.”,“why”:“Determines which series data to fetch; without it, the dashboard card has no content.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:17.417743173+00:00”} |
|||||
| position | int4 | 10 | null |
|
|
{“what”:“Integer order of the series within the dashboard card, starting from 0 or 1.”,“why”:“Controls the display order of multiple series; without it, series order is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:17.434386242+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dashboardcard_series_pkey | Primary key | Asc | id |
| idx_dashboardcard_series_card_id | Performance | Asc | card_id |
| idx_dashboardcard_series_dashboardcard_id | Performance | Asc | dashboardcard_id |