report_dashboard


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
dashboard_bookmark.dashboard_id fk_dashboard_bookmark_dashboard_id C
dashboard_favorite.dashboard_id fk_dashboard_favorite_dashboard_id C
dashboard_tab.dashboard_id fk_dashboard_tab_ref_dashboard_id C
pulse.dashboard_id fk_pulse_ref_dashboard_id C
report_card.dashboard_id fk_report_card_ref_dashboard_id C
report_dashboardcard.dashboard_id fk_dashboardcard_ref_dashboard_id C
user_parameter_value.dashboard_id fk_user_parameter_value_dashboard_id C

{“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
core_user.id fk_dashboard_ref_user_id C

{“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
core_user.id fk_dashboard_made_public_by_id C

{“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
collection.id fk_dashboard_collection_id N

{“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

Relationships