d1

Tables (33)

doc_budget_values

  • budget_value_id — UUID — Primary key — NOT NULL — 예산정보 ID
  • program_id — UUID — Foreign key → doc_programs.program_id — 프로그램 ID
  • unit_project_id — UUID — Foreign key → doc_unit_projects.unit_project_id — 단위사업 ID
  • detail_project_id — UUID — Foreign key → doc_detail_projects.detail_project_id — 세부사업 ID
  • source_type — SMALLINT — 출처구분
  • budget_amt — NUMERIC — 예산금액
  • source_page_seq — INT — 출처페이지
  • reg_dt — TIMESTAMPTZ — 등록일시
  • budget_yr — CHAR(4) — 예산 기준연도

doc_detail_projects

  • detail_project_id — UUID — Primary key — NOT NULL — 세부사업 ID
  • unit_project_id — UUID — Foreign key → doc_unit_projects.unit_project_id — 단위사업 ID
  • subsidy_yn — BOOLEAN — 보조사업 여부
  • reg_dt — TIMESTAMPTZ — 등록일시
  • detail_project_cd — VARCHAR(30) — 세부사업 코드
  • detail_project_nm — VARCHAR(500) — 세부사업명

doc_elements

  • elem_id — UUID — Primary key — NOT NULL — 문서 요소 ID
  • page_id — UUID — Foreign key → doc_pages.page_id — 페이지 ID
  • doc_id — UUID — Foreign key → documents.doc_id — 문서 ID
  • elmn_type_cd — INT — 요소유형코드
  • elem_seq — INT — 요소순번
  • elmn_cn — TEXT — 요소 텍스트
  • elmn_bbox — INTEGER — 요소 위치 정보
  • elmn_mtdt — JSONB — 요소 메타데이터
  • reg_dt — TIMESTAMPTZ — 등록일시
  • crtr_yr — CHAR(4) — 기준연도
  • elmn_nm — VARCHAR(100) — 요소명
  • elmn_file_path — VARCHAR(500) — 요소 파일 경로

doc_kpi_values

  • kpi_id — UUID — Primary key — NOT NULL — 성과지표 ID
  • program_id — UUID — Foreign key → doc_programs.program_id — 프로그램 ID
  • detail_project_id — UUID — Foreign key → doc_detail_projects.detail_project_id — 세부사업 ID
  • source_type — SMALLINT — 출처구분
  • value_type — SMALLINT — 목표·실적 구분
  • kpi_value — NUMERIC — 성과지표 값
  • measure_cn — TEXT — 측정산식·방법내용
  • data_source_cn — TEXT — 자료수집 방법·출처내용
  • source_page_seq — INT — 출처페이지
  • reg_dt — TIMESTAMPTZ — 등록일시
  • kpi_nm — VARCHAR(100) — 성과지표명
  • kpi_yr — CHAR(4) — 성과지표 연도
  • wght — NUMERIC(10, 4) — 가중치

doc_pages

  • page_id — UUID — Primary key — NOT NULL — 페이지 ID
  • doc_id — UUID — Foreign key → documents.doc_id — 문서 ID
  • page_no — INT — 실제 페이지 순번
  • page_cn — TEXT — 페이지 내용
  • page_mtdt — JSONB — 페이지 메타데이터
  • reg_dt — TIMESTAMPTZ — 등록일시
  • crtr_yr — CHAR(4) — 기준연도
  • page_mark — VARCHAR(30) — 페이지 표시값

doc_programs

  • program_id — UUID — Primary key — NOT NULL — 프로그램 ID
  • doc_id — UUID — Foreign key → documents.doc_id — 문서 ID
  • strtg_seq — INT — 전략 순번
  • program_seq — INT — 프로그램 순번
  • reg_dt — TIMESTAMPTZ — 등록일시
  • strtg_goal — VARCHAR(500) — 전략목표
  • program_nm — VARCHAR(500) — 프로그램명
  • program_goal — VARCHAR(500) — 프로그램 목표

doc_raw_contents

  • doc_id — UUID — Foreign key → documents.doc_id — NOT NULL — 문서 ID
  • doc_orgtxt_cn — TEXT — 문서 원문 텍스트
  • reg_dt — TIMESTAMPTZ — 등록일시
  • crtr_yr — CHAR(4) — 기준연도

doc_sections

  • section_id — UUID — Primary key — NOT NULL — 섹션 ID
  • doc_id — UUID — Foreign key → documents.doc_id — 문서 ID
  • program_id — UUID — Foreign key → doc_programs.program_id — 프로그램 ID
  • section_type — SMALLINT — 섹션 유형
  • start_page_no — INT — 시작 페이지
  • end_page_no — INT — 종료 페이지
  • section_seq — INT — 섹션순번
  • section_ocr_raw — JSONB — 섹션 OCR 원문
  • section_cn — TEXT — 섹션 내용
  • section_mtdt — JSONB — 섹션 메타데이터
  • reg_dt — TIMESTAMPTZ — 등록일시
  • crtr_yr — CHAR(4) — 기준연도
  • section_nm — VARCHAR(300) — 섹션명

doc_unit_projects

  • unit_project_id — UUID — Primary key — NOT NULL — 단위사업 ID
  • program_id — UUID — Foreign key → doc_programs.program_id — 프로그램 ID
  • reg_dt — TIMESTAMPTZ — 등록일시
  • unit_project_cd — VARCHAR(30) — 단위사업 코드
  • unit_project_nm — VARCHAR(500) — 단위사업명

documents

  • doc_id — UUID — Primary key — NOT NULL — 문서 ID
  • org_id — UUID — Foreign key → organizations.org_id — 부처기관 ID
  • doc_mtdt — JSONB — 문서 메타데이터
  • reg_dt — TIMESTAMPTZ — 등록일시
  • file_nm — VARCHAR(500) — 파일명
  • crtr_yr — CHAR(4) — 기준연도
  • orgnl_file_path — VARCHAR(500) — 원본파일경로

guideline_documents

  • guideline_doc_id — UUID — Primary key — 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_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_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 — 성과지표검토의견 ID
  • kpi_review_id — UUID — Foreign key → kpi_reviews.kpi_review_id — 성과지표검토 ID
  • category_no — INT — 검토분류번호
  • opinion_cn — TEXT — 검토의견내용
  • opinion_seq — INT — 검토순번

kpi_reviews

  • kpi_review_id — UUID — Primary key — NOT NULL — 성과지표검토 ID
  • review_id — UUID — Foreign key → reviews.review_id — 검토 ID
  • program_id — UUID — Foreign key → doc_programs.program_id — 프로그램 ID
  • kpi_id — UUID — Foreign key → doc_kpi_values.kpi_id — 성과지표 ID
  • 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 — 부처기관 이력 ID
  • prev_org_id — UUID — Foreign key → organizations.org_id — 이전기관 ID
  • next_org_id — UUID — Foreign key → organizations.org_id — 이후기관 ID
  • change_type — SMALLINT — 기관변경유형
  • change_date — DATE — 변경일자

organizations

  • org_id — UUID — Primary key — NOT NULL — 부처기관 ID
  • parent_org_id — UUID — Foreign key → organizations.org_id — 상위기관 ID
  • abolish_yn — SMALLINT — 기관상태
  • crtr_yr — CHAR(4) — 기준연도
  • org_nm — VARCHAR(300) — 기관명

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 — NOT NULL
  • file_nm — VARCHAR(500)
  • crtr_yr — CHAR(4)
  • orgnl_file_path — VARCHAR(500)
  • doc_mtdt — JSONB
  • reg_dt — TIMESTAMPTZ

plan_guideline_reviews

  • guide_review_id — UUID — Primary key — NOT NULL — 지침검토 ID
  • review_id — UUID — Foreign key → reviews.review_id — 검토 ID
  • kpi_wght_inapt_type — SMALLINT — 지표구성·가중치 부적정 분류
  • kpi_wght_inapt_detail — TEXT — 부적정 상세의견
  • review_cn — TEXT — 검토의견내용
  • review_item — VARCHAR(20) — 검토항목
  • 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_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 — 프로그램검토 ID
  • review_id — UUID — Foreign key → reviews.review_id — 검토 ID
  • program_id — UUID — Foreign key → doc_programs.program_id — 프로그램 ID
  • 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 — NOT NULL
  • file_nm — VARCHAR(500)
  • crtr_yr — CHAR(4)
  • orgnl_file_path — VARCHAR(500)
  • doc_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_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 — 검토 ID
  • doc_id — UUID — Foreign key → documents.doc_id — 문서 ID
  • user_id — UUID — Foreign key → users.user_id — 사용자 ID
  • start_dt — TEXT — 시작일시
  • end_dt — TEXT — 종료일시
  • error_cn — TEXT — 오류내용
  • status — VARCHAR(20) — 검토상태
  • result_file_nm — VARCHAR(500) — 결과 파일명
  • result_file_path — VARCHAR(1000) — 결과파일경로

users

  • user_id — UUID — Primary key — NOT NULL — 사용자 ID
  • org_id — UUID — Foreign key → organizations.org_id — 부처기관 ID
  • is_admin — BOOLEAN — 관리자 여부
  • reg_dt — TIMESTAMPTZ — 생성일자
  • account — VARCHAR(100) — 계정
  • user_nm — VARCHAR(100) — 사용자명
  • pw — VARCHAR(255) — 비밀번호