common.contact_imports

Field	Type	Null	Default	Key	Extra
ci_id	int(11)	NO		PRI	auto_increment
ci_name	text	NO
ci_email	text	NO
ci_phone	varchar(20)	NO
ci_organization	text	NO
ci_requested_info	text	NO
ci_area	varchar(40)	NO		MUL
ci_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
ci_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

ci_id

Table	Column
_1.audits	aud_ci_id
_1.audits_archive	aud_ci_id
_1.clinical_interventions_allergies_map	ciam_ci_id
_1.clinical_interventions_coded_attributes	cica_ci_id
_1.clinical_interventions_cpt_codes_map	ciccm_ci_id
_1.clinical_interventions_ethnicities_map	ciem_ci_id
_1.clinical_interventions_groups_map	cigm_ci_id
_1.clinical_interventions_lab_results_map	cilrm_ci_id
_1.clinical_interventions_medications_map	cimm_ci_id
_1.clinical_interventions_patients_races_map	ciprm_ci_id
_1.clinical_interventions_problems_map	cipm_ci_id
_1.clinical_interventions_resources	cir_ci_id
_1.clinical_interventions_review_map	cirm_ci_id
_1.clinical_interventions_test_codes_map	citcm_ci_id
_1.clinical_interventions_users_map	cium_ci_id
_1.clinical_interventions_vitals_map	civm_ci_id
_1188.audits	aud_ci_id
_1188.audits_archive	aud_ci_id
_1188.clinical_interventions_allergies_map	ciam_ci_id
_1188.clinical_interventions_cpt_codes_map	ciccm_ci_id
_1188.clinical_interventions_ethnicities_map	ciem_ci_id
_1188.clinical_interventions_groups_map	cigm_ci_id
_1188.clinical_interventions_lab_results_map	cilrm_ci_id
_1188.clinical_interventions_medications_map	cimm_ci_id
_1188.clinical_interventions_patients_races_map	ciprm_ci_id
_1188.clinical_interventions_problems_map	cipm_ci_id
_1188.clinical_interventions_resources	cir_ci_id
_1188.clinical_interventions_review_map	cirm_ci_id
_1188.clinical_interventions_test_codes_map	citcm_ci_id
_1188.clinical_interventions_users_map	cium_ci_id
_1188.clinical_interventions_vitals_map	civm_ci_id
_1218.audits	aud_ci_id
_1218.audits_archive	aud_ci_id
_1218.clinical_interventions_allergies_map	ciam_ci_id
_1218.clinical_interventions_cpt_codes_map	ciccm_ci_id
_1218.clinical_interventions_ethnicities_map	ciem_ci_id
_1218.clinical_interventions_groups_map	cigm_ci_id
_1218.clinical_interventions_lab_results_map	cilrm_ci_id
_1218.clinical_interventions_medications_map	cimm_ci_id
_1218.clinical_interventions_patients_races_map	ciprm_ci_id
_1218.clinical_interventions_problems_map	cipm_ci_id
_1218.clinical_interventions_resources	cir_ci_id
_1218.clinical_interventions_review_map	cirm_ci_id
_1218.clinical_interventions_test_codes_map	citcm_ci_id
_1218.clinical_interventions_users_map	cium_ci_id
_1218.clinical_interventions_vitals_map	civm_ci_id
_1548.audits	aud_ci_id
_1548.audits_archive	aud_ci_id
_1548.clinical_interventions_allergies_map	ciam_ci_id
_1548.clinical_interventions_coded_attributes	cica_ci_id
_1548.clinical_interventions_cpt_codes_map	ciccm_ci_id
_1548.clinical_interventions_ethnicities_map	ciem_ci_id
_1548.clinical_interventions_groups_map	cigm_ci_id
_1548.clinical_interventions_lab_results_map	cilrm_ci_id
_1548.clinical_interventions_medications_map	cimm_ci_id
_1548.clinical_interventions_patients_races_map	ciprm_ci_id
_1548.clinical_interventions_problems_map	cipm_ci_id
_1548.clinical_interventions_resources	cir_ci_id
_1548.clinical_interventions_review_map	cirm_ci_id
_1548.clinical_interventions_test_codes_map	citcm_ci_id
_1548.clinical_interventions_users_map	cium_ci_id
_1548.clinical_interventions_vitals_map	civm_ci_id
_435.audits	aud_ci_id
_435.audits_archive	aud_ci_id
_435.clinical_interventions_allergies_map	ciam_ci_id
_435.clinical_interventions_coded_attributes	cica_ci_id
_435.clinical_interventions_cpt_codes_map	ciccm_ci_id
_435.clinical_interventions_ethnicities_map	ciem_ci_id
_435.clinical_interventions_groups_map	cigm_ci_id
_435.clinical_interventions_lab_results_map	cilrm_ci_id
_435.clinical_interventions_medications_map	cimm_ci_id
_435.clinical_interventions_patients_races_map	ciprm_ci_id
_435.clinical_interventions_problems_map	cipm_ci_id
_435.clinical_interventions_resources	cir_ci_id
_435.clinical_interventions_review_map	cirm_ci_id
_435.clinical_interventions_test_codes_map	citcm_ci_id
_435.clinical_interventions_users_map	cium_ci_id
_435.clinical_interventions_vitals_map	civm_ci_id
_436.audits	aud_ci_id
_436.audits_archive	aud_ci_id
_436.clinical_interventions_allergies_map	ciam_ci_id
_436.clinical_interventions_coded_attributes	cica_ci_id
_436.clinical_interventions_cpt_codes_map	ciccm_ci_id
_436.clinical_interventions_ethnicities_map	ciem_ci_id
_436.clinical_interventions_groups_map	cigm_ci_id
_436.clinical_interventions_lab_results_map	cilrm_ci_id
_436.clinical_interventions_medications_map	cimm_ci_id
_436.clinical_interventions_patients_races_map	ciprm_ci_id
_436.clinical_interventions_problems_map	cipm_ci_id
_436.clinical_interventions_resources	cir_ci_id
_436.clinical_interventions_review_map	cirm_ci_id
_436.clinical_interventions_test_codes_map	citcm_ci_id
_436.clinical_interventions_users_map	cium_ci_id
_436.clinical_interventions_vitals_map	civm_ci_id
_436_archive_testing.audits	aud_ci_id
_436_archive_testing.audits_archive	aud_ci_id
_436_archive_testing.clinical_interventions_allergies_map	ciam_ci_id
_436_archive_testing.clinical_interventions_coded_attributes	cica_ci_id
_436_archive_testing.clinical_interventions_cpt_codes_map	ciccm_ci_id
_436_archive_testing.clinical_interventions_ethnicities_map	ciem_ci_id
_436_archive_testing.clinical_interventions_groups_map	cigm_ci_id
_436_archive_testing.clinical_interventions_lab_results_map	cilrm_ci_id
_436_archive_testing.clinical_interventions_medications_map	cimm_ci_id
_436_archive_testing.clinical_interventions_patients_races_map	ciprm_ci_id
_436_archive_testing.clinical_interventions_problems_map	cipm_ci_id
_436_archive_testing.clinical_interventions_resources	cir_ci_id
_436_archive_testing.clinical_interventions_review_map	cirm_ci_id
_436_archive_testing.clinical_interventions_test_codes_map	citcm_ci_id
_436_archive_testing.clinical_interventions_users_map	cium_ci_id
_436_archive_testing.clinical_interventions_vitals_map	civm_ci_id
_437.audits	aud_ci_id
_437.audits_archive	aud_ci_id
_437.clinical_interventions_allergies_map	ciam_ci_id
_437.clinical_interventions_coded_attributes	cica_ci_id
_437.clinical_interventions_cpt_codes_map	ciccm_ci_id
_437.clinical_interventions_ethnicities_map	ciem_ci_id
_437.clinical_interventions_groups_map	cigm_ci_id
_437.clinical_interventions_lab_results_map	cilrm_ci_id
_437.clinical_interventions_medications_map	cimm_ci_id
_437.clinical_interventions_patients_races_map	ciprm_ci_id
_437.clinical_interventions_problems_map	cipm_ci_id
_437.clinical_interventions_resources	cir_ci_id
_437.clinical_interventions_review_map	cirm_ci_id
_437.clinical_interventions_test_codes_map	citcm_ci_id
_437.clinical_interventions_users_map	cium_ci_id
_437.clinical_interventions_vitals_map	civm_ci_id
_8.audits	aud_ci_id
_8.audits_archive	aud_ci_id
_8.clinical_interventions_allergies_map	ciam_ci_id
_8.clinical_interventions_coded_attributes	cica_ci_id
_8.clinical_interventions_cpt_codes_map	ciccm_ci_id
_8.clinical_interventions_ethnicities_map	ciem_ci_id
_8.clinical_interventions_groups_map	cigm_ci_id
_8.clinical_interventions_lab_results_map	cilrm_ci_id
_8.clinical_interventions_medications_map	cimm_ci_id
_8.clinical_interventions_patients_races_map	ciprm_ci_id
_8.clinical_interventions_problems_map	cipm_ci_id
_8.clinical_interventions_resources	cir_ci_id
_8.clinical_interventions_review_map	cirm_ci_id
_8.clinical_interventions_test_codes_map	citcm_ci_id
_8.clinical_interventions_users_map	cium_ci_id
_8.clinical_interventions_vitals_map	civm_ci_id
_81.audits	aud_ci_id
_81.audits_archive	aud_ci_id
_81.clinical_interventions_allergies_map	ciam_ci_id
_81.clinical_interventions_cpt_codes_map	ciccm_ci_id
_81.clinical_interventions_ethnicities_map	ciem_ci_id
_81.clinical_interventions_groups_map	cigm_ci_id
_81.clinical_interventions_lab_results_map	cilrm_ci_id
_81.clinical_interventions_medications_map	cimm_ci_id
_81.clinical_interventions_patients_races_map	ciprm_ci_id
_81.clinical_interventions_problems_map	cipm_ci_id
_81.clinical_interventions_resources	cir_ci_id
_81.clinical_interventions_review_map	cirm_ci_id
_81.clinical_interventions_test_codes_map	citcm_ci_id
_81.clinical_interventions_users_map	cium_ci_id
_81.clinical_interventions_vitals_map	civm_ci_id
_999.audits	aud_ci_id
_999.audits_archive	aud_ci_id
_999.clinical_interventions_allergies_map	ciam_ci_id
_999.clinical_interventions_coded_attributes	cica_ci_id
_999.clinical_interventions_cpt_codes_map	ciccm_ci_id
_999.clinical_interventions_ethnicities_map	ciem_ci_id
_999.clinical_interventions_groups_map	cigm_ci_id
_999.clinical_interventions_lab_results_map	cilrm_ci_id
_999.clinical_interventions_medications_map	cimm_ci_id
_999.clinical_interventions_patients_races_map	ciprm_ci_id
_999.clinical_interventions_problems_map	cipm_ci_id
_999.clinical_interventions_resources	cir_ci_id
_999.clinical_interventions_review_map	cirm_ci_id
_999.clinical_interventions_test_codes_map	citcm_ci_id
_999.clinical_interventions_users_map	cium_ci_id
_999.clinical_interventions_vitals_map	civm_ci_id