재정성과 ERD

테이블 (37)

1.성과계획서 지침 양식 등 (1번시트)

    3.프로그램성과지표 검토의견 (Untitled)

      assessment_runs

      • assessment_id — UUID — 기본 키 — NOT NULL
      • plan_doc_id (plan_doc_id2) — UUID — 외래 키 → performance_plan_documents.plan_doc_id — NOT NULL
      • user_id — UUID — 외래 키 → 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

      guideline_assessments

      • guideline_assessment_id — UUID — 기본 키 — NOT NULL
      • assessment_id — UUID — 외래 키 → assessment_runs.assessment_id — NOT NULL
      • kpi_wght_inapt_type — SMALLINT
      • kpi_wght_inapt_detail — TEXT
      • assessment_item — VARCHAR(20)
      • assessment_cn — TEXT
      • assessment_seq — VARCHAR(1000)

      guideline_documents

      • guideline_doc_id — UUID — 기본 키 — NOT NULL
      • 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 — 기본 키 — NOT NULL
      • page_id — UUID — 외래 키 → guideline_pages.page_id — NOT NULL
      • guideline_doc_id — UUID — 외래 키 → 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 — 기본 키 — NOT NULL
      • guideline_doc_id — UUID — 외래 키 → 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 — 외래 키 → guideline_documents.guideline_doc_id — NOT NULL
      • crtr_yr — CHAR(4)
      • doc_orgtxt_cn — TEXT
      • reg_dt — TIMESTAMPTZ

      guideline_section_pages

      • section_id — UUID — 외래 키 → guideline_sections.section_id — NOT NULL
      • page_id — UUID — 외래 키 → guideline_pages.page_id — NOT NULL
      • section_page_seq — INT

      guideline_sections

      • section_id — UUID — 기본 키 — NOT NULL
      • guideline_doc_id — UUID — 외래 키 → guideline_documents.guideline_doc_id — NOT NULL
      • 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

      kpi_assessment_opinions

      • kpi_assessment_opinion_id — UUID — 기본 키 — NOT NULL
      • kpi_assessment_id — UUID — 외래 키 → kpi_assessments.kpi_assessment_id — NOT NULL
      • category_no — INT
      • opinion_cn — TEXT
      • opinion_seq — INT

      kpi_assessments

      • kpi_assessment_id — UUID — 기본 키 — NOT NULL
      • assessment_id — UUID — 외래 키 → assessment_runs.assessment_id — NOT NULL
      • 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) — NOT NULL
      • crtr_yr — CHAR(4)
      • parent_org_id — UUID — 외래 키 → organizations.org_id
      • abolish_yn — SMALLINT

      performance_plan_budget_values

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

      performance_plan_detail_projects

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

      performance_plan_documents

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

      performance_plan_elements

      • elem_id — UUID — 기본 키 — NOT NULL
      • page_id — UUID — 외래 키 → performance_plan_pages.page_id — NOT NULL
      • plan_doc_id — UUID — 외래 키 → performance_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

      performance_plan_kpi_values

      • kpi_id — UUID — 기본 키 — NOT NULL
      • program_id — UUID — 외래 키 → performance_plan_programs.program_id — NOT NULL
      • detail_project_id — UUID — 외래 키 → performance_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

      performance_plan_pages

      • page_id — UUID — 기본 키 — NOT NULL
      • plan_doc_id — UUID — 외래 키 → performance_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

      performance_plan_programs

      • program_id — UUID — 기본 키 — NOT NULL
      • plan_doc_id — UUID — 외래 키 → performance_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

      performance_plan_raw_contents

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

      performance_plan_section_pages

      • section_id — UUID — 외래 키 → performance_plan_sections.section_id — NOT NULL
      • page_id — UUID — 외래 키 → performance_plan_pages.page_id — NOT NULL
      • section_page_seq — INT

      performance_plan_sections

      • section_id — UUID — 기본 키 — NOT NULL
      • plan_doc_id — UUID — 외래 키 → performance_plan_documents.plan_doc_id — NOT NULL
      • program_id — UUID — 외래 키 → performance_plan_programs.program_id
      • 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

      performance_plan_unit_projects

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

      performance_report_documents

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

      performance_report_elements

      • elem_id — UUID — 기본 키 — NOT NULL
      • page_id — UUID — 외래 키 → performance_report_pages.page_id — NOT NULL
      • report_doc_id — UUID — 외래 키 → performance_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

      performance_report_pages

      • page_id — UUID — 기본 키 — NOT NULL
      • report_doc_id — UUID — 외래 키 → performance_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

      performance_report_raw_contents

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

      performance_report_section_pages

      • section_id — UUID — 외래 키 → performance_report_sections.section_id — NOT NULL
      • page_id — UUID — 외래 키 → performance_report_pages.page_id — NOT NULL
      • section_page_seq — INT

      performance_report_sections

      • section_id — UUID — 기본 키 — NOT NULL
      • report_doc_id — UUID — 외래 키 → performance_report_documents.report_doc_id — NOT NULL
      • 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

      program_assessments

      • program_assessment_id — UUID — 기본 키 — NOT NULL
      • assessment_id — UUID — 외래 키 → assessment_runs.assessment_id — NOT NULL
      • program_id — UUID
      • program_goal_cn — TEXT
      • selection_assessment_cn — TEXT
      • guideline_assessment_cn — TEXT
      • etc_assessment_cn — TEXT

      users

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

      검토 지침 (CopyOf1번시트3)

        성과계획서 (CopyOf1번시트)

          성과계획서 검토 (Untitled2)

            성과보고서 (CopyOf1번시트2)