chart_specs

{“what”:“UUID primary key, generated by gen_random_uuid(), uniquely identifying each chart spec.”,“why”:“Provides a stable reference for updates, deletions, and foreign keys from other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.856726326+00:00”}

{“what”:“UUID referencing the dataset version this chart spec is associated with.”,“why”:“Ensures charts are bound to a specific data snapshot; without it, charts would be ambiguous across versions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.927630343+00:00”}

{“what”:“Human-readable text label for the chart, used for display and identification.”,“why”:“Without it, charts cannot be distinguished in UI lists or reports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.182597752+00:00”}

{“what”:“Text indicating the chart kind, e.g., ‘bar’, ‘line’, ‘pie’.”,“why”:“Determines the rendering logic; without it, the chart cannot be drawn correctly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.292035346+00:00”}

{“what”:“Name of the data field used for the x-axis; nullable if not applicable.”,“why”:“Defines the independent variable; without it, the chart lacks a horizontal axis mapping.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.353512233+00:00”}

{“what”:“Array of field names for y-axis series; defaults to empty array.”,“why”:“Supports multi-series charts; without it, only a single series could be represented.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.441576870+00:00”}

{“what”:“Custom SQL query text for data extraction; nullable if using standard fields.”,“why”:“Allows complex or custom queries beyond the simple x/y fields; without it, such charts are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.512568341+00:00”}

{“what”:“Integer specifying the display order among charts; defaults to 0.”,“why”:“Controls the sequence of charts in a dashboard; without it, ordering is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.523375731+00:00”}