E-SCOPE

Tables (22)

coefficient_industry_type

  • coefficient_industry_type_id (Key) — Primary key — NOT NULL

companies

  • id — Primary key — NOT NULL
  • id (id2) — Foreign key → companies.id — NOT NULL
  • industry_type_id (Key) — Foreign key → industry_type.industry_type_id — NOT NULL

company_fomula_parameters

  • id (Key) — Primary key — NOT NULL

company_formula

  • company_formula_id (Key) — Primary key — NOT NULL
  • company_id (id) — Foreign key → companies.id — NOT NULL
  • formula_category_id (Key2) — Foreign key → formula_groups.formula_group_id — NOT NULL

disposal_evidences

  • disposal_evidence_id (Key) — Primary key — NOT NULL
  • type (Field) — fixed_fuel, fleet_fuel, ...
  • disposal_id (Field2)

disposal_fixed_fuels

  • id (Key2) — Primary key — NOT NULL
  • facility_id (Key3) — Foreign key → facilities.id — NOT NULL
  • fixed_fuel_id (Key4) — Foreign key → fixed_fuels.fixed_fuel_id — NOT NULL
  • date (Field) — date
  • value (Field2)
  • Field3

disposal_fleet_fuels (CopyOfdisposal_fixed_fuels)

  • id (Key2) — Primary key — NOT NULL
  • facility_id (Key3) — Foreign key → facilities.id — NOT NULL
  • fleet_fuel_id (Key4) — Foreign key → fleet_fuels.id — NOT NULL

esg_goals (factory_goals)

  • id — Foreign key → factories.id — NOT NULL

facilities

  • id (Key) — Primary key — NOT NULL
  • id — Foreign key → factories.id — NOT NULL

factories

  • id — Primary key — NOT NULL
  • id (id2) — Foreign key → companies.id — NOT NULL

fixed_fuel_coefficient

  • fixed_fuel_coefficient_id (Key2) — Primary key — NOT NULL
  • fixed_fuel_id (Key) — Foreign key → fixed_fuels.fixed_fuel_id — NOT NULL
  • coefficient_industry_type_id (Key3) — Foreign key → coefficient_industry_type.coefficient_industry_type_id — NOT NULL
  • value (Field)

fixed_fuels

  • fixed_fuel_id (Key) — Primary key — NOT NULL
  • unit_id (Key2) — Foreign key → unit.unit_id — NOT NULL

fleet_fuels

  • id (Key) — Primary key — NOT NULL

formula_groups

  • formula_group_id (Key) — Primary key — NOT NULL
  • scope (Field)
  • boundary (Field2)
  • group (Field3)

ghg_coefficient

  • id — Foreign key → companies.id — NOT NULL

industry_type

  • industry_type_id (Key) — Primary key — NOT NULL
  • coefficient_industry_type_id (Key2) — Foreign key → coefficient_industry_type.coefficient_industry_type_id — NOT NULL

process_emissions

    products

    • Key — Primary key — NOT NULL
    • id — Foreign key → factories.id — NOT NULL

    steam_electricity

      steam_heat

        unit

        • unit_id (Key) — Primary key — NOT NULL

        waste