aurora_standard.chxfarcd

Field Type Null Default Key Extra Comment
visit_no int(11) YES
req_seq smallint(6) YES
seq_no smallint(6) YES
film_archive varchar(20) YES
line_no smallint(6) YES
scan_no smallint(6) YES
images smallint(6) YES
plane varchar(20) YES
comments varchar(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
comments
TableColumn
Loinc.loinc_codeslc_comments
_1.patient_amendmentspa_comments
_1.patients_allergiespalg_comments
_1.patients_medicationspms_erx_comments
_1.patients_reminderspr_comments
_1188.patient_amendmentspa_comments
_1188.patients_allergiespalg_comments
_1188.patients_medicationspms_erx_comments
_1188.patients_reminderspr_comments
_1218.patient_amendmentspa_comments
_1218.patients_allergiespalg_comments
_1218.patients_medicationspms_erx_comments
_1218.patients_reminderspr_comments
_1548.patient_amendmentspa_comments
_1548.patients_allergiespalg_comments
_1548.patients_medicationspms_erx_comments
_1548.patients_reminderspr_comments
_435.patient_amendmentspa_comments
_435.patients_allergiespalg_comments
_435.patients_medicationspms_erx_comments
_435.patients_reminderspr_comments
_436.patient_amendmentspa_comments
_436.patients_allergiespalg_comments
_436.patients_medicationspms_erx_comments
_436.patients_reminderspr_comments
_436_archive_testing.patient_amendmentspa_comments
_436_archive_testing.patients_allergiespalg_comments
_436_archive_testing.patients_medicationspms_erx_comments
_436_archive_testing.patients_reminderspr_comments
_437.patient_amendmentspa_comments
_437.patients_allergiespalg_comments
_437.patients_medicationspms_erx_comments
_437.patients_reminderspr_comments
_8.patient_amendmentspa_comments
_8.patients_allergiespalg_comments
_8.patients_medicationspms_erx_comments
_8.patients_reminderspr_comments
_81.patient_amendmentspa_comments
_81.patients_allergiespalg_comments
_81.patients_medicationspms_erx_comments
_81.patients_reminderspr_comments
_999.patient_amendmentspa_comments
_999.patients_allergiespalg_comments
_999.patients_medicationspms_erx_comments
_999.patients_reminderspr_comments
aurora_standard.cgsiflddf_comments
aurora_standard.chlrescdres_comments
aurora_standard.chpinsrdclass_comments
common.applicantsapp_comments
common.data_import_clients_meta_datadicmd_comments
common.data_import_field_typesdift_comments
common.data_import_fieldsdif_comments
common.leadslea_comments
common.loinc_codeslc_comments
images
TableColumn
ahiWiki.site_statsss_images
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
seq_no
TableColumn
aurora_standard.chmarstarec_seq_no
aurora_standard.chmarstacrec_seq_no
aurora_standard.chmarstairec_seq_no
aurora_standard.chmarstdrec_seq_no
aurora_standard.chmarstdirec_seq_no
aurora_standard.chmarsterec_seq_no
aurora_standard.chmarsthrec_seq_no
aurora_standard.chmarsthirec_seq_no
aurora_standard.chmarstphrec_seq_no
aurora_standard.chmarstpirec_seq_no
aurora_standard.chmarstporec_seq_no
aurora_standard.chmarstpqrec_seq_no
aurora_standard.chmarstprrec_seq_no
aurora_standard.chmarstpsrec_seq_no
aurora_standard.chmarstptrec_seq_no
aurora_standard.chmarstpyrec_seq_no
aurora_standard.chmcostarec_seq_no
aurora_standard.chmcostbrec_seq_no
aurora_standard.chmcostdrec_seq_no
aurora_standard.chmcostrcrec_seq_no
aurora_standard.chmgltcda_seq_no
aurora_standard.chmgltcdb_seq_no
aurora_standard.chmhid4arec_seq_no
aurora_standard.chmhid4brec_seq_no
aurora_standard.chmhid4crec_seq_no
aurora_standard.chmhid4drec_seq_no
aurora_standard.chmhid4grec_seq_no
aurora_standard.chrhhdcclisting_seq_no
aurora_standard.chrhhmprlisting_seq_no
aurora_standard.chrhhndclisting_seq_no
aurora_standard.chrhhndcfirm_seq_no
aurora_standard.chrhhroclisting_seq_no
aurora_standard.chrmndclisting_seq_no
aurora_standard.chrmndcfirm_seq_no
aurora_standard.chxhistdh_seq_no
aurora_standard.chyhistdh_seq_no
aurora_standard.drugclaslisting_seq_no
aurora_standard.formulatlisting_seq_no
aurora_standard.listingslisting_seq_no
aurora_standard.listingsfirm_seq_no
aurora_standard.packagelisting_seq_no
aurora_standard.routeslisting_seq_no
line_no
TableColumn
aurora_standard.chmmbc41service_line_no
aurora_standard.sticstvrrec_line_no
aurora_standard.stmnotednote_line_no
aurora_standard.stmwarrdwarr_line_no
aurora_standard.stoordrdkit_line_no
aurora_standard.stuinvcdinv_line_no
aurora_standard.stuinvcdpo_line_no
aurora_standard.stuordrdorder_line_no
aurora_standard.stuprcheinv_line_no
aurora_standard.sturectdrec_line_no
aurora_standard.sturectdpo_line_no
aurora_standard.sturqstdpo_line_no
aurora_standard.sturqstdref_line_no
aurora_standard.sturtrndret_line_no
aurora_standard.sturtrndpo_line_no
aurora_standard.sturtrndrec_line_no
aurora_standard.sturtrndinv_line_no