common.test_codes_aoe

Field Type Null Default Key Extra Comment
tcaoe_id int(11) NO PRI auto_increment
tcaoe_lab_id int(11) NO MUL
tcaoe_code varchar(20) YES
tcaoe_name text YES
tcaoe_type varchar(6) YES
tcaoe_att_key varchar(40) NO
tcaoe_answers_format text YES
tcaoe_rules_json varchar(256) NO
tcaoe_hint varchar(256) NO
tcaoe_default_value longtext NO
tcaoe_priority int(11) NO
tcaoe_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
tcaoe_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
tcaoe_id
TableColumn
_1.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_1.test_codes_aoe_valuestcaoev_tcaoe_id
_1188.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_1188.test_codes_aoe_valuestcaoev_tcaoe_id
_1218.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_1218.test_codes_aoe_valuestcaoev_tcaoe_id
_1548.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_1548.test_codes_aoe_valuestcaoev_tcaoe_id
_435.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_435.test_codes_aoe_valuestcaoev_tcaoe_id
_436.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_436.test_codes_aoe_valuestcaoev_tcaoe_id
_436_archive_testing.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_436_archive_testing.test_codes_aoe_valuestcaoev_tcaoe_id
_437.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_437.test_codes_aoe_valuestcaoev_tcaoe_id
_8.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_8.test_codes_aoe_valuestcaoev_tcaoe_id
_81.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_81.test_codes_aoe_valuestcaoev_tcaoe_id
_999.radiology_order_test_codes_aoe_valuesrtcaoev_tcaoe_id
_999.test_codes_aoe_valuestcaoev_tcaoe_id
common.test_codes_aoe_maptcaoem_tcaoe_id