test_report_sampling

PK,FK1 facility_idPK,FK1 report_idPK sampling_port_id

point_differpoint_descriptionbefore_SO2_devicepoint_orientationnormal_bypass_percenttesting_bypass_percentfg_fraction

Hg_emission_limits

PK,FK1 facility_idPK stack_id

Hg_emlimit_1Hg_emlimit_units_1Hg_emlimit_2Hg_emlimit_units_2Hg_emlimit_3Hg_emlimit_units_3Hg_emlimit_4Hg_emlimit_units_4

fuel_shipment_sam

PK,FK1 facility_idPK,FK1 shipment_idPK sample_id

amount_fuelamount_fuel_total_sulfurash_contentheating_valueheating_unitschlorinechlorine_unitsfluorinefluorine_unitsdata_provideddata_other_ssupplier_typesupplier_namsupplier_addrsupplier_citysupplier_statesupplier_ziplab_namelab_addresslab_citylab_statelab_zipanalysis_copi

cem_data_pollutants

PK,FK1 facility_idPK,FK1 time_periodPK pollutant_name

control_technologies

PK,FK1 facility_idPK,FK1 configuration_idPK,FK1 component_idPK control_id

project_titleproject_typevendor_namevendor_contactvendor_phonevendor_addressvendor_cityvendor_statevendor_zipactual_start_dateprojected_start_dateend_datesorbentchemical_additiveinjection_pointHAP_emission_reductionHAP_emission_rateHAP_emission_rate_unitsHAP_achieved_reductionHAP_achieved_rateHAP_achieved_rate_unitsfeed_ratefeed_rate_units

configuration_components

PK,FK1 facility_idPK,FK1 configuration_idPK component_id

ordercomponent_typeport_near

test_reports

PK,FK1 facility_idPK report_id

report_typeother_typereport_descriptionreport_begin_datereport_end_datebefore_controlduring_deviationdeviation_reports

configurations

PK,FK1 facility_idPK configuration_id

misc_control_configurations

PK,FK1,FK2 facility_idPK,FK1 misc_control_idPK,FK2 configuration_id

configuration_pollutants

PK,FK1 facility_idPK,FK1 configuration_idPK pollutant_name

permit_type_1emlimit_1emlimit_units_1avg_period_1emlimit_2emlimit_units_2avg_period_2emlimit_3emlimit_units_3avg_period_3emlimit_4emlimit_units_4avg_period_4emlimit_5emlimit_units_5avg_period_5emlimit_detailstest_methodemrateemrate_unitsguarantee_levellevel_explainreq_monitoringreq_recordkeepingreq_reporting

control_coal_ranks

PK,FK1 facility_idPK,FK1 configuration_idPK,FK1 component_idPK,FK1 control_idPK coal_type

misc_controls

PK,FK1 facility_idPK misc_control_id

control_description

test_report_configurations

PK,FK1,FK2 facility_idPK,FK2 report_idPK,FK1 configuration_id

facility_units

PK,FK1 facility_idPK unit_id

test_report_fuel_types

PK,FK1 facility_idPK,FK1 report_idPK,FK1 fuel_idPK fuel_type

percentage_massvolpercentage_btuother_type

sampling_runs

PK,FK1 facility_idPK,FK1 report_idPK,FK1 sampling_port_idPK run_id

start_datetimeend_datetimeunit_loadnet_generationfg_moisture_contentfg_flow_ratefg_flow_rate_unitsstandard_temperaturestandard_pressurenormal_temperaturenormal_pressurefg_oxygen_contentfg_CO2_contentfg_temperaturefg_pressureHg_loitest_methodrun_commentsfuel_idfuel_unit_loadfuel_flow_ratefuel_ashfuel_heating_valuefuel_sulfur

sampling_run_fuel

PK,FK1 facility_idPK,FK1 report_idPK,FK1 sampling_port_idPK,FK1 run_idPK fuel_pollutant

fuel_concfuel_conc_unitsfuel_conc_NDfuel_conc_MDL

control_costs

PK,FK1 facility_idPK,FK1 configuration_idPK,FK1 component_idPK,FK1 control_id

boiler_retrofitboiler_new_installtotal_capital_investmenttotal_operating_costsbase_yearCBI

unit_boilers

PK,FK1 facility_idPK,FK1 unit_idPK boiler_id

fuel_sample_polluta

PK,FK1 facility_idPK,FK1 shipment_idPK,FK1 sample_idPK fuel_pollutant

pollutant_conpollutant_conpollutant_conpollutant_con

facility_information

PK facility_id

utility_codelegal_owner_namelegal_operator_namelegal_address_typelegal_addresslegal_citylegal_statelegal_zipplant_namephysical_addressphysical_cityphysical_statephysical_zipmailing_addressmailing_citymailing_statemailing_zipRFA_small_entityff_fired_coalff_fired_oilff_fired_ngasff_fired_petcokeff_fired_otherff_permitted_coalff_permitted_oilff_permitted_ngasff_permitted_petcokeff_permitted_otherdeviation_reportingcontinuous_emissionscem_providedfacility_note

facility_oil_utilized

PK,FK1 facility_idPK oil_type

percentage_volumepercentage_btuother_type

test_report_fuels

PK,FK1 facility_idPK,FK1 report_idPK fuel_id

sampling_run_pollutants

PK,FK1 facility_idPK,FK1 report_idPK,FK1 sampling_port_idPK,FK1 run_idPK pollutant_name

concconc_unitsconc_NDconc_MDLconc2conc2_unitsemission_rateemission_rate_unitsemission_rate_NDemission_rate_MDLemission_factoremission_factor_unitsemission_factor_NDemission_factor_MDLrun_pollutant_comment

fuel_shipments

PK,FK1 facility_idPK shipment_id

shipment_damount_recamount_unifuel_typestate_countother_countcountycoal_seamshipment_m

fuel_shipment_configurations

PK,FK1,FK2 facility_idPK,FK1 shipment_idPK,FK2 configuration_id

control_pollutants

PK,FK1 facility_idPK,FK1 configuration_idPK,FK1 component_idPK,FK1 control_idPK pollutant_name

cem_data

PK,FK1 facility_idPK time_period

cem_period_description

EU MACT ICR Part I & II Entity Relationship Diagram (ERD)
Parent Table

PK ParentKey

OtherField1

OtherField2 Child Table 1

PK,FK1 ParentKey

PK Child1Key

I1 ChildOther1

Primary Key(s) are at top of table, 

above the line.

PK indicates Primary Key

FK indicates Foreign Key

Child Table 2

PK Child2Key

FK1 ParentKey

Arrow Points to parent table

FK – Foreign Key (field is linked to a key field in another table)

IE – Field is part of an index 

Legend for Entity Relationship Diagram

Field Attributes