| cpoe_res_id | int(11) | NO | | PRI | auto_increment | |
| cpoe_res_cus_id | int(11) | NO | 0 | MUL | | |
| cpoe_res_cli_id | int(11) | NO | 0 | MUL | | |
| cpoe_res_pat_id | int(11) | NO | | MUL | | |
| cpoe_res_lab_id | int(11) | NO | 0 | MUL | | |
| cpoe_res_don_id | int(11) | NO | 0 | MUL | | |
| cpoe_res_invper_id | int(11) | NO | 0 | MUL | | |
| cpoe_res_invnum_id | int(11) | NO | 0 | MUL | | |
| cpoe_res_master_cli_account_num | varchar(20) | NO | | MUL | | |
| cpoe_res_cli_account_num | varchar(20) | NO | | MUL | | |
| cpoe_res_secondary_index | varchar(20) | NO | | MUL | | |
| cpoe_res_pid | varchar(20) | NO | | MUL | | |
| cpoe_res_mrn | varchar(20) | NO | | MUL | | |
| cpoe_res_ssn | varchar(20) | NO | | MUL | | |
| cpoe_res_fname | varchar(20) | NO | | MUL | | |
| cpoe_res_mname | varchar(20) | NO | | | | |
| cpoe_res_lname | varchar(20) | NO | | MUL | | |
| cpoe_res_sex | varchar(7) | NO | | | | |
| cpoe_res_dob | varchar(20) | NO | | | | |
| cpoe_res_age | varchar(10) | NO | | | | |
| cpoe_res_room_num | varchar(10) | NO | | | | |
| cpoe_res_location | varchar(10) | NO | | MUL | | |
| cpoe_res_fasting | varchar(10) | NO | | | | |
| cpoe_res_accession_num | varchar(40) | NO | | MUL | | |
| cpoe_res_phone | varchar(20) | NO | | | | |
| cpoe_res_critical | varchar(2) | NO | 0 | | | |
| cpoe_res_collected_timestamp | varchar(12) | NO | | MUL | | |
| cpoe_res_received_timestamp | varchar(12) | NO | | MUL | | |
| cpoe_res_reported_timestamp | varchar(12) | NO | | MUL | | |
| cpoe_res_req_num | varchar(20) | NO | | | | |
| cpoe_res_physician | varchar(30) | NO | | | | |
| cpoe_res_supervising_phy_id | int(11) | NO | | MUL | | |
| cpoe_res_status | char(1) | NO | | MUL | | |
| cpoe_res_chain_of_custody | varchar(20) | NO | | | | |
| cpoe_res_testing_reason | varchar(20) | NO | | | | |
| cpoe_res_invalid_to_negative_override | char(1) | NO | | | | |
| cpoe_res_mro_to_negative_override | char(1) | NO | | | | |
| cpoe_res_collected_unix_ts | int(11) | NO | | | | |
| cpoe_res_comments1 | varchar(80) | NO | | | | |
| cpoe_res_comments2 | varchar(80) | NO | | | | |
| cpoe_res_internal_note | text | NO | | | | |
| cpoe_res_mro_reviewed | char(1) | NO | | | | |
| cpoe_res_invalid_reviewed | char(1) | NO | | | | |
| cpoe_res_ordering_facility | text | NO | | | | |
| cpoe_res_desc | varchar(40) | NO | | | | |
| cpoe_res_path | text | NO | | | | |
| cpoe_res_web_account | char(1) | NO | 0 | MUL | | |
| cpoe_res_pending | char(1) | NO | | | | |
| cpoe_res_phr_released | char(1) | NO | | | | |
| cpoe_res_modified | datetime | YES | CURRENT_TIMESTAMP | | | |
| cpoe_res_created | datetime | YES | CURRENT_TIMESTAMP | MUL | | |
| cpoe_res_cpoe_req_id | int(11) | YES | | | | |