_1.patients_medications
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| 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(1) | 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 | datetime | YES | CURRENT_TIMESTAMP | |||
| pms_created | datetime | YES | CURRENT_TIMESTAMP | |||
| pms_reconciled | char(1) | NO | MUL |
References
| Local Column | References | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pms_id |
|