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) — 비밀번호