재정성과 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