NET_ZERO
Tables (8)
audit_logs
- audit_id — CHAR(36)
- scenario_id — CHAR(36) — Foreign key → scenarios.scenario_id — NOT NULL
- actor — VARCHAR(200)
- action — VARCHAR(50) — NOT NULL
- calculation_version — VARCHAR(50) — NOT NULL
- input_json — LONGTEXT
- warnings_json — LONGTEXT
- created_at — DATETIME — NOT NULL
- INDEX — idx_audit_scenario
- INDEX — idx_audit_created_at
inventory_snapshots
- inventory_id — CHAR(36)
- scenario_id — CHAR(36) — Foreign key → scenarios.scenario_id — NOT NULL
- scope_mode — VARCHAR(20) — NOT NULL
- base_year — INT — NOT NULL
- scope1_tco2e — DECIMAL(18,3) — NOT NULL
- scope2_tco2e — DECIMAL(18,3) — NOT NULL
- scope3_tco2e — DECIMAL(18,3)
- created_at — DATETIME — NOT NULL
measures
- measure_id — CHAR(36)
- scenario_id — CHAR(36) — Foreign key → scenarios.scenario_id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- start_year — INT — NOT NULL
- end_year — INT
- reduction_mode — ENUM('ABSOLUTE','PERCENT') — NOT NULL
- annual_reduction_tco2e — DECIMAL(18,3)
- reduction_pct — DECIMAL(6,3)
- max_reduction_tco2e — DECIMAL(18,3)
- cost — DECIMAL(18,2)
- created_at — DATETIME — NOT NULL
- INDEX — idx_measures_scenario
- INDEX — idx_measures_year
offsets_policy
- policy_id — CHAR(36)
- scenario_id — CHAR(36) — Foreign key → scenarios.scenario_id — NOT NULL
- enabled — TINYINT(1) — NOT NULL
- cap_pct_of_residual — DECIMAL(6,3) — NOT NULL
- mode — ENUM('AUTO','PLANNED') — NOT NULL
- unit_cost — DECIMAL(18,2)
- created_at — DATETIME — NOT NULL
projects
- project_id — CHAR(36)
- name — VARCHAR(200) — NOT NULL
- org_name — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_projects_name
roadmap_results_yearly
- result_id — BIGINT — NOT NULL
- scenario_id — CHAR(36) — Foreign key → scenarios.scenario_id — NOT NULL
- year — INT — NOT NULL
- bau_emissions — DECIMAL(18,3) — NOT NULL
- goal_emissions — DECIMAL(18,3)
- measures_reduction — DECIMAL(18,3)
- reduced_emissions — DECIMAL(18,3)
- removals_offsets — DECIMAL(18,3)
- net_emissions — DECIMAL(18,3)
- warnings_json — LONGTEXT
- created_at — DATETIME — NOT NULL
- INDEX — idx_results_scenario
- INDEX — idx_results_year
scenarios
- scenario_id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.project_id — NOT NULL
- scenario_name — VARCHAR(200) — NOT NULL
- method — ENUM('BAU','ACA') — NOT NULL
- sbti_enabled — TINYINT(1) — NOT NULL
- base_year — INT — NOT NULL
- target_year — INT — NOT NULL
- bau_growth_rate_pct — DECIMAL(6,3) — NOT NULL
- calculation_version — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_scenarios_project
- INDEX — idx_scenarios_method
- INDEX — idx_scenarios_base_year
targets
- target_id — CHAR(36)
- scenario_id — CHAR(36) — Foreign key → scenarios.scenario_id — NOT NULL
- target_type — ENUM('NEAR_TERM','NET_ZERO','MILESTONE') — NOT NULL
- target_year — INT — NOT NULL
- reduction_pct_vs_base — DECIMAL(6,3)
- absolute_target_tco2e — DECIMAL(18,3)
- created_at — DATETIME — NOT NULL
- INDEX — idx_targets_scenario
- INDEX — idx_targets_type_year