_1218.encounters_stored_notes

Field Type Null Default Key Extra Comment
esn_id int(11) NO PRI auto_increment
esn_cus_id int(11) NO MUL
esn_cli_id int(11) NO MUL
esn_phy_id int(11) NO MUL
esn_esnc_id int(11) NO MUL
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 char(1) NO
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