예산설명자료

테이블 (10)

budget_amounts

  • id — serial4 — 기본 키 — NOT NULL
  • project_id — int4 — 외래 키 → budget_projects.id — NOT NULL
  • fiscal_year — int2 — NOT NULL
  • amount_type — varchar(30) — NOT NULL
  • amount_value — int8
  • change_rate — numeric(8, 2)

budget_calculation_basis

  • id — serial4 — 기본 키 — NOT NULL
  • project_id — int4 — 외래 키 → budget_projects.id — NOT NULL
  • composite_code — varchar(30)
  • sub_project_name — text
  • sub_project_index — int2
  • sub_category_name — text
  • sub_category_index — int2
  • budget_prev_year — int8
  • budget_current_year — int8
  • change_amount — int8
  • change_direction — varchar(5)
  • detail_text — text
  • detail_items — jsonb
  • sort_order — int2
  • created_at — timestamptz

budget_documents

  • id — serial4 — 기본 키 — NOT NULL
  • budget_year — int2 — NOT NULL
  • document_type — varchar(20) — NOT NULL
  • ministry — varchar(100) — NOT NULL
  • account_type — varchar(20) — NOT NULL
  • fund_name — varchar(100)
  • file_name — varchar(255) — NOT NULL
  • file_path — text — NOT NULL
  • total_sections — int2
  • project_count — int4
  • status — varchar(30)
  • processed_at — timestamptz
  • created_at — timestamptz

budget_functional_items

  • id — serial4 — 기본 키 — NOT NULL
  • project_id — int4 — 외래 키 → budget_projects.id — NOT NULL
  • composite_code — varchar(30)
  • item_name — text — NOT NULL
  • is_total — bool
  • budget_2024 — int8
  • budget_2025 — int8
  • budget_2026 — int8
  • raw_amounts — jsonb
  • sort_order — int2
  • created_at — timestamptz

budget_projects

  • id — serial4 — 기본 키 — NOT NULL
  • document_id — int4 — 외래 키 → budget_documents.id — NOT NULL
  • full_code — varchar(20) — NOT NULL
  • composite_code — varchar(40)
  • program_code — varchar(10)
  • program_name — varchar(200)
  • unit_project_code — varchar(10)
  • unit_project_name — varchar(200)
  • detail_project_code — varchar(10)
  • detail_project_name — varchar(200)
  • sector — varchar(100)
  • sector_code — varchar(10)
  • sub_sector — varchar(100)
  • sub_sector_code — varchar(10)
  • project_status — varchar(10)
  • support_types — _text
  • responsible_dept — varchar(100)
  • responsible_division — varchar(100)
  • implementing_agency — varchar(200)
  • priority_category — varchar(10)
  • priority_reason — text
  • tags — _text
  • content_raw — text
  • history_raw — text
  • effect_raw — text
  • raw_text — text
  • section_file — varchar(255)
  • purpose_summary — text
  • legal_basis — _text
  • history_summary — text
  • expected_effect — text
  • created_at — timestamptz
  • updated_at — timestamptz

budget_sub_items

  • id — serial4 — 기본 키 — NOT NULL
  • project_id — int4 — 외래 키 → budget_projects.id — NOT NULL
  • sub_item_name — varchar(300) — NOT NULL
  • sort_order — int2
  • budget_2024 — int8
  • budget_2025_initial — int8
  • budget_2025_revised — int8
  • budget_2026 — int8

performance_indicators

  • id — serial4 — 기본 키 — NOT NULL
  • project_id — int4 — 외래 키 → budget_projects.id — NOT NULL
  • indicator_name — varchar(300) — NOT NULL
  • unit — varchar(20)
  • target_values — jsonb
  • actual_values — jsonb
  • measurement_method — text
  • sort_order — int2

processing_logs

  • id — serial4 — 기본 키 — NOT NULL
  • document_id — int4 — 외래 키 → budget_documents.id
  • project_id — int4 — 외래 키 → budget_projects.id
  • step — varchar(50) — NOT NULL
  • status — varchar(20) — NOT NULL
  • message — text
  • details — jsonb
  • created_at — timestamptz

project_contacts

  • id — serial4 — 기본 키 — NOT NULL
  • project_id — int4 — 외래 키 → budget_projects.id — NOT NULL
  • composite_code — varchar(30)
  • sub_project_name — text
  • organization — text
  • department — text
  • role — varchar(20)
  • name — varchar(100)
  • phone — varchar(30)
  • sort_order — int2
  • created_at — timestamptz

project_text_chunks

  • id — serial4 — 기본 키 — NOT NULL
  • project_id — int4 — 외래 키 → budget_projects.id — NOT NULL
  • chunk_type — varchar(20) — NOT NULL
  • chunk_text — text — NOT NULL
  • embedding — public.vector
  • metadata — jsonb
  • created_at — timestamptz