| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| imo_id | INT | 10 | √ | null |
|
|
|||||
| imo_im_id | INT | 10 | null |
|
|
The immunization record this observation is part of |
|||||
| imo_pid | INT | 10 | √ | NULL |
|
|
The internal patient identifier |
||||
| imo_criteria | VARCHAR | 255 | √ | NULL |
|
|
|||||
| imo_criteria_value | VARCHAR | 255 | √ | NULL |
|
|
|||||
| imo_user | INT | 10 | √ | NULL |
|
|
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() |
|
|
Showing 1 to 12 of 12 entries