template_library.encounters_stored_notes

Field Type Null Default Key Extra Comment
esn_id int(11) NO PRI auto_increment
esn_from_cus_id int(11) YES MUL Customer ID#
esn_from_cli_id int(11) YES MUL Client ID#
esn_spe_id int(11) YES MUL Specialities ID#
esn_esnc_id int(11) YES MUL Chart Area ID#
esn_parent_esn_id int(11) YES MUL Parent stored note ID# for nest
esn_order int(11) NO 0 MUL Order to display notes
esn_type int(11) NO 0 0: text. 1: grouping/folder
esn_label varchar(40) YES
esn_text text NO
esn_disabled tinyint(1) NO 0
esn_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
esn_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
esn_id
TableColumn
_1.encounters_stored_notes_accessesna_esn_id
_1.encounters_stored_notes_frequencyesnf_esn_id
_1.encounters_stored_notes_patients_frequencyesnpf_esn_id
_1188.encounters_stored_notes_accessesna_esn_id
_1188.encounters_stored_notes_frequencyesnf_esn_id
_1188.encounters_stored_notes_patients_frequencyesnpf_esn_id
_1218.encounters_stored_notes_accessesna_esn_id
_1218.encounters_stored_notes_frequencyesnf_esn_id
_1218.encounters_stored_notes_patients_frequencyesnpf_esn_id
_1548.encounters_stored_notes_accessesna_esn_id
_1548.encounters_stored_notes_frequencyesnf_esn_id
_1548.encounters_stored_notes_patients_frequencyesnpf_esn_id
_435.encounters_stored_notes_accessesna_esn_id
_435.encounters_stored_notes_frequencyesnf_esn_id
_435.encounters_stored_notes_patients_frequencyesnpf_esn_id
_436.encounters_stored_notes_accessesna_esn_id
_436.encounters_stored_notes_frequencyesnf_esn_id
_436.encounters_stored_notes_patients_frequencyesnpf_esn_id
_436_archive_testing.encounters_stored_notes_accessesna_esn_id
_436_archive_testing.encounters_stored_notes_frequencyesnf_esn_id
_436_archive_testing.encounters_stored_notes_patients_frequencyesnpf_esn_id
_437.encounters_stored_notes_accessesna_esn_id
_437.encounters_stored_notes_frequencyesnf_esn_id
_437.encounters_stored_notes_patients_frequencyesnpf_esn_id
_8.encounters_stored_notes_accessesna_esn_id
_8.encounters_stored_notes_frequencyesnf_esn_id
_8.encounters_stored_notes_patients_frequencyesnpf_esn_id
_81.encounters_stored_notes_accessesna_esn_id
_81.encounters_stored_notes_frequencyesnf_esn_id
_81.encounters_stored_notes_patients_frequencyesnpf_esn_id
_999.encounters_stored_notes_accessesna_esn_id
_999.encounters_stored_notes_frequencyesnf_esn_id
_999.encounters_stored_notes_patients_frequencyesnpf_esn_id