사다리
테이블 (50)
audit_log
- audit_log_id — bigserial — 기본 키 — NOT NULL
- actor — text — NOT NULL
- action — text — NOT NULL
- table_name — text — NOT NULL
- record_id — bigint — NOT NULL
- before_data — jsonb
- after_data — jsonb
- reason — text
- occurred_at — timestamptz — NOT NULL
bundle_build_check
- bundle_build_check_id — bigserial — 기본 키 — NOT NULL
- client_bundle_id — bigint — 외래 키 → client_bundle.client_bundle_id — NOT NULL
- check_code — code_key — NOT NULL
- passed — boolean — NOT NULL
- detail — text
- checked_at — timestamptz — NOT NULL
bundle_channel
- channel — text — 기본 키 — NOT NULL
- client_bundle_id — bigint — 외래 키 → client_bundle.client_bundle_id — NOT NULL
- switched_at — timestamptz — NOT NULL
- switched_by — text — NOT NULL
bundle_content
- entity_type — text — 기본 키 — NOT NULL
- entity_id — bigint — 기본 키 — NOT NULL
- client_bundle_id — bigint — 외래 키 → client_bundle.client_bundle_id — NOT NULL
- entity_hash — sha256_hex — NOT NULL
calc_param
- calc_param_id — bigserial — 기본 키 — NOT NULL
- param_key — code_key — NOT NULL
- param_value — numeric(18,6) — NOT NULL
- unit — text — NOT NULL
- valid_period — daterange — NOT NULL
- citation_id — bigint — 외래 키 → citation.citation_id — NOT NULL
- description — text — NOT NULL
- created_at — timestamptz — NOT NULL
citation
- citation_id — bigserial — 기본 키 — NOT NULL
- citation_code — code_key — NOT NULL
- source_revision_id — bigint — 외래 키 → source_revision.source_revision_id — NOT NULL
- locator — text — NOT NULL
- quoted_text — text — NOT NULL
- display_label — text — NOT NULL
- deep_link — http_url
- verified_at — date — NOT NULL — 팀이 기관 공식 페이지 원문과 직접 대조한 날. 화면에 그대로 노출된다 (기획서 14.3).
- verified_by — text — NOT NULL
- created_at — timestamptz — NOT NULL
client_bundle
- client_bundle_id — bigserial — 기본 키 — NOT NULL
- bundle_version — semver — NOT NULL
- rule_dsl_version — smallint — NOT NULL
- engine_min_version — semver — NOT NULL
- built_at — timestamptz — NOT NULL
- built_by — text — NOT NULL
- status — publish_status — NOT NULL
- published_at — timestamptz
- content_hash — sha256_hex — NOT NULL
- content_bytes — integer — NOT NULL
- cdn_url — http_url
- scheme_count — smallint — NOT NULL
- clause_count — integer — NOT NULL
- hazard_count — smallint — NOT NULL
- warning_count — smallint — NOT NULL
- rate_record_count — integer — NOT NULL
- oldest_verified_at — date — NOT NULL
- rate_disclosure_month — date
- release_note — text
- rollback_of_bundle_id — bigint — 외래 키 → client_bundle.client_bundle_id
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
contact_channel
- contact_channel_id — bigserial — 기본 키 — NOT NULL
- institution_id — bigint — 외래 키 → institution.institution_id — NOT NULL
- channel_type — text — NOT NULL
- label — text — NOT NULL
- phone_number — text
- url — http_url
- is_emergency_exit — boolean — NOT NULL — 사채·불법사금융 유입 차단용 공적 창구. 부정 판정 화면에 반드시 병기된다 (기획서 1.2).
- display_order — smallint — NOT NULL
- created_at — timestamptz — NOT NULL
corpus_chunk
- corpus_chunk_id — bigserial — 기본 키 — NOT NULL
- corpus_document_id — bigint — 외래 키 → corpus_document.corpus_document_id — NOT NULL
- chunk_index — integer — NOT NULL
- chunk_strategy — text — NOT NULL
- locator — text
- content — text — NOT NULL
- token_count — integer
- citation_id — bigint — 외래 키 → citation.citation_id
- embedding — vector(1536)
- embedding_model — text
- embedded_at — timestamptz
- search_tsv — tsvector
- created_at — timestamptz — NOT NULL
corpus_document
- corpus_document_id — bigserial — 기본 키 — NOT NULL
- source_revision_id — bigint — 외래 키 → source_revision.source_revision_id — NOT NULL
- policy_fund_notice_id — bigint — 외래 키 → policy_fund_notice.policy_fund_notice_id
- scheme_id — bigint — 외래 키 → scheme.scheme_id
- doc_type — source_doc_type — NOT NULL
- title — text — NOT NULL
- language — text — NOT NULL
- indexed_at — timestamptz
- status — publish_status — NOT NULL
- created_at — timestamptz — NOT NULL
credit_band_mapping
- credit_band_mapping_id — bigserial — 기본 키 — NOT NULL
- ui_band_code — code_key — NOT NULL
- ui_cb_provider — cb_provider — NOT NULL
- disclosure_band_id — bigint — 외래 키 → credit_score_band.credit_score_band_id — NOT NULL
- mapping_confidence — text — NOT NULL
- note — text
- created_at — timestamptz — NOT NULL
credit_loan_product
- credit_loan_product_id — bigserial — 기본 키 — NOT NULL
- financial_company_id — bigint — 외래 키 → financial_company.financial_company_id — NOT NULL
- product_code — text — NOT NULL
- product_name — text — NOT NULL
- loan_type — text — NOT NULL
- scheme_id — bigint — 외래 키 → scheme.scheme_id
- limit_max_krw — krw_amount
- term_min_months — month_count
- term_max_months — month_count
- repayment_methods — repayment_method — NOT NULL
- prepayment_fee_pct — ratio_pct
- prepayment_fee_years — numeric(3,1)
- prepayment_fee_source_id — bigint — 외래 키 → source_document.source_document_id
- prepayment_fee_verified_at — date
- join_way — text
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
credit_loan_rate
- credit_loan_rate_id — bigint — 기본 키 — NOT NULL
- disclosure_month — date — 기본 키 — NOT NULL
- rate_snapshot_id — bigint — 외래 키 → rate_snapshot.rate_snapshot_id — NOT NULL
- credit_loan_product_id — bigint — 외래 키 → credit_loan_product.credit_loan_product_id — NOT NULL
- credit_score_band_id — bigint — 외래 키 → credit_score_band.credit_score_band_id — NOT NULL
- rate_type — text — NOT NULL
- avg_rate_pct — annual_rate_pct
- min_rate_pct — annual_rate_pct
- max_rate_pct — annual_rate_pct
- no_offering — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
credit_loan_rate_2026
- 2026-01-01) — TO('2027-01-01'
credit_loan_rate_2027
- 2027-01-01) — TO('2028-01-01'
credit_loan_rate_default
credit_score_band
- credit_score_band_id — bigserial — 기본 키 — NOT NULL
- band_code — code_key — NOT NULL
- cb_provider — cb_provider — NOT NULL
- score_min — smallint — NOT NULL
- score_max — smallint — NOT NULL
- label — text — NOT NULL
- disclosure_field — text
- display_order — smallint — NOT NULL
- created_at — timestamptz — NOT NULL
demo_persona
- demo_persona_id — bigserial — 기본 키 — NOT NULL
- persona_code — code_key — NOT NULL
- title — text — NOT NULL
- narrative — text — NOT NULL
- is_business — boolean — NOT NULL
- input_payload — jsonb — NOT NULL
- expected_paths — jsonb — NOT NULL
- is_fictional — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
dsr_rule
- dsr_rule_id — bigserial — 기본 키 — NOT NULL
- product_kind — text — NOT NULL
- assumed_term_months — month_count
- amortization — repayment_method — NOT NULL
- stress_rate_add_pct — annual_rate_pct — NOT NULL
- is_excluded_from_dsr — boolean — NOT NULL
- citation_id — bigint — 외래 키 → citation.citation_id — NOT NULL
- valid_period — daterange — NOT NULL
- note — text
- created_at — timestamptz — NOT NULL
financial_company
- financial_company_id — bigserial — 기본 키 — NOT NULL
- fin_co_no — text — NOT NULL
- name — text — NOT NULL
- sector — financial_sector — NOT NULL
- homepage_url — http_url
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
hazard
- hazard_id — bigserial — 기본 키 — NOT NULL
- hazard_code — code_key — NOT NULL
- source_scheme_id — bigint — 외래 키 → scheme.scheme_id — NOT NULL
- affected_scheme_id — bigint — 외래 키 → scheme.scheme_id
- affected_segment — ladder_segment
- kind — hazard_kind — NOT NULL
- severity — severity_level — NOT NULL
- block_duration_months — month_count
- trigger_rule_expression_id — bigint — 외래 키 → rule_expression.rule_expression_id
- mitigation_text — text
- mitigation_scheme_id — bigint — 외래 키 → scheme.scheme_id
- citation_id — bigint — 외래 키 → citation.citation_id — NOT NULL
- is_unverified — boolean — NOT NULL
- unverified_note — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
ingestion_run
- ingestion_run_id — bigserial — 기본 키 — NOT NULL
- ingestion_source_id — bigint — 외래 키 → ingestion_source.ingestion_source_id — NOT NULL
- batch_job_execution_id — bigint
- started_at — timestamptz — NOT NULL
- finished_at — timestamptz
- status — ingestion_status — NOT NULL
- fetched_count — integer — NOT NULL
- changed_count — integer — NOT NULL
- error_count — integer — NOT NULL
- error_summary — text
- trace_id — text
ingestion_source
- ingestion_source_id — bigserial — 기본 키 — NOT NULL
- source_code — code_key — NOT NULL
- layer — ingestion_layer — NOT NULL
- label — text — NOT NULL
- fetch_kind — text — NOT NULL
- endpoint_url — http_url
- schedule_cron — text
- expected_interval — interval — NOT NULL
- source_document_id — bigint — 외래 키 → source_document.source_document_id
- robots_checked_at — date
- license_checked_at — date
- is_enabled — boolean — NOT NULL
- auto_publish — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
input_band
- input_band_id — bigserial — 기본 키 — NOT NULL
- band_group — code_key — NOT NULL
- band_code — code_key — NOT NULL
- label — text — NOT NULL
- value_min — numeric(18,3)
- value_max — numeric(18,3)
- unit — text — NOT NULL
- display_order — smallint — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
institution
- institution_id — bigserial — 기본 키 — NOT NULL
- institution_code — code_key — NOT NULL
- name — text — NOT NULL
- short_name — text
- sector — financial_sector
- homepage_url — http_url
- is_public_agency — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
llm_classification_policy
- policy_id — bigserial — 기본 키 — NOT NULL
- task_kind — text — NOT NULL
- label — text — NOT NULL
- min_confidence — numeric(4,3) — NOT NULL
- fallback_action — text — NOT NULL
- conservative_value — text
- requires_user_confirm — boolean — NOT NULL
- rationale — text — NOT NULL
- created_at — timestamptz — NOT NULL
notice_eligibility_tag
- notice_eligibility_tag_id — bigserial — 기본 키 — NOT NULL
- policy_fund_notice_id — bigint — 외래 키 → policy_fund_notice.policy_fund_notice_id — NOT NULL
- tag_key — code_key — NOT NULL
- tag_value — text — NOT NULL
- rule_expression_id — bigint — 외래 키 → rule_expression.rule_expression_id
- extraction_method — text — NOT NULL
- human_verified — boolean — NOT NULL
- confidence — numeric(4,3)
- evidence_span — text
- created_at — timestamptz — NOT NULL
payload_violation_stat
- bucket_started_at — timestamptz — 기본 키 — NOT NULL
- violation_code — code_key — 기본 키 — NOT NULL
- field_path — text — 기본 키 — NOT NULL
- occurrence_count — integer — NOT NULL
- blocked — boolean — NOT NULL
pii_scrub_rule
- pii_scrub_rule_id — bigserial — 기본 키 — NOT NULL
- rule_code — code_key — NOT NULL
- pattern_regex — text — NOT NULL
- category — text — NOT NULL
- action — text — NOT NULL
- replacement — text — NOT NULL
- severity — severity_level — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
policy_fund_notice
- policy_fund_notice_id — bigserial — 기본 키 — NOT NULL
- notice_key — text — NOT NULL
- scheme_id — bigint — 외래 키 → scheme.scheme_id
- issuing_institution_id — bigint — 외래 키 → institution.institution_id
- region_id — bigint — 외래 키 → region.region_id
- title — text — NOT NULL
- support_field — text
- eligibility_text — text — NOT NULL
- support_content_text — text
- interest_rate_text — text
- limit_text — text
- apply_start_date — date
- apply_end_date — date
- is_always_open — boolean — NOT NULL
- budget_exhausted — boolean — NOT NULL
- source_revision_id — bigint — 외래 키 → source_revision.source_revision_id — NOT NULL
- detail_url — http_url — NOT NULL
- status — publish_status — NOT NULL
- first_seen_at — timestamptz — NOT NULL
- last_seen_at — timestamptz — NOT NULL — 주간 크롤에서 마지막으로 관측된 시각. 2주 이상 미관측 공고는 자동 ARCHIVED 처리한다 — 마감된 공고를 추천하는 것이 신뢰를 가장 빨리 깎는다.
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
pre_application_checklist
- checklist_item_id — bigserial — 기본 키 — NOT NULL
- scheme_id — bigint — 외래 키 → scheme.scheme_id
- category — text — NOT NULL
- item_text — text — NOT NULL
- rationale_text — text
- citation_id — bigint — 외래 키 → citation.citation_id
- display_order — smallint — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
proxy_budget_guard
- guard_key — text — 기본 키 — NOT NULL
- period_start — timestamptz — NOT NULL
- period_end — timestamptz — NOT NULL
- limit_micro_krw — bigint — NOT NULL
- consumed_micro_krw — bigint — NOT NULL
- soft_threshold_pct — smallint — NOT NULL
- action_on_exceed — text — NOT NULL — DEGRADE 권장: LLM 을 끊어도 룰 엔진·계산 엔진은 브라우저에서 그대로 동작하므로 서비스가 죽지 않는다. 3층 분리의 실질적 이득.
- updated_at — timestamptz — NOT NULL
proxy_usage_bucket
- bucket_started_at — timestamptz — 기본 키 — NOT NULL
- model_name — text — 기본 키 — NOT NULL
- task_kind — text — 기본 키 — NOT NULL
- request_count — integer — NOT NULL
- success_count — integer — NOT NULL
- error_count — integer — NOT NULL
- input_tokens — bigint — NOT NULL
- output_tokens — bigint — NOT NULL
- cost_micro_krw — bigint — NOT NULL
- latency_p50_ms — integer
- latency_p95_ms — integer
rate_snapshot
- rate_snapshot_id — bigserial — 기본 키 — NOT NULL
- disclosure_month — date — NOT NULL
- sector — financial_sector — NOT NULL
- fetched_at — timestamptz — NOT NULL
- source_document_id — bigint — 외래 키 → source_document.source_document_id
- record_count — integer — NOT NULL
- content_hash — sha256_hex — NOT NULL
- status — publish_status — NOT NULL
- created_at — timestamptz — NOT NULL
region
- region_id — bigserial — 기본 키 — NOT NULL
- region_code — text — NOT NULL
- parent_code — text — 외래 키 → region.region_code
- level — smallint — NOT NULL
- name — text — NOT NULL
- full_name — text — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
retrieval_eval_case
- retrieval_eval_case_id — bigserial — 기본 키 — NOT NULL
- question — text — NOT NULL
- expected_chunk_ids — bigint — NOT NULL
- expected_scheme_id — bigint — 외래 키 → scheme.scheme_id
- min_recall_at_k — smallint — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
review_task
- review_task_id — bigserial — 기본 키 — NOT NULL
- task_type — text — NOT NULL
- title — text — NOT NULL
- detail — text
- severity — severity_level — NOT NULL
- status — text — NOT NULL
- target_table — text
- target_id — bigint
- source_change_event_id — bigint — 외래 키 → source_change_event.source_change_event_id
- assigned_to — text
- due_date — date
- resolved_at — timestamptz
- resolved_by — text
- resolution_note — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
rule_expression
- rule_expression_id — bigserial — 기본 키 — NOT NULL
- dsl_version — smallint — NOT NULL
- expr — jsonb — NOT NULL
- referenced_vars — text — NOT NULL
- human_readable — text — NOT NULL
- created_at — timestamptz — NOT NULL
rule_variable
- rule_variable_id — bigserial — 기본 키 — NOT NULL
- var_path — text — NOT NULL
- data_type — text — NOT NULL
- enum_values — text
- unit — text
- description — text — NOT NULL
- input_field_no — smallint
- is_user_input — boolean — NOT NULL
- is_llm_derived — boolean — NOT NULL — LLM 이 산출한 값. 이 변수에 의존하는 조항은 반드시 사용자 재확인 경로를 함께 가져야 한다 (설계 리뷰 R-03).
- is_band — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
scheme
- scheme_id — bigserial — 기본 키 — NOT NULL
- scheme_code — code_key — NOT NULL
- rung_no — smallint — NOT NULL
- segment — ladder_segment — NOT NULL
- name — text — NOT NULL
- operator_institution_id — bigint — 외래 키 → institution.institution_id
- path_kind — text — NOT NULL
- is_last_resort — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
scheme_clause
- scheme_clause_id — bigserial — 기본 키 — NOT NULL
- scheme_version_id — bigint — 외래 키 → scheme_version.scheme_version_id — NOT NULL
- clause_code — code_key — NOT NULL
- clause_type — clause_type — NOT NULL
- display_order — smallint — NOT NULL
- original_text — text — NOT NULL
- rule_expression_id — bigint — 외래 키 → rule_expression.rule_expression_id
- outcome_when_true — clause_outcome — NOT NULL
- outcome_when_false — clause_outcome — NOT NULL
- reason_code — code_key
- hint_text — text
- redirect_scheme_id — bigint — 외래 키 → scheme.scheme_id
- citation_id — bigint — 외래 키 → citation.citation_id — NOT NULL
- has_exception — boolean — NOT NULL
- exception_text — text
- exception_rule_expression_id — bigint — 외래 키 → rule_expression.rule_expression_id
- is_unverified — boolean — NOT NULL
- unverified_note — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
scheme_transition
- scheme_transition_id — bigserial — 기본 키 — NOT NULL
- from_scheme_id — bigint — 외래 키 → scheme.scheme_id — NOT NULL
- to_scheme_id — bigint — 외래 키 → scheme.scheme_id — NOT NULL
- trigger_label — text — NOT NULL
- rule_expression_id — bigint — 외래 키 → rule_expression.rule_expression_id
- citation_id — bigint — 외래 키 → citation.citation_id — NOT NULL
- is_automatic — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
scheme_version
- scheme_version_id — bigserial — 기본 키 — NOT NULL
- scheme_id — bigint — 외래 키 → scheme.scheme_id — NOT NULL
- version_no — integer — NOT NULL
- status — publish_status — NOT NULL
- valid_period — daterange — NOT NULL
- verified_at — date — NOT NULL
- verified_by — text — NOT NULL
- target_description — text — NOT NULL
- summary — text — NOT NULL
- fee_krw — krw_amount
- application_window — text
- notes — text
- authored_by — text — NOT NULL
- approved_by — text
- approved_at — timestamptz
- published_at — timestamptz
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
scheme_version_channel
- scheme_version_id — bigint — 외래 키 → scheme_version.scheme_version_id — NOT NULL
- contact_channel_id — bigint — 외래 키 → contact_channel.contact_channel_id — NOT NULL
seizure_exemption
- seizure_exemption_id — bigserial — 기본 키 — NOT NULL
- asset_kind — text — NOT NULL
- terminated_by — text — NOT NULL
- exempt_limit_krw — krw_amount
- is_full_exempt — boolean — NOT NULL
- citation_id — bigint — 외래 키 → citation.citation_id — NOT NULL
- valid_period — daterange — NOT NULL
- note — text
- created_at — timestamptz — NOT NULL
source_change_event
- source_change_event_id — bigserial — 기본 키 — NOT NULL
- ingestion_run_id — bigint — 외래 키 → ingestion_run.ingestion_run_id — NOT NULL
- source_document_id — bigint — 외래 키 → source_document.source_document_id — NOT NULL
- previous_revision_id — bigint — 외래 키 → source_revision.source_revision_id
- new_revision_id — bigint — 외래 키 → source_revision.source_revision_id — NOT NULL
- diff_summary — text
- changed_char_count — integer
- impacted_clause_count — integer — NOT NULL
- severity — severity_level — NOT NULL
- detected_at — timestamptz — NOT NULL
source_document
- source_document_id — bigserial — 기본 키 — NOT NULL
- doc_code — code_key — NOT NULL
- doc_type — source_doc_type — NOT NULL
- title — text — NOT NULL
- publisher — text — NOT NULL
- canonical_url — http_url — NOT NULL
- statute_id — text
- article_path — text
- license_type — text — NOT NULL
- robots_allowed — boolean
- crawl_permitted — boolean — NOT NULL — 이용허락범위·robots.txt 확인 완료 여부. false 인 원문은 배포 번들 빌드 시 차단된다.
- citable — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
source_revision
- source_revision_id — bigserial — 기본 키 — NOT NULL
- source_document_id — bigint — 외래 키 → source_document.source_document_id — NOT NULL
- fetched_at — timestamptz — NOT NULL
- content_hash — sha256_hex — NOT NULL
- raw_text — text
- raw_storage_uri — text
- http_status — smallint
- is_current — boolean — NOT NULL
ui_copy
- ui_copy_id — bigserial — 기본 키 — NOT NULL
- copy_key — code_key — NOT NULL
- locale — text — NOT NULL
- version_no — integer — NOT NULL
- text_value — text — NOT NULL
- tone — text — NOT NULL
- status — publish_status — NOT NULL
- citation_id — bigint — 외래 키 → citation.citation_id
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
warning_template
- warning_template_id — bigserial — 기본 키 — NOT NULL
- warning_code — code_key — NOT NULL
- hazard_id — bigint — 외래 키 → hazard.hazard_id
- severity — severity_level — NOT NULL
- priority — smallint — NOT NULL
- trigger_rule_expression_id — bigint — 외래 키 → rule_expression.rule_expression_id — NOT NULL
- headline — text — NOT NULL
- body_text — text — NOT NULL
- exception_hint — text
- next_action_text — text — NOT NULL
- citation_id — bigint — 외래 키 → citation.citation_id — NOT NULL
- status — publish_status — NOT NULL
- legal_reviewed_at — date
- legal_reviewed_by — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL