1

Tables (31)

guideline_documents

  • guideline_doc_id — UUID — Primary key — NOT NULL
  • org_id — UUID — Foreign key → organizations.org_id
  • file_nm — VARCHAR(500)
  • crtr_yr — CHAR(4)
  • guideline_type — SMALLINT
  • orgnl_file_path — VARCHAR(500)
  • doc_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

guideline_elements

  • elem_id — UUID — Primary key — NOT NULL
  • page_id — UUID — Foreign key → guideline_pages.page_id — NOT NULL
  • guideline_doc_id — UUID — Foreign key → guideline_documents.guideline_doc_id — NOT NULL
  • 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

guideline_pages

  • page_id — UUID — Primary key — NOT NULL
  • guideline_doc_id — UUID — Foreign key → guideline_documents.guideline_doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • page_no — INT
  • page_mark — VARCHAR(30)
  • page_cn — TEXT
  • page_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

guideline_raw_contents

  • guideline_doc_id — UUID — Foreign key → guideline_documents.guideline_doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • doc_orgtxt_cn — TEXT
  • reg_dt — TIMESTAMPTZ

guideline_section_pages

  • section_id — UUID — Foreign key → guideline_sections.section_id — NOT NULL
  • page_id — UUID — Foreign key → guideline_pages.page_id — NOT NULL
  • section_page_seq — INT

guideline_sections

  • section_id — UUID — Primary key — NOT NULL
  • guideline_doc_id — UUID — Foreign key → guideline_documents.guideline_doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • section_type — SMALLINT
  • section_nm — VARCHAR(300)
  • section_seq — INT
  • section_ocr_raw — JSONB
  • section_cn — TEXT
  • section_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

kpi_review_opinions

  • kpi_opinion_id — UUID — Primary key — NOT NULL
  • kpi_review_id — UUID — Foreign key → kpi_reviews.kpi_review_id — NOT NULL
  • category_no — INT
  • opinion_cn — TEXT
  • opinion_seq — INT

kpi_reviews

  • kpi_review_id — UUID — Primary key — NOT NULL
  • review_id — UUID — Foreign key → reviews.review_id — NOT NULL
  • program_id — UUID — Foreign key → plan_programs.program_id — NOT NULL
  • kpi_id — UUID — Foreign key → plan_kpi_values.kpi_id — NOT NULL
  • 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 — Primary key — NOT NULL
  • prev_org_id — UUID — Foreign key → organizations.org_id
  • next_org_id — UUID — Foreign key → organizations.org_id
  • change_type — SMALLINT
  • change_date — DATE

organizations

  • org_id — UUID — Primary key — NOT NULL
  • org_nm — VARCHAR(300) — NOT NULL
  • crtr_yr — CHAR(4)
  • parent_org_id — UUID — Foreign key → organizations.org_id
  • abolish_yn — SMALLINT

plan_budget_values

  • budget_value_id — UUID — Primary key — NOT NULL
  • program_id — UUID — Foreign key → plan_programs.program_id — NOT NULL
  • unit_project_id — UUID — Foreign key → plan_unit_projects.unit_project_id
  • detail_project_id — UUID — Foreign key → plan_detail_projects.detail_project_id
  • source_type — SMALLINT
  • budget_yr — CHAR(4)
  • budget_amt — NUMERIC
  • source_page_seq — INT
  • reg_dt — TIMESTAMPTZ

plan_detail_projects

  • detail_project_id — UUID — Primary key — NOT NULL
  • unit_project_id — UUID — Foreign key → plan_unit_projects.unit_project_id — NOT NULL
  • detail_project_cd — VARCHAR(30)
  • detail_project_nm — VARCHAR(500)
  • subsidy_yn — BOOLEAN
  • reg_dt — TIMESTAMPTZ

plan_documents

  • plan_doc_id — UUID — Primary key — NOT NULL
  • org_id — UUID — Foreign key → organizations.org_id — NOT NULL
  • file_nm — VARCHAR(500)
  • crtr_yr — CHAR(4)
  • orgnl_file_path — VARCHAR(500)
  • doc_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

plan_elements

  • elem_id — UUID — Primary key — NOT NULL
  • page_id — UUID — Foreign key → plan_pages.page_id — NOT NULL
  • plan_doc_id — UUID — Foreign key → plan_documents.plan_doc_id — NOT NULL
  • 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

plan_guideline_reviews

  • guide_review_id — UUID — Primary key — NOT NULL
  • review_id — UUID — Foreign key → reviews.review_id — NOT NULL
  • kpi_wght_inapt_type — SMALLINT
  • kpi_wght_inapt_detail — TEXT
  • review_item — VARCHAR(20)
  • review_cn — TEXT
  • review_seq — VARCHAR(1000)

plan_kpi_values

  • kpi_id — UUID — Primary key — NOT NULL
  • program_id — UUID — Foreign key → plan_programs.program_id — NOT NULL
  • detail_project_id — UUID — Foreign key → plan_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

plan_pages

  • page_id — UUID — Primary key — NOT NULL
  • plan_doc_id — UUID — Foreign key → plan_documents.plan_doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • page_no — INT
  • page_mark — VARCHAR(30)
  • page_cn — TEXT
  • page_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

plan_programs

  • program_id — UUID — Primary key — NOT NULL
  • plan_doc_id — UUID — Foreign key → plan_documents.plan_doc_id — NOT NULL
  • strtg_goal — VARCHAR(500)
  • strtg_seq — INT
  • program_nm — VARCHAR(500)
  • program_goal — VARCHAR(500)
  • program_seq — INT
  • reg_dt — TIMESTAMPTZ

plan_raw_contents

  • plan_doc_id — UUID — Foreign key → plan_documents.plan_doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • doc_orgtxt_cn — TEXT
  • reg_dt — TIMESTAMPTZ

plan_section_pages

  • section_id — UUID — Foreign key → plan_sections.section_id — NOT NULL
  • page_id — UUID — Foreign key → plan_pages.page_id — NOT NULL
  • section_page_seq — INT

plan_sections

  • section_id — UUID — Primary key — NOT NULL
  • plan_doc_id — UUID — Foreign key → plan_documents.plan_doc_id — NOT NULL
  • program_id — UUID — Foreign key → plan_programs.program_id
  • crtr_yr — CHAR(4)
  • section_type — SMALLINT
  • section_nm — VARCHAR(300)
  • section_seq — INT
  • section_ocr_raw — JSONB
  • section_cn — TEXT
  • section_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

plan_unit_projects

  • unit_project_id — UUID — Primary key — NOT NULL
  • program_id — UUID — Foreign key → plan_programs.program_id — NOT NULL
  • unit_project_cd — VARCHAR(30)
  • unit_project_nm — VARCHAR(500)
  • reg_dt — TIMESTAMPTZ

program_reviews

  • program_review_id — UUID — Primary key — NOT NULL
  • review_id — UUID — Foreign key → reviews.review_id — NOT NULL
  • program_id — UUID — Foreign key → plan_programs.program_id — NOT NULL
  • program_goal_cn — TEXT
  • selection_review_cn — TEXT
  • guideline_review_cn — TEXT
  • etc_review_cn — TEXT

report_documents

  • report_doc_id — UUID — Primary key — NOT NULL
  • org_id — UUID — Foreign key → organizations.org_id — NOT NULL
  • file_nm — VARCHAR(500)
  • crtr_yr — CHAR(4)
  • orgnl_file_path — VARCHAR(500)
  • doc_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

report_elements

  • elem_id — UUID — Primary key — NOT NULL
  • page_id — UUID — Foreign key → report_pages.page_id — NOT NULL
  • report_doc_id — UUID — Foreign key → report_documents.report_doc_id — NOT NULL
  • 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

report_pages

  • page_id — UUID — Primary key — NOT NULL
  • report_doc_id — UUID — Foreign key → report_documents.report_doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • page_no — INT
  • page_mark — VARCHAR(30)
  • page_cn — TEXT
  • page_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

report_raw_contents

  • report_doc_id — UUID — Foreign key → report_documents.report_doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • doc_orgtxt_cn — TEXT
  • reg_dt — TIMESTAMPTZ

report_section_pages

  • section_id — UUID — Foreign key → report_sections.section_id — NOT NULL
  • page_id — UUID — Foreign key → report_pages.page_id — NOT NULL
  • section_page_seq — INT

report_sections

  • section_id — UUID — Primary key — NOT NULL
  • report_doc_id — UUID — Foreign key → report_documents.report_doc_id — NOT NULL
  • crtr_yr — CHAR(4)
  • section_type — SMALLINT
  • section_nm — VARCHAR(300)
  • section_seq — INT
  • section_ocr_raw — JSONB
  • section_cn — TEXT
  • section_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

reviews

  • review_id — UUID — Primary key — NOT NULL
  • plan_doc_id — UUID — Foreign key → plan_documents.plan_doc_id — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • 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 — Primary key — NOT NULL
  • org_id — UUID — Foreign key → organizations.org_id — NOT NULL
  • account — VARCHAR(100) — NOT NULL
  • user_nm — VARCHAR(100)
  • pw — VARCHAR(255)
  • is_admin — BOOLEAN
  • reg_dt — TIMESTAMPTZ