재정성과ERD

테이블 (19)

doc_budget_values

  • budget_value_id — UUID — 기본 키 — NOT NULL
  • program_id — UUID — 외래 키 → doc_programs.program_id
  • unit_project_id — UUID — 외래 키 → doc_unit_projects.unit_project_id
  • detail_project_id — UUID — 외래 키 → doc_detail_projects.detail_project_id
  • source_type — SMALLINT
  • budget_yr — CHAR(4)
  • budget_amt — NUMERIC
  • source_page_seq — INT
  • reg_dt — TIMESTAMPTZ

doc_detail_projects

  • detail_project_id — UUID — 기본 키 — NOT NULL
  • unit_project_id — UUID — 외래 키 → doc_unit_projects.unit_project_id
  • detail_project_cd — VARCHAR(30)
  • detail_project_nm — VARCHAR(500)
  • subsidy_yn — BOOLEAN
  • reg_dt — TIMESTAMPTZ

doc_elements

  • elem_id — UUID — 기본 키 — NOT NULL
  • page_id — UUID — 외래 키 → doc_pages.page_id
  • doc_id — UUID
  • crtr_yr — CHAR(4)
  • elmn_type_cd — INT
  • elem_seq — INT
  • elmn_nm — VARCHAR(100)
  • elmn_cn — TEXT
  • elmn_file_path — VARCHAR(500)
  • elmn_bbox — INTEGER
  • elmn_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

doc_kpi_values

  • kpi_id — UUID — 기본 키 — NOT NULL
  • program_id — UUID — 외래 키 → doc_programs.program_id
  • detail_project_id — UUID — 외래 키 → doc_detail_projects.detail_project_id
  • kpi_nm — VARCHAR(100)
  • source_type — SMALLINT
  • kpi_yr — CHAR(4)
  • value_type — SMALLINT
  • kpi_value — NUMERIC
  • wght — NUMERIC(10,4)
  • measure_cn — TEXT
  • data_source_cn — TEXT
  • source_page_seq — INT
  • reg_dt — TIMESTAMPTZ

doc_pages

  • page_id — UUID — 기본 키 — NOT NULL
  • doc_id — UUID — 외래 키 → documents.doc_id
  • crtr_yr — CHAR(4)
  • page_no — INT
  • page_mark — VARCHAR(30)
  • page_cn — TEXT
  • page_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

doc_programs

  • program_id — UUID — 기본 키 — NOT NULL
  • doc_id — UUID — 외래 키 → documents.doc_id
  • strtg_goal — VARCHAR(500)
  • strtg_seq — INT
  • program_nm — VARCHAR(500)
  • program_goal — VARCHAR(500)
  • program_seq — INT
  • reg_dt — TIMESTAMPTZ

doc_raw_contents

  • doc_id — UUID — 외래 키 → documents.doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • doc_orgtxt_cn — TEXT
  • reg_dt — TIMESTAMPTZ

doc_section_pages

  • section_id — UUID — 외래 키 → doc_sections.section_id — NOT NULL
  • page_id — UUID — 외래 키 → doc_pages.page_id — NOT NULL
  • section_page_seq — INT

doc_sections

  • section_id — UUID — 기본 키 — NOT NULL
  • doc_id — UUID — 외래 키 → documents.doc_id
  • program_id — UUID
  • crtr_yr — CHAR(4)
  • section_type — SMALLINT
  • section_nm — VARCHAR(300)
  • start_page_no — INT
  • end_page_no — INT
  • section_seq — INT
  • section_ocr_raw — JSONB
  • section_cn — TEXT
  • section_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

doc_unit_projects

  • unit_project_id — UUID — 기본 키 — NOT NULL
  • program_id — UUID — 외래 키 → doc_programs.program_id
  • unit_project_cd — VARCHAR(30)
  • unit_project_nm — VARCHAR(500)
  • reg_dt — TIMESTAMPTZ

documents

  • doc_id — UUID — 기본 키 — NOT NULL
  • org_id — UUID — 외래 키 → organizations.org_id
  • file_nm — VARCHAR(500)
  • crtr_yr — CHAR(4)
  • orgnl_file_path — VARCHAR(500)
  • doc_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

kpi_review_opinions

  • kpi_opinion_id — UUID — 기본 키 — NOT NULL
  • kpi_review_id — UUID — 외래 키 → kpi_reviews.kpi_review_id
  • category_no — INT
  • opinion_cn — TEXT
  • opinion_seq — INT

kpi_reviews

  • kpi_review_id — UUID — 기본 키 — NOT NULL
  • review_id — UUID — 외래 키 → reviews.review_id
  • program_id — UUID
  • kpi_id — UUID
  • program_cd — VARCHAR(50)
  • program_nm — VARCHAR(500)
  • kpi_nm — VARCHAR(500)
  • wght — NUMERIC(5,2)
  • target_value — VARCHAR(100)
  • kpi_field — VARCHAR(20)
  • qlt_qnt_type — VARCHAR(10)
  • kpi_type — VARCHAR(10)

org_histories

  • org_hist_id — UUID — 기본 키 — NOT NULL
  • prev_org_id — UUID — 외래 키 → organizations.org_id
  • next_org_id — UUID — 외래 키 → organizations.org_id
  • change_type — SMALLINT
  • change_date — DATE

organizations

  • org_id — UUID — 기본 키 — NOT NULL
  • org_nm — VARCHAR(300)
  • crtr_yr — CHAR(4)
  • parent_org_id — UUID
  • abolish_yn — SMALLINT

plan_guideline_reviews

  • guide_review_id — UUID — 기본 키 — NOT NULL
  • review_id — UUID — 외래 키 → reviews.review_id
  • kpi_wght_inapt_type — SMALLINT
  • kpi_wght_inapt_detail — TEXT
  • review_item — VARCHAR(20)
  • review_cn — TEXT
  • review_seq — VARCHAR(1000)

program_reviews

  • program_review_id — UUID — 기본 키 — NOT NULL
  • review_id — UUID — 외래 키 → reviews.review_id
  • program_id — UUID
  • program_goal_cn — TEXT
  • selection_review_cn — TEXT
  • guideline_review_cn — TEXT
  • etc_review_cn — TEXT

reviews

  • review_id — UUID — 기본 키 — NOT NULL
  • doc_id — UUID — 외래 키 → documents.doc_id
  • user_id — UUID — 외래 키 → users.user_id
  • status — VARCHAR(20)
  • result_file_nm — VARCHAR(500)
  • result_file_path — VARCHAR(1000)
  • start_dt — TEXT
  • end_dt — TEXT
  • error_cn — TEXT

users

  • user_id — UUID — 기본 키 — NOT NULL
  • org_id — UUID — 외래 키 → organizations.org_id
  • account — VARCHAR(100)
  • user_nm — VARCHAR(100)
  • pw — VARCHAR(255)
  • is_admin — BOOLEAN
  • reg_dt — TIMESTAMPTZ