_1188.orders_templates

Field	Type	Null	Default	Key	Extra
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	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
ordt_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

ordt_id

Table	Column
_1.orders_comments_templates	orct_ordt_id
_1.orders_icd9_codes_templates	oict_ordt_id
_1.orders_standing_templates	ostt_ordt_id
_1.orders_test_codes_templates	otct_ordt_id
_1188.orders_comments_templates	orct_ordt_id
_1188.orders_icd9_codes_templates	oict_ordt_id
_1188.orders_standing_templates	ostt_ordt_id
_1188.orders_test_codes_templates	otct_ordt_id
_1218.orders_comments_templates	orct_ordt_id
_1218.orders_icd9_codes_templates	oict_ordt_id
_1218.orders_standing_templates	ostt_ordt_id
_1218.orders_test_codes_templates	otct_ordt_id
_1548.orders_comments_templates	orct_ordt_id
_1548.orders_icd9_codes_templates	oict_ordt_id
_1548.orders_standing_templates	ostt_ordt_id
_1548.orders_test_codes_templates	otct_ordt_id
_435.orders_comments_templates	orct_ordt_id
_435.orders_icd9_codes_templates	oict_ordt_id
_435.orders_standing_templates	ostt_ordt_id
_435.orders_test_codes_templates	otct_ordt_id
_436.orders_comments_templates	orct_ordt_id
_436.orders_icd9_codes_templates	oict_ordt_id
_436.orders_standing_templates	ostt_ordt_id
_436.orders_test_codes_templates	otct_ordt_id
_436_archive_testing.orders_comments_templates	orct_ordt_id
_436_archive_testing.orders_icd9_codes_templates	oict_ordt_id
_436_archive_testing.orders_standing_templates	ostt_ordt_id
_436_archive_testing.orders_test_codes_templates	otct_ordt_id
_437.orders_comments_templates	orct_ordt_id
_437.orders_icd9_codes_templates	oict_ordt_id
_437.orders_standing_templates	ostt_ordt_id
_437.orders_test_codes_templates	otct_ordt_id
_8.orders_comments_templates	orct_ordt_id
_8.orders_icd9_codes_templates	oict_ordt_id
_8.orders_standing_templates	ostt_ordt_id
_8.orders_test_codes_templates	otct_ordt_id
_81.orders_comments_templates	orct_ordt_id
_81.orders_icd9_codes_templates	oict_ordt_id
_81.orders_standing_templates	ostt_ordt_id
_81.orders_test_codes_templates	otct_ordt_id
_999.orders_comments_templates	orct_ordt_id
_999.orders_icd9_codes_templates	oict_ordt_id
_999.orders_standing_templates	ostt_ordt_id
_999.orders_test_codes_templates	otct_ordt_id
template_library.orders_comments_templates	orct_ordt_id
template_library.orders_icd9_codes_templates	oict_ordt_id
template_library.orders_standing_templates	ostt_ordt_id
template_library.orders_test_codes_templates	otct_ordt_id