_1218.charts_medications
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| cm_id | int(11) | NO | PRI | auto_increment | ||
| cm_cus_id | int(11) | NO | MUL | |||
| cm_cli_id | int(11) | NO | MUL | |||
| cm_esp_id | int(11) | NO | MUL | |||
| cm_pat_id | int(11) | NO | MUL | |||
| cm_pms_id | int(11) | NO | MUL | |||
| cm_drg_id | int(11) | NO | MUL | |||
| cm_cs_id | int(11) | YES | Code System ID# | |||
| cm_code | varchar(45) | NO | Code | |||
| cm_desc | varchar(516) | NO | Medication Description | |||
| cm_code_id | int(11) | YES | Code ID# | |||
| cm_start_date | varchar(8) | YES | ||||
| cm_start_ts | varchar(12) | NO | ||||
| cm_stop_date | varchar(8) | YES | ||||
| cm_stop_ts | varchar(12) | NO | ||||
| cm_action | varchar(32) | NO | ||||
| cm_dose | varchar(32) | NO | ||||
| cm_dose_unit | varchar(32) | NO | ||||
| cm_dose_timing | varchar(100) | NO | ||||
| cm_dose_other | varchar(100) | NO | ||||
| cm_route | varchar(32) | NO | ||||
| cm_quantity | varchar(32) | NO | ||||
| cm_quantity_units | varchar(32) | NO | ||||
| cm_refills | tinyint(4) | NO | ||||
| cm_notes | text | NO | ||||
| cm_priority | int(11) | NO | ||||
| cm_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| cm_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cm_id |
|