| erx_not_id | int(11) unsigned | NO | | PRI | auto_increment | |
| erx_not_prac_id | int(11) unsigned | NO | | MUL | | |
| erx_not_usr_id | int(11) | NO | | MUL | | |
| erx_not_total | int(4) unsigned | NO | | | | |
| erx_not_refill | int(2) unsigned | NO | | | | |
| erx_not_note | int(2) unsigned | NO | | | | |
| erx_not_error | int(2) unsigned | NO | | | | |
| erx_not_share | int(2) unsigned | NO | | | | |
| erx_not_request_share | int(2) unsigned | NO | | | | |
| erx_not_rx_need_signing | int(2) unsigned | NO | | | | |
| erx_not_rx_pending | int(2) unsigned | NO | | | | |
| erx_not_rx_orders_pending | int(2) unsigned | NO | | | | |
| erx_not_rx_need_dual_verify | int(11) | NO | 0 | | | Prescriptions that need dual signatures, have been signed but not verified |
| erx_not_rx_need_dual_sign | int(11) | NO | 0 | | | Prescriptions that need dual signatures, have been verified but not signed |
| erx_not_rxchange | int(11) | NO | 0 | | | Prescription change requests only |
| erx_not_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |