보험 더미 디비
테이블 (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