Documentation/EHI_Export/docs/tables/form_observation.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| form_id | BIGINT | 19 | null |
|
| forms.form_id | Defined in XML | R |
|
fk to forms.id represents the overall form for this observation
| | date | DATETIME | 19 | √ | | NULL |
|
| | | pid | BIGINT | 19 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | encounter | VARCHAR | 255 | √ | | NULL |
|
| form_encounter.encounter | Defined in XML | R |
|
References form_encounter.encounter, representing the encounter for this record
| | user | VARCHAR | 255 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
fk to users.username who created this observation
| | groupname | VARCHAR | 255 | √ | | NULL |
|
| | | authorized | TINYINT | 3 | √ | | NULL |
|
| | | activity | TINYINT | 3 | √ | | NULL |
|
| | | code | VARCHAR | 255 | √ | | NULL |
|
| | | observation | VARCHAR | 255 | √ | | NULL |
|
| | | ob_value | VARCHAR | 255 | √ | | NULL |
|
| | | ob_unit | VARCHAR | 255 | √ | | NULL |
|
| | | description | VARCHAR | 255 | √ | | NULL |
|
| | | code_type | VARCHAR | 255 | √ | | NULL |
|
| | | table_code | VARCHAR | 255 | √ | | NULL |
|
| | | ob_code | VARCHAR | 64 | √ | | NULL |
|
| | | ob_type | VARCHAR | 64 | √ | | NULL |
|
| | | ob_status | VARCHAR | 32 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘observation-status’
| | result_status | VARCHAR | 32 | √ | | NULL |
|
| | | ob_reason_status | VARCHAR | 32 | √ | | NULL |
|
| | | ob_reason_code | VARCHAR | 64 | √ | | NULL |
|
| | | ob_reason_text | TEXT | 65535 | √ | | NULL |
|
| | | ob_documentationof_table | VARCHAR | 255 | √ | | NULL |
|
| | | ob_documentationof_table_id | BIGINT | 19 | √ | | NULL |
|
| | | date_end | DATETIME | 19 | √ | | NULL |
|
| | | id | BIGINT | 19 | | √ | null |
|
| | | parent_observation_id | BIGINT | 19 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
fk to form_observation.id and is used to create hierarchical relationships between observations
| | category | VARCHAR | 64 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘Observation_Types’ and represents the category/type of observation being recorded
| | questionnaire_response_id | BIGINT | 19 | √ | | NULL |
|
| questionnaire_repository.id | Defined in XML | R |
|
fk to questionnaire_repository.questionnaire_response_id and is used link a questionnaire response to this observation
| | uuid | BINARY | 16 | √ | | NULL |
|
|
UUID for the observation, used as unique logical identifier
| | ob_value_code_description | VARCHAR | 255 | √ | | NULL |
|
| |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_category | Performance | Asc | category |
| idx_date | Performance | Asc | date |
| idx_form_id | Performance | Asc | form_id |
| idx_parent_observation | Performance | Asc | parent_observation_id |
| idx_pid_encounter | Performance | Asc/Asc | pid + encounter |
| idx_questionnaire_response | Performance | Asc | questionnaire_response_id |