_1548.orders_templates

Field Type Null Default Key Extra Comment
ordt_id int(11) NO PRI auto_increment
ordt_cus_id int(11) NO MUL
ordt_cli_id int(11) NO MUL
ordt_est_id int(11) NO MUL
ordt_status varchar(20) NO
ordt_psc char(1) NO
ordt_volume varchar(10) NO
ordt_duration varchar(10) NO
ordt_source varchar(20) NO
ordt_fasting varchar(10) NO
ordt_pregnant varchar(10) NO
ordt_abn_lang tinyint(1) NO 0
ordt_standing tinyint(1) NO 0
ordt_complete tinyint(1) NO 0
ordt_manifest tinyint(1) NO 0
ordt_received tinyint(1) NO 0
ordt_finalized tinyint(1) NO 0
ordt_fax char(1) NO 0
ordt_patient_education char(1) NO
ordt_lif_id int(11) NO
ordt_lab_id int(11) NO
ordt_modified datetime YES CURRENT_TIMESTAMP
ordt_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
ordt_id
TableColumn
_1.orders_comments_templatesorct_ordt_id
_1.orders_icd9_codes_templatesoict_ordt_id
_1.orders_standing_templatesostt_ordt_id
_1.orders_test_codes_templatesotct_ordt_id
_1188.orders_comments_templatesorct_ordt_id
_1188.orders_icd9_codes_templatesoict_ordt_id
_1188.orders_standing_templatesostt_ordt_id
_1188.orders_test_codes_templatesotct_ordt_id
_1218.orders_comments_templatesorct_ordt_id
_1218.orders_icd9_codes_templatesoict_ordt_id
_1218.orders_standing_templatesostt_ordt_id
_1218.orders_test_codes_templatesotct_ordt_id
_1548.orders_comments_templatesorct_ordt_id
_1548.orders_icd9_codes_templatesoict_ordt_id
_1548.orders_standing_templatesostt_ordt_id
_1548.orders_test_codes_templatesotct_ordt_id
_435.orders_comments_templatesorct_ordt_id
_435.orders_icd9_codes_templatesoict_ordt_id
_435.orders_standing_templatesostt_ordt_id
_435.orders_test_codes_templatesotct_ordt_id
_436.orders_comments_templatesorct_ordt_id
_436.orders_icd9_codes_templatesoict_ordt_id
_436.orders_standing_templatesostt_ordt_id
_436.orders_test_codes_templatesotct_ordt_id
_436_archive_testing.orders_comments_templatesorct_ordt_id
_436_archive_testing.orders_icd9_codes_templatesoict_ordt_id
_436_archive_testing.orders_standing_templatesostt_ordt_id
_436_archive_testing.orders_test_codes_templatesotct_ordt_id
_437.orders_comments_templatesorct_ordt_id
_437.orders_icd9_codes_templatesoict_ordt_id
_437.orders_standing_templatesostt_ordt_id
_437.orders_test_codes_templatesotct_ordt_id
_8.orders_comments_templatesorct_ordt_id
_8.orders_icd9_codes_templatesoict_ordt_id
_8.orders_standing_templatesostt_ordt_id
_8.orders_test_codes_templatesotct_ordt_id
_81.orders_comments_templatesorct_ordt_id
_81.orders_icd9_codes_templatesoict_ordt_id
_81.orders_standing_templatesostt_ordt_id
_81.orders_test_codes_templatesotct_ordt_id
_999.orders_comments_templatesorct_ordt_id
_999.orders_icd9_codes_templatesoict_ordt_id
_999.orders_standing_templatesostt_ordt_id
_999.orders_test_codes_templatesotct_ordt_id
template_library.orders_comments_templatesorct_ordt_id
template_library.orders_icd9_codes_templatesoict_ordt_id
template_library.orders_standing_templatesostt_ordt_id
template_library.orders_test_codes_templatesotct_ordt_id