Documentation/EHI_Export/docs/tables/immunization_observation.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| imo_id | INT | 10 | √ | null |
|
| | | imo_im_id | INT | 10 | | | null |
|
| immunizations.id | Defined in XML | R |
|
The immunization record this observation is part of
| | imo_pid | INT | 10 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | imo_criteria | VARCHAR | 255 | √ | | NULL |
|
| | | imo_criteria_value | VARCHAR | 255 | √ | | NULL |
|
| | | imo_user | INT | 10 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The user that is recording the observation for this immunization
| | imo_code | VARCHAR | 255 | √ | | NULL |
|
| | | imo_codetext | VARCHAR | 255 | √ | | NULL |
|
| | | imo_codetype | VARCHAR | 255 | √ | | NULL |
|
| | | imo_vis_date_published | DATE | 10 | √ | | NULL |
|
| | | imo_vis_date_presented | DATE | 10 | √ | | NULL |
|
| | | imo_date_observation | TIMESTAMP | 19 | | | current_timestamp() |
|
| |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | imo_id |