Report

What It Models

A report adds a presentation to saved questions. A dashboard combines multiple questions while retaining the sources needed for access checks and change indicators.

Identity and Attributes

Ownership, audience and source versions belong to the stored report. Built-in components remain console code until someone saves a coded copy.

Relationships

Source references protect saved queries from deletion and provide the boundary for sharing. Export files and schedules retain their own execution histories.

Invariants

The invariant rows define audience checks, source replacement and version-aware writes. Catalog visibility alone does not guarantee an executable joined query.

How It Is Stored and Shared

The query service stores report definitions and source rows; console components interpret the layout. Rendering is a separate background workflow.

Open Design Questions

Report approval and runtime coverage remain limited by the recorded reporting and catalog findings.

Relationships

To	Cardinality	Ownership	Crosses a service	On archive or delete
`DOM-PFM-QRY-002`	many-to-many	The report maintains its source references; each source constrains audience width and saved-query deletion.	no
`DOM-PFM-QRY-004`	one-to-many	File and schedule rows refer to reports. Deletion clears an export reference while retaining its completed file and pauses dependent schedules.	no

Invariants

Invariant	Enforced at	Provenance
`INV-DOM-PFM-QRY-003-01` Report discovery includes owners, selected-role holders, workspace audiences and report managers; others receive not found.	service	observed services-platform:modules/queries/services/reports/report-access.ts
`INV-DOM-PFM-QRY-003-02` Writing a report checks its audience against locked sources in the same transaction, including every dashboard source.	service, database	observed services-platform:modules/queries/services/persistence/reports.ts:requireNoWiderThanQuery
`INV-DOM-PFM-QRY-003-03` Dashboards omit the direct saved-query field and allow at most fifty distinct sources; other report kinds require one direct source.	service, database	observed services-platform:modules/queries/db/reports.table.ts (reports_saved_query_check); modules/queries/db/dashboard-sources.ts
`INV-DOM-PFM-QRY-003-04` A report name is case-insensitively unique per owner and workspace.	service, database	observed services-platform:modules/queries/services/persistence/reports.ts (reports_tenant_owner_name_uidx)
`INV-DOM-PFM-QRY-003-05` A report write replaces its complete source-reference collection within the same transaction.	service	observed services-platform:modules/queries/services/persistence/reports.ts
`INV-DOM-PFM-QRY-003-06` Report deletion pauses dependent schedules atomically without deleting source queries or completed files.	service, database	observed services-platform:modules/queries/services/reports/report-library.ts:removeReport
`INV-DOM-PFM-QRY-003-07` Presentation access grants no source-data authority; inaccessible sources reveal only their identity and change indication.	service	observed services-platform:modules/queries/services/reports/report-library.ts
`INV-DOM-PFM-QRY-003-08` Report saves provide the read version in their body and deletes in their parameter; absent versions are refused and stale versions conflict.	api, service	documented services-platform:docs/milestones/plans/RPT-M1-plan.md#RPT-M1

Planning

Design

Report ​

What It Models ​

Identity and Attributes ​

Relationships ​

Invariants ​

How It Is Stored and Shared ​

Open Design Questions ​

Relationships

Invariants

Report

What It Models

Identity and Attributes

Relationships

Invariants

How It Is Stored and Shared

Open Design Questions