_999.donors

Field Type Null Default Key Extra Comment
don_id int(11) NO PRI auto_increment
don_cus_id int(11) NO 0 MUL
don_cli_id int(11) NO 0 MUL
don_pid varchar(40) NO MUL
don_pid_alt varchar(40) NO MUL
don_fname varchar(20) NO MUL
don_mname varchar(20) NO
don_lname varchar(20) NO MUL
don_dob varchar(8) NO
don_phone varchar(20) NO
don_employer varchar(20) NO
don_modified datetime YES CURRENT_TIMESTAMP
don_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
don_id
TableColumn
_1.ancpdfsancpdf_don_id
_1.auditsaud_don_id
_1.audits_archiveaud_don_id
_1.cpoe_responsescpoe_res_don_id
_1.hl7_accessionsacc_don_id
_1.radiology_resultsrad_res_don_id
_1188.ancpdfsancpdf_don_id
_1188.auditsaud_don_id
_1188.audits_archiveaud_don_id
_1188.cpoe_responsescpoe_res_don_id
_1188.hl7_accessionsacc_don_id
_1188.radiology_resultsrad_res_don_id
_1218.ancpdfsancpdf_don_id
_1218.auditsaud_don_id
_1218.audits_archiveaud_don_id
_1218.cpoe_responsescpoe_res_don_id
_1218.hl7_accessionsacc_don_id
_1218.radiology_resultsrad_res_don_id
_1548.ancpdfsancpdf_don_id
_1548.auditsaud_don_id
_1548.audits_archiveaud_don_id
_1548.cpoe_responsescpoe_res_don_id
_1548.hl7_accessionsacc_don_id
_1548.radiology_resultsrad_res_don_id
_435.ancpdfsancpdf_don_id
_435.auditsaud_don_id
_435.audits_archiveaud_don_id
_435.cpoe_responsescpoe_res_don_id
_435.hl7_accessionsacc_don_id
_435.radiology_resultsrad_res_don_id
_436.ancpdfsancpdf_don_id
_436.auditsaud_don_id
_436.audits_archiveaud_don_id
_436.cpoe_responsescpoe_res_don_id
_436.hl7_accessionsacc_don_id
_436.radiology_resultsrad_res_don_id
_436_archive_testing.ancpdfsancpdf_don_id
_436_archive_testing.auditsaud_don_id
_436_archive_testing.audits_archiveaud_don_id
_436_archive_testing.cpoe_responsescpoe_res_don_id
_436_archive_testing.hl7_accessionsacc_don_id
_436_archive_testing.radiology_resultsrad_res_don_id
_437.ancpdfsancpdf_don_id
_437.auditsaud_don_id
_437.audits_archiveaud_don_id
_437.cpoe_responsescpoe_res_don_id
_437.hl7_accessionsacc_don_id
_437.radiology_resultsrad_res_don_id
_8.ancpdfsancpdf_don_id
_8.auditsaud_don_id
_8.audits_archiveaud_don_id
_8.cpoe_responsescpoe_res_don_id
_8.hl7_accessionsacc_don_id
_8.radiology_resultsrad_res_don_id
_81.ancpdfsancpdf_don_id
_81.auditsaud_don_id
_81.audits_archiveaud_don_id
_81.cpoe_responsescpoe_res_don_id
_81.hl7_accessionsacc_don_id
_81.radiology_resultsrad_res_don_id
_999.ancpdfsancpdf_don_id
_999.auditsaud_don_id
_999.audits_archiveaud_don_id
_999.cpoe_responsescpoe_res_don_id
_999.hl7_accessionsacc_don_id
_999.radiology_resultsrad_res_don_id
common.ahi_auditsaud_don_id