ERD_플랫폼_final
테이블 (12)
Accounts
- user_no — INT — NOT NULL
- email — VARCHAR(100) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- user_type — TINYINT
- status — TINYINT
- created_at — DATETIME
Employees
- emp_no — INT — NOT NULL
- user_no — INT — 외래 키 → Accounts.user_no — NOT NULL
- org_id — CHAR(36) — 외래 키 → Organizations.org_id — NOT NULL
- dept_name — VARCHAR(50)
- position — VARCHAR(50)
- permission — TEXT
Inventory_Snapshots
- inventory_id — CHAR(36) — NOT NULL
- P1_netzero_id — CHAR(36) — 외래 키 — NOT NULL — 시나리오와 1:1
- scope1_tco2e — DECIMAL(20, 3) — NOT NULL
- scope2_tco2e — DECIMAL(20, 3) — NOT NULL
- scope3_tco2e — DECIMAL(20, 3)
- base_scope12_emissions_tco2e — DECIMAL(20, 3) — NOT NULL
- base_year_verified — TINYINT(1) — NOT NULL
- evidence_note — TEXT
- created_at — DATETIME — NOT NULL
Measures
- measure_id — CHAR(36) — NOT NULL
- P1_netzero_id — CHAR(36) — 외래 키 — NOT NULL
- scope — ENUM('S1', 'S2') — NOT NULL
- measure_category — VARCHAR(50) — NOT NULL
- measure_name — VARCHAR(200) — NOT NULL
- measure_status — ENUM('ACTIVE', 'CONFIRMED', 'IDEA') — NOT NULL
- start_year — INT — NOT NULL
- end_year — INT
- input_unit — ENUM('TCO2E_YR', 'KWH_YR', 'MWH_YR') — NOT NULL
- input_value — DECIMAL(20, 6) — NOT NULL
- annual_reduction_tco2e — DECIMAL(20, 6)
- calc_basis — ENUM('DIRECT_INPUT', 'GRID_EF', 'CUSTOM_EF') — NOT NULL
- emission_factor_ref_id — CHAR(36)
- data_quality — ENUM('MEASURED', 'ESTIMATED') — NOT NULL
- note — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Offset_Policies
- policy_id — CHAR(36) — NOT NULL
- P1_netzero_id — CHAR(36) — 외래 키 — NOT NULL
- enabled — TINYINT(1) — NOT NULL
- cap_pct_of_residual — DECIMAL(10, 6) — NOT NULL
- mode — ENUM('AUTO_FILL', 'USER_PLAN') — NOT NULL
- created_at — DATETIME — 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
- role — VARCHAR(50)
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) — NOT NULL — 프로젝트 FK
- goal_setting_method — ENUM('FORECASTING', 'BACKCASTING'
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) — 외래 키 — NOT NULL
- year — INT — NOT NULL
- bau_scope1 — DECIMAL(20, 3) — NOT NULL
- bau_scope2 — DECIMAL(20, 3) — NOT NULL
- bau_total — DECIMAL(20, 3) — NOT NULL
- goal_scope1 — DECIMAL(20, 3)
- goal_scope2 — DECIMAL(20, 3)
- goal_total — DECIMAL(20, 3)
- reductions_s1 — DECIMAL(20, 3) — NOT NULL
- reductions_s2 — DECIMAL(20, 3) — NOT NULL
- reductions_total — DECIMAL(20, 3) — NOT NULL
- residual_before_offsets — DECIMAL(20, 3) — NOT NULL
- offsets_applied — DECIMAL(20, 3) — NOT NULL
- net_emissions — DECIMAL(20, 3) — NOT NULL
- gap_to_goal — DECIMAL(20, 3)
- warnings_json — LONGTEXT
- created_at — DATETIME — NOT NULL
Scenario_Audits
- audit_id — BIGINT — NOT NULL
- P1_netzero_id — CHAR(36) — 외래 키 — NOT NULL
- event_type — ENUM('CREATED','UPDATED','CALCULATED','FAILED','DELETED') — NOT NULL
- calculation_version — VARCHAR(50)
- input_json — LONGTEXT
- output_summary_json — LONGTEXT
- warnings_json — LONGTEXT
- created_at — DATETIME — NOT NULL
Targets
- target_id — CHAR(36) — NOT NULL
- P1_netzero_id — CHAR(36) — 외래 키 — NOT NULL
- target_kind — ENUM('SBTI_NEAR', 'SBTI_NETZERO', 'CUSTOM') — NOT NULL
- year — INT — NOT NULL
- target_basis — ENUM('VS_BASE', 'VS_BAU') — NOT NULL
- reduction_pct — DECIMAL(10, 6)
- absolute_emissions_tco2e — DECIMAL(20, 3)
- created_at — DATETIME — NOT NULL