ReportAttachments


Description

Report attachment configurations managing file attachments and document associations for reports. This table defines which forms, columns, and categories can be attached to reports, supporting document management, report supplementation, and comprehensive reporting with supporting documentation for healthcare analytics and compliance.

Columns

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

Primary key - Unique identifier for each report attachment configuration
fkReportID int 4 null

Report reference - Links to the report that can have attachments
FormIds varchar 250 √ null

Form identifiers - Comma-separated list of form IDs that can be attached to this report
FormColumnName varchar 250 √ null

Form column name - Specific column name from forms that can be attached
CategoryIds varchar 250 √ null

Category identifiers - Comma-separated list of category IDs for organizing attachments

Relationships

Close relationships within degrees of separation