common.ethnicities

Field	Type	Null	Default	Key	Extra	Comment
eth_id	int(11)	NO		PRI	auto_increment
eth_code	char(1)	NO
eth_hier_code	varchar(10)	NO				CDC Hierarchical Code
eth_cdc_code	varchar(10)	NO				CDC UID
eth_parent_eth_id	int(11)	NO	0			Grouped ethnicity id
eth_desc	varchar(30)	NO
eth_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
eth_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

eth_id

Table	Column
_1.clinical_interventions	ci_eth_id
_1.clinical_interventions_ethnicities_map	ciem_eth_id
_1.patients	pat_eth_id
_1.patients_ethnicities_map	pem_eth_id
_1188.clinical_interventions	ci_eth_id
_1188.clinical_interventions_ethnicities_map	ciem_eth_id
_1188.patients	pat_eth_id
_1188.patients_ethnicities_map	pem_eth_id
_1218.clinical_interventions	ci_eth_id
_1218.clinical_interventions_ethnicities_map	ciem_eth_id
_1218.patients	pat_eth_id
_1218.patients_ethnicities_map	pem_eth_id
_1548.clinical_interventions	ci_eth_id
_1548.clinical_interventions_ethnicities_map	ciem_eth_id
_1548.patients	pat_eth_id
_1548.patients_ethnicities_map	pem_eth_id
_435.clinical_interventions	ci_eth_id
_435.clinical_interventions_ethnicities_map	ciem_eth_id
_435.patients	pat_eth_id
_435.patients_ethnicities_map	pem_eth_id
_436.clinical_interventions	ci_eth_id
_436.clinical_interventions_ethnicities_map	ciem_eth_id
_436.patients	pat_eth_id
_436.patients_ethnicities_map	pem_eth_id
_436_archive_testing.clinical_interventions	ci_eth_id
_436_archive_testing.clinical_interventions_ethnicities_map	ciem_eth_id
_436_archive_testing.patients	pat_eth_id
_436_archive_testing.patients_ethnicities_map	pem_eth_id
_437.clinical_interventions	ci_eth_id
_437.clinical_interventions_ethnicities_map	ciem_eth_id
_437.patients	pat_eth_id
_437.patients_ethnicities_map	pem_eth_id
_8.clinical_interventions	ci_eth_id
_8.clinical_interventions_ethnicities_map	ciem_eth_id
_8.patients	pat_eth_id
_8.patients_ethnicities_map	pem_eth_id
_81.clinical_interventions	ci_eth_id
_81.clinical_interventions_ethnicities_map	ciem_eth_id
_81.patients	pat_eth_id
_81.patients_ethnicities_map	pem_eth_id
_999.clinical_interventions	ci_eth_id
_999.clinical_interventions_ethnicities_map	ciem_eth_id
_999.patients	pat_eth_id
_999.patients_ethnicities_map	pem_eth_id