정부 사업설명자료 ERD
테이블 (7)
budget_executions
- execution_id — BIGSERIAL — 기본 키 — NOT NULL
- report_id — BIGINT — 외래 키 → project_reports.report_id — NOT NULL
- fiscal_year — INT — NOT NULL
- budget_amount — BIGINT
- revised_budget_amount — BIGINT
- carried_amount — BIGINT
- executed_amount — BIGINT
- disused_amount — BIGINT
- execution_rate — DECIMAL(10,4)
- source_unit — VARCHAR(20)
- major_notes — TEXT
budget_plans
- plan_id — BIGSERIAL — 기본 키 — NOT NULL
- report_id — BIGINT — 외래 키 → project_reports.report_id — NOT NULL
- target_year — INT — NOT NULL
- function_code — VARCHAR(50)
- function_name — VARCHAR(200)
- subproject_code — VARCHAR(50)
- subproject_name — VARCHAR(200)
- budget_item_code — VARCHAR(50)
- budget_item_name — VARCHAR(150)
- budget_stage — VARCHAR(30)
- amount — BIGINT
- amount_raw — VARCHAR(100)
- source_unit — VARCHAR(20)
- plan_type — VARCHAR(30)
- display_order — INT
performance_indicators
- indicator_id — BIGSERIAL — 기본 키 — NOT NULL
- report_id — BIGINT — 외래 키 → project_reports.report_id — NOT NULL
- indicator_name — VARCHAR(300) — NOT NULL
- unit — VARCHAR(50)
- fiscal_year — INT — NOT NULL
- target_value — DECIMAL(20,4)
- achieved_value — DECIMAL(20,4)
- achievement_rate — DECIMAL(10,4)
- target_raw — VARCHAR(150)
- achieved_raw — VARCHAR(150)
- achievement_rate_raw — VARCHAR(150)
- other_achievements — TEXT
project_descriptions
- description_id — BIGSERIAL — 기본 키 — NOT NULL
- report_id — BIGINT — 외래 키 → project_reports.report_id — NOT NULL
- purpose_and_content — TEXT
- legal_basis — TEXT
- progress_history — TEXT
- project_period — TEXT
- project_scale — TEXT
- execution_method — TEXT
- implementing_organization — TEXT
- beneficiary — TEXT
- project_delivery_system — TEXT
- annual_plan_calculation_basis — TEXT
- effect_summary — TEXT
- yearly_achievement_summary — TEXT
- future_expected_effect — TEXT
- feasibility_study_result — TEXT
- total_project_cost_detail — TEXT
- execution_procedure — TEXT
- midterm_financial_plan_summary — TEXT
- external_review_and_measures — TEXT
- future_direction_and_plan — TEXT
- project_evaluation_result — TEXT
- ministry_self_evaluation_result — TEXT
- ministry_suggestion — TEXT
project_managers
- manager_id — BIGSERIAL — 기본 키 — NOT NULL
- report_id — BIGINT — 외래 키 → project_reports.report_id — NOT NULL
- organization_type — VARCHAR(30)
- organization_name — VARCHAR(150)
- department_name — VARCHAR(150)
- manager_name — VARCHAR(50)
- manager_role — VARCHAR(50)
- contact — VARCHAR(50)
- email — VARCHAR(150)
- is_primary — BOOLEAN — NOT NULL
project_reports
- report_id — BIGSERIAL — 기본 키 — NOT NULL
- project_id — BIGINT — 외래 키 → projects.project_id — NOT NULL
- budget_year — INT — NOT NULL
- source_file_name — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
projects
- project_id — BIGSERIAL — 기본 키 — NOT NULL
- project_code — VARCHAR(50) — NOT NULL
- project_name — VARCHAR(200) — NOT NULL
- project_nature — VARCHAR(100)
- support_type — VARCHAR(100)
- support_rate_raw — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL