Table Relationships Registry

Below is the automatically generated list of table relationships used across ZAYAZ.

Legend: references many_to_one

From table	To table	FK column	PK column	Cardinality	Relationship	Comment
zyz_mice_fume_input	dim_countries	iso_cc_id	iso_cc_id	many_to_one	references	Each PEF input row maps to exactly one country via ISO surrogate key.
zyz_mice_fume_input	dim_nace	nace_code	nace_code	many_to_one	references	Input activity is classified by one NACE code.
zyz_mice_fume_input	ref_efdb	ef_id	ef_id	many_to_one	references	Each input row selects one emission factor from EFDB.
zyz_mice_fume_input	dim_units	input_unit_code	unit_code	many_to_one	references	Raw quantity is expressed in one unit of measure.
zyz_mice_fume_result	dim_units	result_unit_code	unit_code	many_to_one	references	Resulting footprint is expressed in a normalized unit (e.g. kg CO2e).
zyz_mice_fume_result	dim_countries	iso_cc_id	iso_cc_id	many_to_one	references	Output row retains the originating country context.
fact_pef_run	zyz_mice_fume_input	input_row_id	row_id	many_to_one	references	Fact table links PEF runs to their original micro-engine input rows.
fact_pef_run	zyz_mice_fume_result	result_row_id	row_id	many_to_one	references	Fact table links PEF runs to their computed results.
ref_compute_method_registry		—	—	—	—	—