보험 더미 디비

테이블 (56)

if_agent

  • agent_code — text — 기본 키 — NOT NULL
  • agent_name — text
  • branch_code — text — 외래 키 → if_branch.branch_code
  • channel_code — text — 외래 키 → if_channel.channel_code
  • hire_date — date
  • agent_rank — text
  • status — text
  • resign_date — date

if_agent_license

  • license_id — text — 기본 키 — NOT NULL
  • agent_code — text — 외래 키 → if_agent.agent_code — NOT NULL
  • license_type — text — NOT NULL
  • license_no — text
  • acquired_date — date
  • expire_date — date
  • status — text

if_beneficiary

  • beneficiary_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • benefit_type — text — NOT NULL
  • beneficiary_name — text
  • relation_code — text
  • share_pct — numeric
  • designated_date — date
  • changed_yn — boolean
  • customer_id — text — 외래 키 → if_customer.customer_id

if_branch

  • branch_code — text — 기본 키 — NOT NULL
  • branch_name — text — NOT NULL
  • org_code — text — 외래 키 → if_org_unit.org_code
  • branch_type — text
  • region — text
  • manager_name — text
  • open_date — date
  • status — text

if_calendar

  • calendar_date — date — 기본 키 — NOT NULL
  • year_no — int — NOT NULL
  • month_no — int — NOT NULL
  • day_no — int — NOT NULL
  • weekday_name — text — NOT NULL
  • weekday_no — int — NOT NULL
  • business_day_yn — boolean — NOT NULL
  • holiday_name — text
  • week_of_year — int
  • month_end_yn — boolean — NOT NULL
  • quarter_end_yn — boolean — NOT NULL

if_channel

  • channel_code — text — 기본 키 — NOT NULL
  • channel_name — text — NOT NULL
  • channel_type — text
  • face_to_face_yn — boolean — NOT NULL
  • pre_uw_required_yn — boolean — NOT NULL
  • sale_start_date — date
  • use_yn — boolean — NOT NULL

if_claim

  • claim_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code
  • claim_date — date
  • diagnosis_code — text
  • claim_amount — bigint
  • paid_amount — bigint
  • status — text
  • decision_date — date
  • decision_note — text

if_claim_document

  • doc_id — text — 기본 키 — NOT NULL
  • claim_id — text — 외래 키 → if_claim.claim_id — NOT NULL
  • doc_type — text
  • received_date — date
  • receive_channel — text
  • verified_yn — boolean
  • verified_date — date
  • page_count — int
  • note — text

if_claim_investigation

  • investigation_id — text — 기본 키 — NOT NULL
  • claim_id — text — 외래 키 → if_claim.claim_id — NOT NULL
  • investigation_type — text
  • assigned_at — timestamptz
  • closed_at — timestamptz
  • investigator_id — text
  • agency_name — text
  • result_code — text
  • result_summary — text
  • investigation_cost — numeric

if_claim_payment

  • payment_id — text — 기본 키 — NOT NULL
  • claim_id — text — 외래 키 → if_claim.claim_id — NOT NULL
  • pay_seq — int — NOT NULL
  • paid_date — date
  • paid_amount — bigint
  • pay_type — text
  • masked_account_no — text
  • deduct_amount — bigint
  • deduct_reason — text
  • status — text

if_code_master

  • code_group — text — 기본 키 — NOT NULL
  • code — text — 기본 키 — NOT NULL
  • code_name — text — NOT NULL
  • code_desc — text
  • sort_order — int
  • use_yn — boolean — NOT NULL
  • apply_start_date — date

if_contract

  • policy_no — text — 기본 키 — NOT NULL
  • contractor_id — text — 외래 키 → if_customer.customer_id
  • insured_id — text — 외래 키 → if_customer.customer_id
  • product_code — text — 외래 키 → if_product.product_code
  • contract_date — date — NOT NULL
  • status — text — NOT NULL
  • channel — text
  • branch_code — text
  • expiry_date — date

if_contract_change

  • change_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • change_type — text — NOT NULL
  • change_date — date — NOT NULL
  • before_value — text
  • after_value — text
  • receipt_channel — text
  • handler_id — text
  • processed_at — timestamptz

if_contract_coverage

  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code — NOT NULL
  • insured_amount — bigint — NOT NULL
  • start_date — date
  • end_date — date
  • extra_rate_pct — int
  • exclusion_note — text

if_contract_reinstate

  • reinstate_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • lapse_date — date
  • apply_date — date
  • decision_code — text
  • decision_date — date
  • overdue_premium — bigint
  • overdue_interest — bigint
  • reunderwriting_yn — boolean
  • redisclosure_yn — boolean
  • note — text

if_contract_status_hist

  • hist_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • change_seq — int — NOT NULL
  • prev_status — text
  • new_status — text — NOT NULL
  • change_date — date — NOT NULL
  • reason_code — text
  • reason_desc — text
  • handler_id — text

if_contract_surrender

  • surrender_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • surrender_type — text — NOT NULL
  • claim_date — date
  • surrender_date — date
  • process_state — text
  • paid_premium_sum — bigint
  • refund_amount — bigint
  • deduction_amount — bigint
  • reason_code — text
  • reason_desc — text
  • refund_date — date

if_coverage_exclusion

  • exclusion_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id
  • exclusion_scope — text
  • target_kcd_range — text
  • start_date — date
  • end_date — date
  • exclusion_years — int
  • source_type — text
  • status — text
  • note — text

if_coverage_extra_rating

  • rating_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id
  • reason_code — text — 외래 키 → if_uw_reason_code.reason_code
  • extra_rate_pct — int
  • rating_type — text
  • start_date — date
  • end_date — date
  • source_type — text
  • status — text
  • note — text

if_coverage_master

  • coverage_code — text — 기본 키 — NOT NULL
  • coverage_name — text — NOT NULL
  • coverage_type — text
  • waiting_period_days — int
  • reduction_months — int
  • reduction_rate_pct — int
  • renewal_type — text

if_coverage_reduction

  • reduction_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id
  • reduction_type — text
  • reduction_rate_pct — int
  • start_date — date
  • end_date — date
  • source_type — text
  • status — text
  • note — text

if_credit_consent

  • consent_id — text — 기본 키 — NOT NULL
  • customer_id — text — 외래 키 → if_customer.customer_id
  • case_id — text — 외래 키 → if_uw_case.case_id
  • consent_type — text
  • consent_yn — boolean — NOT NULL
  • consent_date — date
  • expire_date — date
  • collect_channel — text
  • agent_code — text — 외래 키 → if_agent.agent_code
  • agency — text
  • withdraw_date — date

if_customer

  • customer_id — text — 기본 키 — NOT NULL
  • customer_name — text
  • birth_date — date — NOT NULL
  • gender — text
  • occupation_code — text — 외래 키 → if_occupation_grade.occupation_code
  • channel — text
  • branch_code — text
  • region — text
  • join_date — date

if_customer_consent

  • consent_id — text — 기본 키 — NOT NULL
  • customer_id — text — 외래 키 → if_customer.customer_id — NOT NULL
  • consent_type — text — NOT NULL
  • agree_yn — boolean — NOT NULL
  • agree_date — date
  • expire_date — date
  • collect_channel — text
  • revoke_date — date

if_customer_job_hist

  • hist_id — text — 기본 키 — NOT NULL
  • customer_id — text — 외래 키 → if_customer.customer_id — NOT NULL
  • occupation_code — text — 외래 키 → if_occupation_grade.occupation_code — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date
  • change_reason — text
  • reported_date — date
  • report_channel — text

if_customer_region

  • customer_id — text — 외래 키 → if_customer.customer_id — NOT NULL
  • sido — text — NOT NULL
  • sigungu — text
  • zip_prefix — text
  • region_type — text
  • move_in_date — date
  • updated_at — timestamptz

if_disease_risk

  • risk_id — text — 기본 키 — NOT NULL
  • kcd_code — text — 외래 키 → if_kcd_master.kcd_code — NOT NULL
  • condition_desc — text
  • risk_grade — int — NOT NULL
  • risk_grade_name — text
  • uw_guide — text — NOT NULL
  • rec_extra_rate_pct — int
  • rec_exclusion_years — int
  • rec_observe_months — int
  • exam_required_yn — boolean — NOT NULL
  • note — text

if_external_inforce

  • external_id — text — 기본 키 — NOT NULL
  • insured_id — text — 외래 키 → if_customer.customer_id
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code
  • insurer_name — text
  • product_category — text
  • coverage_group_name — text
  • insured_amount — bigint
  • contract_date — date
  • contract_status — text
  • inquiry_date — date
  • info_source — text
  • case_id — text — 외래 키 → if_uw_case.case_id

if_insured_relation

  • relation_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • contractor_id — text — 외래 키 → if_customer.customer_id
  • insured_id — text — 외래 키 → if_customer.customer_id
  • relation_code — text
  • relation_name — text
  • written_consent_yn — boolean
  • consent_date — date
  • minor_insured_yn — boolean

if_kcd_master

  • kcd_code — text — 기본 키 — NOT NULL
  • disease_name — text — NOT NULL
  • chapter — text
  • major_category_name — text
  • cancer_yn — boolean — NOT NULL
  • critical_illness_yn — boolean — NOT NULL
  • gender_limit — text
  • note — text

if_occupation_grade

  • occupation_code — text — 기본 키 — NOT NULL
  • occupation_name — text — NOT NULL
  • grade — int — NOT NULL
  • risk_note — text

if_org_unit

  • org_code — text — 기본 키 — NOT NULL
  • org_name — text — NOT NULL
  • org_level — text — NOT NULL
  • parent_org_code — text — 외래 키 → if_org_unit.org_code
  • branch_yn — boolean — NOT NULL
  • manager_title — text
  • open_date — date
  • status — text
  • sort_order — int

if_payment_method

  • method_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • method_code — text — NOT NULL
  • method_name — text
  • institution_name — text
  • masked_account_no — text
  • transfer_day — int
  • depositor_relation — text
  • apply_start_date — date
  • apply_end_date — date
  • status — text

if_policy_issue

  • issue_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • issue_type — text — NOT NULL
  • issue_date — date — NOT NULL
  • delivery_method — text
  • delivered_date — date
  • receipt_confirmed_yn — boolean
  • receipt_confirmed_date — date
  • returned_yn — boolean

if_premium_payment

  • payment_id — text — 기본 키 — NOT NULL
  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • term_no — int — NOT NULL
  • due_date — date
  • paid_date — date
  • billed_amount — bigint
  • paid_amount — bigint
  • method_code — text
  • status — text
  • overdue_days — int
  • receipt_no — text

if_premium_schedule

  • policy_no — text — 외래 키 → if_contract.policy_no — NOT NULL
  • pay_cycle — text
  • pay_period_years — int
  • pay_end_date — date
  • premium_per_term — bigint
  • first_payment_date — date
  • next_payment_date — date
  • total_terms — int
  • paid_terms — int
  • status — text

if_product

  • product_code — text — 기본 키 — NOT NULL
  • product_name — text — NOT NULL
  • category — text
  • product_type — text
  • sale_state — text
  • launch_date — date

if_product_channel

  • product_code — text — 외래 키 → if_product.product_code — NOT NULL
  • channel_code — text — 외래 키 → if_channel.channel_code — NOT NULL
  • sale_start_date — date — NOT NULL
  • sale_end_date — date
  • sale_yn — boolean — NOT NULL
  • min_premium — bigint
  • limit_multiple — numeric
  • uw_required_yn — boolean — NOT NULL
  • note — text

if_product_coverage

  • product_code — text — 외래 키 → if_product.product_code — NOT NULL
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code — NOT NULL
  • rider_type — text
  • min_amount — bigint
  • max_amount — bigint

if_product_uw_rule

  • product_code — text — 외래 키 → if_product.product_code — NOT NULL
  • rule_id — text — 외래 키 → if_uw_rule.rule_id — NOT NULL
  • apply_yn — boolean — NOT NULL
  • decision_override — text
  • extra_rate_override_pct — int
  • priority — int
  • apply_start_date — date
  • note — text

if_product_version

  • version_no — int — 기본 키 — NOT NULL
  • product_code — text — 외래 키 → if_product.product_code — NOT NULL
  • version_name — text
  • apply_start_date — date — NOT NULL
  • apply_end_date — date
  • revision_summary — text
  • approval_no — text
  • current_yn — boolean — NOT NULL
  • assumed_rate_pct — numeric
  • registered_date — date

if_reinsurance_cession

  • cession_id — text — 기본 키 — NOT NULL
  • treaty_id — text — 외래 키 → if_reinsurance_treaty.treaty_id
  • policy_no — text — 외래 키 → if_contract.policy_no
  • case_id — text — 외래 키 → if_uw_case.case_id
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code
  • cession_type — text
  • cession_amount — bigint
  • retained_amount — bigint
  • cession_rate_pct — numeric
  • cession_date — date
  • reinsurer_opinion — text
  • reinsurer_decision — text
  • status — text

if_reinsurance_treaty

  • treaty_id — text — 기본 키 — NOT NULL
  • treaty_name — text
  • reinsurer_name — text
  • treaty_type — text
  • retention_limit — bigint
  • cession_limit — bigint
  • target_coverage_group — text
  • target_product_group — text
  • start_date — date
  • end_date — date
  • status — text
  • note — text

if_rider

  • rider_code — text — 기본 키 — NOT NULL
  • coverage_code — text — 외래 키 → if_coverage_master.coverage_code — NOT NULL
  • rider_name — text — NOT NULL
  • rider_category — text
  • attach_type — text
  • renewal_cycle_years — int
  • min_entry_age — int
  • max_entry_age — int
  • sale_state — text
  • sale_start_date — date
  • description — text

if_sync_meta

  • table_name — text — 기본 키 — NOT NULL
  • synced_at — timestamptz — NOT NULL

if_uw_case

  • case_id — text — 기본 키 — NOT NULL
  • insured_id — text — 외래 키 → if_customer.customer_id
  • proposal_id — text
  • product_code — text — 외래 키 → if_product.product_code
  • applied_at — date
  • channel — text
  • branch_code — text
  • agent_code — text

if_uw_decision

  • case_id — text — 외래 키 → if_uw_case.case_id — NOT NULL
  • decision_code — text — NOT NULL
  • decision_name — text
  • reason_codes — text
  • extra_rate_pct — int
  • exclusion_items — text
  • exclusion_years — int
  • recheck_after — date
  • decided_at — date

if_uw_disclosure

  • seq — int — 기본 키 — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id — NOT NULL
  • kcd_code — text
  • disease_name — text
  • diagnosed_at — date
  • treatment_state — text
  • note — text

if_uw_financial

  • financial_id — text — 기본 키 — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id — NOT NULL
  • annual_income — bigint
  • income_source — text
  • income_proof_type — text
  • annual_premium_total — bigint
  • premium_income_ratio_pct — numeric
  • existing_death_amount — bigint
  • applied_death_amount — bigint
  • death_income_multiple — numeric
  • financial_result — text
  • reviewed_date — date
  • remark — text

if_uw_medical_exam

  • exam_id — text — 기본 키 — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id — NOT NULL
  • insured_id — text — 외래 키 → if_customer.customer_id
  • exam_type — text
  • exam_date — date
  • hospital_name — text
  • height_cm — numeric
  • weight_kg — numeric
  • bmi — numeric
  • systolic_bp — int
  • diastolic_bp — int
  • fasting_glucose — int
  • hba1c — numeric
  • total_cholesterol — int
  • ast — int
  • alt — int
  • urine_protein — text
  • smoking_yn — boolean
  • drinking_yn — boolean
  • result_summary — text
  • abnormal_yn — boolean

if_uw_reason_code

  • reason_code — text — 기본 키 — NOT NULL
  • reason_name — text — NOT NULL
  • reason_category — text
  • description — text
  • typical_decision_code — text
  • related_kcd_sample — text
  • use_yn — boolean

if_uw_referral

  • referral_id — text — 기본 키 — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id — NOT NULL
  • stage — text
  • from_owner — text
  • to_owner — text
  • referred_at — timestamptz
  • replied_at — timestamptz
  • reviewer_id — text
  • referral_reason — text
  • reply_opinion — text

if_uw_requirement

  • requirement_id — text — 기본 키 — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id — NOT NULL
  • doc_type — text
  • request_reason — text
  • requested_date — date
  • due_date — date
  • received_date — date
  • status — text
  • staff_id — text
  • remark — text

if_uw_rule

  • rule_id — text — 기본 키 — NOT NULL
  • rule_name — text — NOT NULL
  • rule_category — text
  • condition_desc — text
  • target_kcd_pattern — text
  • treatment_state_cond — text
  • elapsed_months_cond — int
  • occupation_grade_min — int
  • occupation_grade_max — int
  • entry_age_min — int
  • entry_age_max — int
  • amount_threshold — bigint
  • decision_code — text
  • extra_rate_pct — int
  • exclusion_items — text
  • exclusion_years — int
  • recheck_months — int
  • reason_code — text — 외래 키 → if_uw_reason_code.reason_code
  • priority — int
  • valid_from — date
  • valid_to — date
  • use_yn — boolean

if_uw_rule_hit

  • hit_id — text — 기본 키 — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id — NOT NULL
  • rule_id — text — 외래 키 → if_uw_rule.rule_id — NOT NULL
  • hit_seq — int
  • evidence_type — text
  • disclosure_seq — int
  • evidence_value — text
  • rule_decision — text
  • applied_yn — boolean
  • hit_desc — text
  • evaluated_at — timestamptz

if_uw_status_hist

  • hist_id — text — 기본 키 — NOT NULL
  • case_id — text — 외래 키 → if_uw_case.case_id — NOT NULL
  • seq — int
  • status_code — text
  • status_name — text
  • changed_at — timestamptz
  • handler_id — text
  • elapsed_days — int
  • remark — text