정부 사업설명자료 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