Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique numeric identifier for the dashboard.”,“why”:“Primary key; without it, rows cannot be uniquely referenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.101524504+00:00”} |
||||||||||||||||||||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“UTC timestamp when the dashboard row was created.”,“why”:“Audit trail and ordering; without it, creation time is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.112340235+00:00”} |
|||||||||||||||||||||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“UTC timestamp of the last update to any column.”,“why”:“Tracks modification time; without it, staleness cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.125961847+00:00”} |
|||||||||||||||||||||||
| name | varchar | 254 | null |
|
|
{“what”:“Human-readable dashboard title, e.g., ‘Sales Overview’.”,“why”:“Display name; without it, dashboards are indistinguishable in UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.155010899+00:00”} |
|||||||||||||||||||||||
| description | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form text describing the dashboard’s purpose.”,“why”:“Provides context for users; without it, intent is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.167948500+00:00”} |
||||||||||||||||||||||
| creator_id | int4 | 10 | null |
|
|
{“what”:“User ID of the dashboard’s author.”,“why”:“Ownership and permissions; without it, cannot attribute or restrict access.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.180875622+00:00”} |
|||||||||||||||||||||||
| parameters | text | 2147483647 | null |
|
|
{“what”:“Serialized JSON of default filter parameters applied to all cards.”,“why”:“Defines initial filter state; without it, dashboards lose their configured defaults.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.199432177+00:00”} |
|||||||||||||||||||||||
| points_of_interest | text | 2147483647 | √ | null |
|
|
{“what”:“Serialized JSON of highlighted data points or annotations.”,“why”:“Stores user-flagged insights; without it, these annotations are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.213214054+00:00”} |
||||||||||||||||||||||
| caveats | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form text listing known limitations or warnings.”,“why”:“Communicates data caveats; without it, users may misinterpret results.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.229494407+00:00”} |
||||||||||||||||||||||
| show_in_getting_started | bool | 1 | false |
|
|
{“what”:“Flag indicating if dashboard appears in the getting-started guide.”,“why”:“Controls onboarding visibility; without it, guide content cannot be curated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.243862650+00:00”} |
|||||||||||||||||||||||
| public_uuid | varchar | 254 | √ | null |
|
|
{“what”:“UUID string for public sharing link.”,“why”:“Enables unauthenticated access; without it, public sharing is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.260412909+00:00”} |
||||||||||||||||||||||
| made_public_by_id | int4 | 10 | √ | null |
|
|
{“what”:“User ID who last made the dashboard public.”,“why”:“Audit trail for public exposure; without it, who published is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.278625929+00:00”} |
||||||||||||||||||||||
| enable_embedding | bool | 1 | false |
|
|
{“what”:“Flag allowing iframe embedding in external sites.”,“why”:“Security control; without it, embedding cannot be restricted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.292587125+00:00”} |
|||||||||||||||||||||||
| embedding_params | text | 2147483647 | √ | null |
|
|
{“what”:“Serialized JSON of allowed parameters for embedded dashboards.”,“why”:“Defines embeddable filter options; without it, embedded dashboards cannot be configured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.306337547+00:00”} |
||||||||||||||||||||||
| archived | bool | 1 | false |
|
|
{“what”:“Flag indicating if dashboard is soft-deleted and hidden.”,“why”:“Allows recovery; without it, deletion would be permanent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.319451069+00:00”} |
|||||||||||||||||||||||
| position | int4 | 10 | √ | null |
|
|
{“what”:“Sort order index within a collection.”,“why”:“Controls ordering; without it, dashboards appear in arbitrary order.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.352648590+00:00”} |
||||||||||||||||||||||
| collection_id | int4 | 10 | √ | null |
|
|
{“what”:“ID of the collection this dashboard belongs to.”,“why”:“Groups dashboards; without it, organization is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.368719291+00:00”} |
||||||||||||||||||||||
| collection_position | int2 | 5 | √ | null |
|
|
{“what”:“Sort order index within the collection, separate from global position.”,“why”:“Refines ordering within collection; without it, ordering is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.381501072+00:00”} |
||||||||||||||||||||||
| cache_ttl | int4 | 10 | √ | null |
|
|
{“what”:“Time-to-live in seconds for cached dashboard results.”,“why”:“Controls cache freshness; without it, caching behavior is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.404863625+00:00”} |
||||||||||||||||||||||
| entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“Stable unique identifier for the dashboard, possibly UUID.”,“why”:“External references; without it, renaming or moving breaks links.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.423763488+00:00”} |
||||||||||||||||||||||
| auto_apply_filters | bool | 1 | true |
|
|
{“what”:“Flag indicating if filters apply automatically on change.”,“why”:“Controls UX; without it, filter behavior is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.437758460+00:00”} |
|||||||||||||||||||||||
| width | varchar | 16 | 'fixed'::character varying |
|
|
{“what”:“Layout width mode: ‘fixed’ or ‘full’.”,“why”:“Determines responsive design; without it, dashboard layout is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.448220500+00:00”} |
|||||||||||||||||||||||
| initially_published_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“UTC timestamp when dashboard was first made public.”,“why”:“Tracks publication history; without it, first publish date is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.467014084+00:00”} |
||||||||||||||||||||||
| view_count | int4 | 10 | 0 |
|
|
{“what”:“Number of times the dashboard has been viewed.”,“why”:“Popularity metric; without it, usage analytics are missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.504864331+00:00”} |
|||||||||||||||||||||||
| archived_directly | bool | 1 | false |
|
|
{“what”:“Flag indicating if archived was set directly vs via parent.”,“why”:“Distinguishes direct archive; without it, archive source is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.523613926+00:00”} |
|||||||||||||||||||||||
| last_viewed_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp of the most recent view.”,“why”:“Tracks recency; without it, inactive dashboards cannot be identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.543777729+00:00”} |
|||||||||||||||||||||||
| dependency_analysis_version | int2 | 5 | 0 |
|
|
{“what”:“Version of dependency analysis used for this dashboard.”,“why”:“Ensures cache invalidation; without it, stale dependencies may persist.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.556531938+00:00”} |
|||||||||||||||||||||||
| embedding_type | varchar | 50 | √ | null |
|
|
{“what”:“Type of embedding, e.g., ‘public’ or ‘signed’.”,“why”:“Determines embedding security model; without it, embedding behavior is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.571360347+00:00”} |
||||||||||||||||||||||
| public_uuid_prefix | varchar | 36 | √ | null |
|
|
{“what”:“Prefix for the public UUID, used for vanity URLs.”,“why”:“Customizes share links; without it, URLs are less readable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:24.594055758+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| report_dashboard_pkey | Primary key | Asc | id |
| idx_dashboard_collection_id | Performance | Asc | collection_id |
| idx_dashboard_creator_id | Performance | Asc | creator_id |
| idx_dashboard_public_uuid | Performance | Asc | public_uuid |
| idx_report_dashboard_dependency_analysis_version | Performance | Asc | dependency_analysis_version |
| idx_report_dashboard_made_public_by_id | Performance | Asc | made_public_by_id |
| idx_report_dashboard_public_uuid_prefix | Performance | Asc | public_uuid_prefix |
| idx_report_dashboard_show_in_getting_started | Performance | Asc | show_in_getting_started |
| report_dashboard_entity_id_key | Must be unique | Asc | entity_id |
| report_dashboard_public_uuid_key | Must be unique | Asc | public_uuid |