diagnostic_report_presented_forms table contains the actual content of diagnostic reports, including text, images, and other media. This table stores the attachments and presented forms associated with diagnostic reports.
Primary Keys:
- diagnostic_report_id
| Column | Data Type | Description |
|---|---|---|
diagnostic_report_id | varchar | The ID of the parent diagnostic report |
data | varchar | The base64-encoded attachment data |
content_type | varchar | MIME type of the attachment (e.g., ‘application/pdf’, ‘image/jpeg’) |
creation | timestamp | Timestamp when the attachment was created |
hash | varchar | SHA-1 hash of the attachment content |
language | varchar | Language code of the attachment content |
size | integer | Size of the attachment in bytes |
title | varchar | Human-readable title of the attachment |
url | varchar | URL reference to the attachment (if applicable) |
diagnostic_report_id foreign key.