aurora_standard.chmabstd

Field Type Null Default Key Extra Comment
xtra_no bigint(20) unsigned NO PRI auto_increment
accident_1 varchar(45) YES
accident_2 varchar(45) YES
accident_3 varchar(45) YES
date_1 date YES
date_2 date YES
date_3 date YES
code_1 varchar(3) YES
code_2 varchar(3) YES
code_3 varchar(3) YES
mca_1 varchar(1) YES
mca_2 varchar(1) YES
mca_3 varchar(1) YES
mca_4 varchar(1) YES
mca_5 varchar(1) YES
mca_6 varchar(1) YES
mca_7 varchar(1) YES
mca_8 varchar(1) YES
mca_9 varchar(1) YES
mca_10 varchar(1) YES
mca_11 varchar(1) YES
mca_12 varchar(40) YES

References

Local Column References
code_1
TableColumn
aurora_standard.chm1500rdiag_code_1
aurora_standard.chmbc10dicd_code_1
aurora_standard.chmbcdxdicd_code_1
aurora_standard.chmcostrcproc_code_1
aurora_standard.chmhid4cproc_code_1
aurora_standard.chmhidiaproc_code_1
aurora_standard.chmutah3proc_code_1
aurora_standard.chmutahtproc_code_1
aurora_standard.tmpmrrptproc_code_1
code_2
TableColumn
aurora_standard.chm1500rdiag_code_2
aurora_standard.chmbc10dicd_code_2
aurora_standard.chmbcdxdicd_code_2
aurora_standard.chmcostrcproc_code_2
aurora_standard.chmhid4cproc_code_2
aurora_standard.chmhidiaproc_code_2
aurora_standard.chmutah3proc_code_2
aurora_standard.chmutahtproc_code_2
aurora_standard.tmpmrrptproc_code_2
code_3
TableColumn
aurora_standard.chm1500rdiag_code_3
aurora_standard.chmbc10dicd_code_3
aurora_standard.chmbcdxdicd_code_3
aurora_standard.chmcostrcproc_code_3
aurora_standard.chmhid4cproc_code_3
aurora_standard.chmhidiaproc_code_3
aurora_standard.chmutah3proc_code_3
aurora_standard.chmutahtproc_code_3
aurora_standard.tmpmrrptproc_code_3
date_1
TableColumn
aurora_standard.chmcostrcproc_date_1
aurora_standard.chmhid4cproc_date_1
aurora_standard.chmhidiaproc_date_1
aurora_standard.chmutah3proc_date_1
date_2
TableColumn
aurora_standard.chmcostrcproc_date_2
aurora_standard.chmhid4cproc_date_2
aurora_standard.chmhidiaproc_date_2
aurora_standard.chmutah3proc_date_2
date_3
TableColumn
aurora_standard.chmcostrcproc_date_3
aurora_standard.chmhid4cproc_date_3
aurora_standard.chmhidiaproc_date_3
aurora_standard.chmutah3proc_date_3