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
products
- Key — Primary key — NOT NULL
- id — Foreign key → factories.id — NOT NULL
unit
- unit_id (Key) — Primary key — NOT NULL