common.drugs

Field Type Null Default Key Extra Comment
drg_id int(11) NO PRI auto_increment
drg_rcopia_id varchar(24) NO MUL
drg_ndcid varchar(32) NO MUL
drg_first_databank_med_id varchar(32) NO MUL
drg_rx_auid int(11) NO MUL
drg_rx_cuid int(11) NO MUL
drg_brand_name varchar(128) NO MUL
drg_generic_name varchar(128) NO MUL
drg_route varchar(32) NO MUL
drg_form varchar(128) NO MUL
drg_strength varchar(32) NO MUL
drg_schedule char(1) YES 0 MUL
drg_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
drg_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
drg_id
TableColumn
Icd.apr_drg_codesapr_drg_id
_1.charts_medicationscm_drg_id
_1.emr_allergensalgn_drg_id
_1.patients_medicationspms_drg_id
_1.patients_prescriptionsprx_drg_id
_1188.charts_medicationscm_drg_id
_1188.emr_allergensalgn_drg_id
_1188.patients_medicationspms_drg_id
_1188.patients_prescriptionsprx_drg_id
_1218.charts_medicationscm_drg_id
_1218.emr_allergensalgn_drg_id
_1218.patients_medicationspms_drg_id
_1218.patients_prescriptionsprx_drg_id
_1548.charts_medicationscm_drg_id
_1548.emr_allergensalgn_drg_id
_1548.patients_medicationspms_drg_id
_1548.patients_prescriptionsprx_drg_id
_435.charts_medicationscm_drg_id
_435.emr_allergensalgn_drg_id
_435.patients_medicationspms_drg_id
_435.patients_prescriptionsprx_drg_id
_436.charts_medicationscm_drg_id
_436.emr_allergensalgn_drg_id
_436.patients_medicationspms_drg_id
_436.patients_prescriptionsprx_drg_id
_436_archive_testing.charts_medicationscm_drg_id
_436_archive_testing.emr_allergensalgn_drg_id
_436_archive_testing.patients_medicationspms_drg_id
_436_archive_testing.patients_prescriptionsprx_drg_id
_437.charts_medicationscm_drg_id
_437.emr_allergensalgn_drg_id
_437.patients_medicationspms_drg_id
_437.patients_prescriptionsprx_drg_id
_8.charts_medicationscm_drg_id
_8.emr_allergensalgn_drg_id
_8.patients_medicationspms_drg_id
_8.patients_prescriptionsprx_drg_id
_81.charts_medicationscm_drg_id
_81.emr_allergensalgn_drg_id
_81.patients_medicationspms_drg_id
_81.patients_prescriptionsprx_drg_id
_999.charts_medicationscm_drg_id
_999.emr_allergensalgn_drg_id
_999.patients_medicationspms_drg_id
_999.patients_prescriptionsprx_drg_id
drg_modified
TableColumn
Icd.apr_drg_codesapr_drg_modified
drg_created
TableColumn
Icd.apr_drg_codesapr_drg_created