ESG 플랫폼_최최최최수정본
테이블 (10)
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
- scenario_id — CHAR(36) — 외래 키 → Scenarios.scenario_id — NOT NULL
- scope1_2_emissions — DECIMAL(15,2)
Measures
- measure_id — CHAR(36) — NOT NULL
- scenario_id — CHAR(36) — 외래 키 → Scenarios.scenario_id — NOT NULL
- name — VARCHAR(255)
- annual_reduction — DECIMAL(15,2)
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)
Projects
- project_id — CHAR(36) — NOT NULL — 프로젝트 ID
- org_id — CHAR(36) — 외래 키 → Organizations.org_id — NOT NULL
- name — VARCHAR(200) — NOT NULL — 프로젝트명
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — `IDX_projects_created_at`
Roadmap_Details
- detail_id — CHAR(36) — NOT NULL
- scenario_id — CHAR(36) — 외래 키 → Scenarios.scenario_id — NOT NULL
- category — ENUM('Target', 'Measure', 'Offset')
- name — VARCHAR(255)
- target_value — DECIMAL(15,2)
- is_enabled — BOOLEAN
Roadmap_Results_Yearly
- result_id — BIGINT — NOT NULL
- scenario_id — CHAR(36) — 외래 키 → Scenarios.scenario_id — NOT NULL
- year — INT
- net_emissions — DECIMAL(15,2)
Scenarios
- scenario_id — CHAR(36) — NOT NULL
- project_id — CHAR(36) — 외래 키 → Projects.project_id — NOT NULL
- method — ENUM('BAU', 'ACA', 'SBTi')
- base_year — INT
- target_year — INT
- annual_growth_rate — DECIMAL(10, 4)
- calculation_version — VARCHAR(50)