ESG 플랫폼_정말마지막수정본

테이블 (9)

Accounts

  • user_no — INT — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL

Inventory_Snapshots

  • inventory_id — CHAR(36) — NOT NULL
  • P1_netzero_id — CHAR(36) — 외래 키 → P1_netzero.P1_netzero_id — NOT NULL
  • scope1_tco2e — DECIMAL(20, 3) — NOT NULL
  • scope2_tco2e — DECIMAL(20, 3) — NOT NULL
  • base_scope12_emissions_tco2e — DECIMAL(20, 3) — NOT NULL
  • created_at — DATETIME — NOT NULL

Measures

  • measure_id — CHAR(36) — NOT NULL
  • P1_netzero_id — CHAR(36) — 외래 키 → P1_netzero.P1_netzero_id — NOT NULL
  • measure_name — VARCHAR(200) — NOT NULL
  • start_year — INT — NOT NULL
  • input_value — DECIMAL(20, 6) — NOT NULL

Org_Users

  • mapping_id — INT — NOT NULL
  • user_no — INT — 외래 키 → Accounts.user_no — NOT NULL
  • org_id — CHAR(36) — 외래 키 → Organizations.org_id — NOT NULL

Organizations

  • org_id — CHAR(36) — NOT NULL — 회사 고유 ID (UUID)
  • org_name — VARCHAR(255) — NOT NULL — 회사명
  • business_no — VARCHAR(50)
  • industry — VARCHAR(100)
  • email_main — VARCHAR(100)

P1_netzero

  • P1_netzero_id — CHAR(36) — NOT NULL — 시나리오 ID(UUID)
  • project_id — CHAR(36) — 외래 키 → Projects.project_id — NOT NULL — 프로젝트 FK
  • goal_setting_method — ENUM('FORECASTING', 'BACKCASTING') — NOT NULL
  • base_year — INT — NOT NULL
  • end_year — INT — NOT NULL
  • scope_mode — ENUM('S12_SUM', 'S12_SEPARATE', 'S123') — NOT NULL
  • scope2_method — ENUM('UNKNOWN', 'LOCATION', 'MARKET') — NOT NULL
  • bau_model — ENUM('CAGR') — NOT NULL
  • annual_growth_rate_pct — DECIMAL(10, 6) — NOT NULL
  • sbti_enabled — TINYINT(1) — NOT NULL
  • near_target_year — INT
  • near_reduction_pct_vs_base — DECIMAL(10, 6)
  • netzero_year — INT
  • scenario_status — ENUM('DRAFT', 'CALCULATED', 'FAILED') — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • assumptions_note — TEXT
  • calculation_version — VARCHAR(50) — NOT NULL
  • scenario_input_json — LONGTEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

Projects

  • project_id — CHAR(36) — NOT NULL — 프로젝트 고유 ID(UUID)
  • org_id — CHAR(36) — 외래 키 → Organizations.org_id — NOT NULL — 조직 ID FK
  • name — VARCHAR(200) — NOT NULL — 프로젝트명
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

Roadmap_Results_Yearly

  • result_id — BIGINT — NOT NULL
  • P1_netzero_id — CHAR(36) — 외래 키 → P1_netzero.P1_netzero_id — NOT NULL
  • year — INT — NOT NULL
  • net_emissions — DECIMAL(20, 3) — NOT NULL

Targets

  • target_id — CHAR(36) — NOT NULL
  • P1_netzero_id — CHAR(36) — 외래 키 → P1_netzero.P1_netzero_id — NOT NULL
  • year — INT — NOT NULL
  • reduction_pct — DECIMAL(10, 6)
  • absolute_emissions_tco2e — DECIMAL(20, 3)