예산설명자료
테이블 (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