common.races

Field	Type	Null	Default	Key	Extra	Comment
rac_id	int(11)	NO		PRI	auto_increment
rac_code	varchar(6)	NO
rac_hier_code	varchar(30)	NO				CDC Hierarchical Code
rac_parent_rac_id	int(11)	NO	0			Grouped ethnicity id
rac_desc	varchar(50)	NO
rac_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
rac_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

rac_id

Table	Column
_1.clinical_interventions_patients_races_map	ciprm_rac_id
_1.encounters_patients_races_map	eprm_rac_id
_1.hl7_accessions	acc_rac_id
_1.patients_races_map	prm_rac_id
_1188.clinical_interventions_patients_races_map	ciprm_rac_id
_1188.encounters_patients_races_map	eprm_rac_id
_1188.hl7_accessions	acc_rac_id
_1188.patients_races_map	prm_rac_id
_1218.clinical_interventions_patients_races_map	ciprm_rac_id
_1218.encounters_patients_races_map	eprm_rac_id
_1218.hl7_accessions	acc_rac_id
_1218.patients_races_map	prm_rac_id
_1548.clinical_interventions_patients_races_map	ciprm_rac_id
_1548.encounters_patients_races_map	eprm_rac_id
_1548.hl7_accessions	acc_rac_id
_1548.patients_races_map	prm_rac_id
_435.clinical_interventions_patients_races_map	ciprm_rac_id
_435.encounters_patients_races_map	eprm_rac_id
_435.hl7_accessions	acc_rac_id
_435.patients_races_map	prm_rac_id
_436.clinical_interventions_patients_races_map	ciprm_rac_id
_436.encounters_patients_races_map	eprm_rac_id
_436.hl7_accessions	acc_rac_id
_436.patients_races_map	prm_rac_id
_436_archive_testing.clinical_interventions_patients_races_map	ciprm_rac_id
_436_archive_testing.encounters_patients_races_map	eprm_rac_id
_436_archive_testing.hl7_accessions	acc_rac_id
_436_archive_testing.patients_races_map	prm_rac_id
_437.clinical_interventions_patients_races_map	ciprm_rac_id
_437.encounters_patients_races_map	eprm_rac_id
_437.hl7_accessions	acc_rac_id
_437.patients_races_map	prm_rac_id
_8.clinical_interventions_patients_races_map	ciprm_rac_id
_8.encounters_patients_races_map	eprm_rac_id
_8.hl7_accessions	acc_rac_id
_8.patients_races_map	prm_rac_id
_81.clinical_interventions_patients_races_map	ciprm_rac_id
_81.encounters_patients_races_map	eprm_rac_id
_81.hl7_accessions	acc_rac_id
_81.patients_races_map	prm_rac_id
_999.clinical_interventions_patients_races_map	ciprm_rac_id
_999.encounters_patients_races_map	eprm_rac_id
_999.hl7_accessions	acc_rac_id
_999.patients_races_map	prm_rac_id