_1.hl7_results_obx_map
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| obxm_id | int(11) | NO | PRI | auto_increment | ||
| obxm_cus_id | int(11) | YES | MUL | |||
| obxm_cli_id | int(11) | YES | MUL | |||
| obxm_loinc_num | varchar(20) | YES | MUL | |||
| obxm_code | varchar(20) | YES | CPT, LOINC, or SNOMED code | |||
| obxm_cs_id | int(11) | NO | Code System ID to associate type of code | |||
| obxm_unit | varchar(45) | YES | ||||
| obxm_range | text | YES | ||||
| obxm_range_low | varchar(10) | YES | ||||
| obxm_range_high | varchar(10) | YES | ||||
| obxm_data_value_type | varchar(2) | YES | ||||
| obxm_modified | datetime | YES | CURRENT_TIMESTAMP | |||
| obxm_created | datetime | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|