01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
IMAGE_TYPE→V_IMAGE_TYPES.IMAGE_TYPE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | FORM_ID PK | integer | int | no | |
| 2 | IMAGE_TYPE | string | varchar(15) | no | |
| 3 | IMAGE_DESCRIPTION | string | varchar(200) | no | |
| 4 | IMAGE_DATETIME | datetime | datetime | no | |
| 5 | IMAGE_BODY | file | image | yes | Stored file; the value is the path of the file under documents/. |
| 6 | IMAGE_THUMB | file | image | yes | Stored file; the value is the path of the file under documents/. |
| 7 | IMAGE_FORMAT | string | varchar(5) | no | |
| 8 | ENTRY_DATE | datetime | datetime | no | |
| 9 | ENTRY_USER_ID | string | varchar(20) | no | |
| 10 | CHANGE_DATE | datetime | datetime | no | |
| 11 | CHANGE_USER_ID | string | varchar(20) | no | |
| 12 | IMAGE_FILENAME | string | varchar(255) | yes |