DataSourceReports


Description

Data source report assignments linking data sources to their default reports for automated report generation. This table manages which default reports are associated with specific data sources, supporting automated reporting, report assignment, and data source-specific report configuration for healthcare analytics.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null

Primary key - Unique identifier for each data source report assignment
DatasourceID nvarchar 100 null

Data source identifier - Identifier of the data source
DefaultReportID int 4 null

Default report reference - Links to the default report for this data source

Indexes

Constraint Name Type Sort Column(s)
PK_DataSourceReports Primary key Asc ID

Relationships

Close relationships within degrees of separation