| pms_id | int(11) | NO | | PRI | auto_increment | |
| pms_cus_id | int(11) | NO | | MUL | | |
| pms_cli_id | int(11) | NO | | MUL | | |
| pms_pat_id | int(11) | NO | | MUL | | |
| pms_deleted | char(1) | NO | 0 | MUL | | |
| pms_rcopia_id | varchar(24) | YES | | MUL | | Client unique key to Dr First patient medication |
| pms_provider | varchar(64) | NO | | | | |
| pms_preparer | varchar(64) | NO | | | | |
| pms_start_date | varchar(8) | NO | | | | |
| pms_start_ts | varchar(12) | NO | | | | |
| pms_stop_date | varchar(8) | NO | | | | |
| pms_stop_ts | varchar(12) | NO | | | | |
| pms_fill_date | varchar(8) | NO | | | | |
| pms_stop_reason | varchar(128) | NO | | | | |
| pms_drg_id | int(11) | NO | | MUL | | |
| pms_cs_id | int(11) | YES | | | | Code System ID# |
| pms_code | varchar(45) | NO | | | | Code |
| pms_desc | varchar(516) | NO | | | | Medication Description |
| pms_code_id | int(11) | YES | | | | Code ID# |
| pms_action | varchar(32) | NO | | | | |
| pms_dose | varchar(32) | NO | | | | |
| pms_dose_unit | varchar(32) | NO | | | | |
| pms_route | varchar(32) | NO | | | | |
| pms_dose_timing | varchar(100) | NO | | | | |
| pms_dose_other | varchar(100) | NO | | | | |
| pms_duration | varchar(32) | NO | | | | |
| pms_quantity | varchar(32) | NO | | | | |
| pms_quantity_units | varchar(32) | NO | | | | |
| pms_refills | tinyint(4) | NO | | | | |
| pms_notes | text | NO | | | | |
| pms_substitution_permitted | char(1) | NO | | | | |
| pms_education_provided | char(1) | NO | 0 | | | |
| pms_erx_comments | text | YES | | | | |
| pms_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| pms_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| pms_reconciled | char(1) | NO | | MUL | | |