사다리

테이블 (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