sample

Tables (50)

TB_FGC_AFF

  • aff_id — BIGINT — Primary key — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • insurer_fc_cd — VARCHAR(50) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • status_cd — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_ARB

  • arbitrage_case_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • related_contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • arbitrage_type_cd — VARCHAR(30) — NOT NULL
  • previous_termination_dt — DATE
  • new_contract_dt — DATE — NOT NULL
  • interval_days — INT
  • premium_change_rate — DECIMAL(12,6)
  • coverage_similarity_rate — DECIMAL(12,6)
  • case_status_cd — VARCHAR(30) — NOT NULL
  • detected_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_ARV

  • arbitrage_validation_id — BIGINT — Primary key — NOT NULL
  • arbitrage_case_id — BIGINT — Foreign key → TB_FGC_ARB.arbitrage_case_id — NOT NULL
  • validation_id — BIGINT — Foreign key → TB_FGC_VRF.validation_id — NOT NULL
  • criterion_cd — VARCHAR(50) — NOT NULL
  • criterion_result_cd — VARCHAR(30) — NOT NULL
  • criterion_value — DECIMAL(18,6)
  • threshold_value — DECIMAL(18,6)
  • block_payment_yn — CHAR(1) — NOT NULL
  • reviewer_comment — VARCHAR(2000)
  • reviewed_by — BIGINT — Foreign key → TB_FGC_USR.user_id
  • reviewed_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_AUD

  • audit_log_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • action_type_cd — VARCHAR(30) — NOT NULL
  • target_table_nm — VARCHAR(100) — NOT NULL
  • target_id — BIGINT
  • before_data — TEXT
  • after_data — TEXT
  • request_id — VARCHAR(100)
  • client_ip — VARCHAR(45)
  • occurred_at — DATETIME — NOT NULL

TB_FGC_BAS

  • batch_step_id — BIGINT — Primary key — NOT NULL
  • batch_id — BIGINT — Foreign key → TB_FGC_BAT.batch_id — NOT NULL
  • step_cd — VARCHAR(50) — NOT NULL
  • step_order — INT — NOT NULL
  • step_status_cd — VARCHAR(20) — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • read_count — BIGINT — NOT NULL
  • write_count — BIGINT — NOT NULL
  • skip_count — BIGINT — NOT NULL
  • failure_count — BIGINT — NOT NULL
  • checkpoint_value — VARCHAR(1000)
  • error_message — VARCHAR(2000)
  • created_at — DATETIME — NOT NULL

TB_FGC_BAT

  • batch_id — BIGINT — Primary key — NOT NULL
  • batch_job_cd — VARCHAR(50) — NOT NULL
  • business_dt — DATE — NOT NULL
  • execution_no — INT — NOT NULL
  • batch_status_cd — VARCHAR(20) — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • total_count — BIGINT — NOT NULL
  • success_count — BIGINT — NOT NULL
  • failure_count — BIGINT — NOT NULL
  • idempotency_key — VARCHAR(255) — NOT NULL
  • error_message — VARCHAR(2000)
  • created_at — DATETIME — NOT NULL

TB_FGC_BR

  • br_id — BIGINT — Primary key — NOT NULL
  • hq_id — BIGINT — Foreign key → TB_FGC_HQ.hq_id — NOT NULL
  • br_cd — VARCHAR(30) — NOT NULL
  • br_nm — VARCHAR(100) — NOT NULL
  • status_cd — VARCHAR(20) — NOT NULL
  • opened_dt — DATE
  • closed_dt — DATE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_CAP

  • cap_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • target_scope_cd — VARCHAR(30) — NOT NULL
  • cap_multiplier — DECIMAL(12,6) — NOT NULL
  • cap_period_months — INT — NOT NULL
  • base_amount_type_cd — VARCHAR(30) — NOT NULL
  • include_incentive_yn — CHAR(1) — NOT NULL
  • include_allowance_yn — CHAR(1) — NOT NULL
  • include_support_yn — CHAR(1) — NOT NULL
  • calculation_method_cd — VARCHAR(30) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_CBC

  • clawback_case_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • clawback_policy_id — BIGINT — Foreign key → TB_FGC_CBP.clawback_policy_id — NOT NULL
  • batch_id — BIGINT — Foreign key → TB_FGC_BAT.batch_id — NOT NULL
  • trigger_event_cd — VARCHAR(30) — NOT NULL
  • trigger_dt — DATE — NOT NULL
  • total_paid_amt — BIGINT — NOT NULL
  • refundable_basis_amt — BIGINT — NOT NULL
  • calculated_clawback_amt — BIGINT — NOT NULL
  • confirmed_clawback_amt — BIGINT — NOT NULL
  • recovered_amt — BIGINT — NOT NULL
  • outstanding_amt — BIGINT — NOT NULL
  • clawback_status_cd — VARCHAR(30) — NOT NULL
  • idempotency_key — VARCHAR(255) — NOT NULL
  • calculated_at — DATETIME — NOT NULL
  • confirmed_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_CBD

  • clawback_detail_id — BIGINT — Primary key — NOT NULL
  • clawback_case_id — BIGINT — Foreign key → TB_FGC_CBC.clawback_case_id — NOT NULL
  • schedule_line_id — BIGINT — Foreign key → TB_FGC_CSL.schedule_line_id — NOT NULL
  • clawback_rate_id — BIGINT — Foreign key → TB_FGC_CBR.clawback_rate_id — NOT NULL
  • surrender_refund_rate_id — BIGINT — Foreign key → TB_FGC_SRR.surrender_refund_rate_id
  • paid_tenor — INT — NOT NULL
  • paid_amt — BIGINT — NOT NULL
  • clawback_rate — DECIMAL(12,6) — NOT NULL
  • surrender_refund_rate — DECIMAL(12,6)
  • persistency_adjustment_rate — DECIMAL(12,6)
  • calculated_amt — BIGINT — NOT NULL
  • confirmed_amt — BIGINT — NOT NULL
  • rule_reference — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_CBP

  • clawback_policy_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • trigger_event_cd — VARCHAR(30) — NOT NULL
  • calculation_type_cd — VARCHAR(30) — NOT NULL
  • paid_basis_cd — VARCHAR(30) — NOT NULL
  • refund_basis_cd — VARCHAR(30)
  • persistency_basis_cd — VARCHAR(30)
  • max_paid_limit_yn — CHAR(1) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_CBR

  • clawback_rate_id — BIGINT — Primary key — NOT NULL
  • clawback_policy_id — BIGINT — Foreign key → TB_FGC_CBP.clawback_policy_id — NOT NULL
  • from_tenor — INT — NOT NULL
  • to_tenor — INT — NOT NULL
  • clawback_rate — DECIMAL(12,6) — NOT NULL
  • unearned_rate — DECIMAL(12,6)
  • reason_cd — VARCHAR(30)
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_CCD

  • commission_calc_detail_id — BIGINT — Primary key — NOT NULL
  • commission_calc_id — BIGINT — Foreign key → TB_FGC_CCM.commission_calc_id — NOT NULL
  • rate_detail_id — BIGINT — Foreign key → TB_FGC_RTD.rate_detail_id
  • incentive_rule_id — BIGINT — Foreign key → TB_FGC_INC.incentive_rule_id
  • commission_type_cd — VARCHAR(30) — NOT NULL
  • calculation_basis_cd — VARCHAR(30) — NOT NULL
  • applied_rate — DECIMAL(12,6)
  • basis_amt — BIGINT — NOT NULL
  • calculated_amt — BIGINT — NOT NULL
  • allowed_amt — BIGINT — NOT NULL
  • rule_reference — VARCHAR(1000) — NOT NULL
  • calculation_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_CCM

  • commission_calc_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • batch_id — BIGINT — Foreign key → TB_FGC_BAT.batch_id — NOT NULL
  • calculation_version — INT — NOT NULL
  • premium_basis_amt — BIGINT — NOT NULL
  • cap_basis_amt — BIGINT — NOT NULL
  • cap_limit_amt — BIGINT — NOT NULL
  • gross_commission_amt — BIGINT — NOT NULL
  • incentive_amt — BIGINT — NOT NULL
  • persistency_adjustment_amt — BIGINT — NOT NULL
  • total_commission_amt — BIGINT — NOT NULL
  • allowed_commission_amt — BIGINT — NOT NULL
  • excess_commission_amt — BIGINT — NOT NULL
  • calculation_status_cd — VARCHAR(30) — NOT NULL
  • idempotency_key — VARCHAR(255) — NOT NULL
  • calculated_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_CON

  • contract_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • product_id — BIGINT — Foreign key → TB_FGC_PRD.product_id — NOT NULL
  • product_version_id — BIGINT — Foreign key → TB_FGC_PRV.product_version_id — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • br_id — BIGINT — Foreign key → TB_FGC_BR.br_id — NOT NULL
  • aff_id — BIGINT — Foreign key → TB_FGC_AFF.aff_id
  • policy_no — VARCHAR(100) — NOT NULL
  • holder_key — VARCHAR(255)
  • insured_key — VARCHAR(255)
  • contract_status_cd — VARCHAR(30) — NOT NULL
  • payment_cycle_cd — VARCHAR(20) — NOT NULL
  • initial_premium_amt — BIGINT — NOT NULL
  • monthly_premium_amt — BIGINT — NOT NULL
  • pay_term_months — INT — NOT NULL
  • coverage_term_months — INT
  • application_dt — DATE
  • issue_dt — DATE — NOT NULL
  • commencement_dt — DATE
  • termination_dt — DATE
  • termination_reason_cd — VARCHAR(30)
  • received_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_CRH

  • contract_relation_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • related_contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • relation_type_cd — VARCHAR(30) — NOT NULL
  • relation_reason_cd — VARCHAR(100)
  • detected_dt — DATE — NOT NULL
  • confirmed_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_CSC

  • commission_schedule_id — BIGINT — Primary key — NOT NULL
  • commission_calc_id — BIGINT — Foreign key → TB_FGC_CCM.commission_calc_id — NOT NULL
  • distribution_rule_id — BIGINT — Foreign key → TB_FGC_DST.distribution_rule_id — NOT NULL
  • distribution_months — INT — NOT NULL
  • total_schedule_amt — BIGINT — NOT NULL
  • total_paid_amt — BIGINT — NOT NULL
  • total_clawback_amt — BIGINT — NOT NULL
  • schedule_status_cd — VARCHAR(30) — NOT NULL
  • schedule_version — INT — NOT NULL
  • generated_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_CSH

  • contract_status_hist_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • before_status_cd — VARCHAR(30)
  • after_status_cd — VARCHAR(30) — NOT NULL
  • reason_cd — VARCHAR(30)
  • effective_dt — DATE — NOT NULL
  • source_system_cd — VARCHAR(30)
  • received_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_CSL

  • schedule_line_id — BIGINT — Primary key — NOT NULL
  • commission_schedule_id — BIGINT — Foreign key → TB_FGC_CSC.commission_schedule_id — NOT NULL
  • tenor — INT — NOT NULL
  • due_dt — DATE — NOT NULL
  • commission_type_cd — VARCHAR(30) — NOT NULL
  • scheduled_amt — BIGINT — NOT NULL
  • confirmed_amt — BIGINT — NOT NULL
  • paid_amt — BIGINT — NOT NULL
  • clawback_amt — BIGINT — NOT NULL
  • schedule_status_cd — VARCHAR(30) — NOT NULL
  • hold_reason_cd — VARCHAR(30)
  • rule_reference — VARCHAR(1000) — NOT NULL
  • confirmed_at — DATETIME
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_DST

  • distribution_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • distribution_type_cd — VARCHAR(30) — NOT NULL
  • distribution_months — INT — NOT NULL
  • initial_payment_months — INT — NOT NULL
  • initial_payment_rate — DECIMAL(12,6) — NOT NULL
  • maintenance_payment_rate — DECIMAL(12,6) — NOT NULL
  • equal_distribution_yn — CHAR(1) — NOT NULL
  • rounding_method_cd — VARCHAR(20) — NOT NULL
  • rounding_unit — INT — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_FC

  • fc_id — BIGINT — Primary key — NOT NULL
  • fc_cd — VARCHAR(30) — NOT NULL
  • fc_nm — VARCHAR(100) — NOT NULL
  • fc_status_cd — VARCHAR(20) — NOT NULL
  • commissioned_dt — DATE
  • terminated_dt — DATE
  • settlement_bank_cd — VARCHAR(20)
  • settlement_account_token — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_FCA

  • fca_id — BIGINT — Primary key — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • br_id — BIGINT — Foreign key → TB_FGC_BR.br_id — NOT NULL
  • start_dt — DATE — NOT NULL
  • end_dt — DATE
  • affiliation_status_cd — VARCHAR(20) — NOT NULL
  • primary_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_GA

  • ga_id — BIGINT — Primary key — NOT NULL
  • ga_cd — VARCHAR(30) — NOT NULL
  • ga_nm — VARCHAR(100) — NOT NULL
  • biz_no — VARCHAR(20)
  • status_cd — VARCHAR(20) — NOT NULL
  • opened_dt — DATE
  • closed_dt — DATE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_HQ

  • hq_id — BIGINT — Primary key — NOT NULL
  • ga_id — BIGINT — Foreign key → TB_FGC_GA.ga_id — NOT NULL
  • hq_cd — VARCHAR(30) — NOT NULL
  • hq_nm — VARCHAR(100) — NOT NULL
  • status_cd — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_INC

  • incentive_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • product_version_id — BIGINT — Foreign key → TB_FGC_PRV.product_version_id — NOT NULL
  • from_tenor — INT — NOT NULL
  • to_tenor — INT — NOT NULL
  • incentive_rate — DECIMAL(12,6)
  • fixed_incentive_amt — BIGINT
  • calculation_basis_cd — VARCHAR(30) — NOT NULL
  • max_incentive_amt — BIGINT
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_INS

  • insurer_id — BIGINT — Primary key — NOT NULL
  • insurer_cd — VARCHAR(30) — NOT NULL
  • insurer_nm — VARCHAR(100) — NOT NULL
  • insurer_type_cd — VARCHAR(20)
  • status_cd — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_JEH

  • journal_entry_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → TB_FGC_STR.settlement_run_id — NOT NULL
  • journal_no — VARCHAR(100) — NOT NULL
  • accounting_dt — DATE — NOT NULL
  • journal_type_cd — VARCHAR(30) — NOT NULL
  • journal_status_cd — VARCHAR(30) — NOT NULL
  • description — VARCHAR(1000)
  • reversal_entry_id — BIGINT — Foreign key → TB_FGC_JEH.journal_entry_id
  • posted_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_JEL

  • journal_line_id — BIGINT — Primary key — NOT NULL
  • journal_entry_id — BIGINT — Foreign key → TB_FGC_JEH.journal_entry_id — NOT NULL
  • settlement_detail_id — BIGINT — Foreign key → TB_FGC_STD.settlement_detail_id — NOT NULL
  • account_cd — VARCHAR(50) — NOT NULL
  • dr_cr_cd — CHAR(1) — NOT NULL
  • amount — BIGINT — NOT NULL
  • source_type_cd — VARCHAR(30) — NOT NULL
  • rule_reference — VARCHAR(1000) — NOT NULL
  • line_no — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_NTF

  • notification_id — BIGINT — Primary key — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • notification_type_cd — VARCHAR(30) — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • content — TEXT — NOT NULL
  • reference_type_cd — VARCHAR(30)
  • reference_id — BIGINT
  • read_yn — CHAR(1) — NOT NULL
  • sent_at — DATETIME
  • read_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_PLC

  • policy_id — BIGINT — Primary key — NOT NULL
  • policy_cd — VARCHAR(50) — NOT NULL
  • policy_nm — VARCHAR(200) — NOT NULL
  • policy_type_cd — VARCHAR(30) — NOT NULL
  • authority_type_cd — VARCHAR(20) — NOT NULL
  • description — VARCHAR(1000)
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_PLV

  • policy_version_id — BIGINT — Primary key — NOT NULL
  • policy_id — BIGINT — Foreign key → TB_FGC_PLC.policy_id — NOT NULL
  • version_no — INT — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • approval_status_cd — VARCHAR(20) — NOT NULL
  • law_reference — VARCHAR(1000)
  • change_reason — VARCHAR(1000)
  • approved_by — BIGINT — Foreign key → TB_FGC_USR.user_id
  • approved_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_PMH

  • premium_hist_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • payment_seq — INT — NOT NULL
  • due_dt — DATE — NOT NULL
  • paid_dt — DATE
  • premium_amt — BIGINT — NOT NULL
  • payment_status_cd — VARCHAR(30) — NOT NULL
  • source_system_cd — VARCHAR(30)
  • created_at — DATETIME — NOT NULL

TB_FGC_PRD

  • product_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • product_cd — VARCHAR(50) — NOT NULL
  • product_nm — VARCHAR(200) — NOT NULL
  • product_type_cd — VARCHAR(30) — NOT NULL
  • protection_yn — CHAR(1) — NOT NULL
  • status_cd — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_PRV

  • product_version_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → TB_FGC_PRD.product_id — NOT NULL
  • version_no — INT — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • min_pay_term_months — INT
  • max_pay_term_months — INT
  • min_premium_amt — BIGINT
  • max_premium_amt — BIGINT
  • status_cd — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_PSD

  • persistency_stat_detail_id — BIGINT — Primary key — NOT NULL
  • persistency_stat_id — BIGINT — Foreign key → TB_FGC_PST.persistency_stat_id — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • denominator_yn — CHAR(1) — NOT NULL
  • numerator_yn — CHAR(1) — NOT NULL
  • contract_status_cd — VARCHAR(30) — NOT NULL
  • evaluation_dt — DATE — NOT NULL
  • exclusion_reason_cd — VARCHAR(30)
  • created_at — DATETIME — NOT NULL

TB_FGC_PSR

  • persistency_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • evaluation_tenor — INT — NOT NULL
  • minimum_rate — DECIMAL(12,6) — NOT NULL
  • target_rate — DECIMAL(12,6) — NOT NULL
  • incentive_rate — DECIMAL(12,6)
  • penalty_rate — DECIMAL(12,6)
  • denominator_rule_cd — VARCHAR(30) — NOT NULL
  • numerator_rule_cd — VARCHAR(30) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_PST

  • persistency_stat_id — BIGINT — Primary key — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • br_id — BIGINT — Foreign key → TB_FGC_BR.br_id — NOT NULL
  • persistency_rule_id — BIGINT — Foreign key → TB_FGC_PSR.persistency_rule_id — NOT NULL
  • base_dt — DATE — NOT NULL
  • evaluation_tenor — INT — NOT NULL
  • denominator_count — BIGINT — NOT NULL
  • numerator_count — BIGINT — NOT NULL
  • persistency_rate — DECIMAL(12,6) — NOT NULL
  • grade_cd — VARCHAR(20)
  • adjustment_rate — DECIMAL(12,6)
  • confirmed_yn — CHAR(1) — NOT NULL
  • calculated_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_PYF

  • payment_file_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → TB_FGC_STR.settlement_run_id — NOT NULL
  • file_no — VARCHAR(100) — NOT NULL
  • bank_cd — VARCHAR(20) — NOT NULL
  • file_status_cd — VARCHAR(30) — NOT NULL
  • record_count — BIGINT — NOT NULL
  • total_payment_amt — BIGINT — NOT NULL
  • file_hash — VARCHAR(255)
  • generated_at — DATETIME — NOT NULL
  • transmitted_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_PYR

  • payment_result_id — BIGINT — Primary key — NOT NULL
  • payment_file_id — BIGINT — Foreign key → TB_FGC_PYF.payment_file_id — NOT NULL
  • settlement_target_id — BIGINT — Foreign key → TB_FGC_STT.settlement_target_id — NOT NULL
  • payment_tx_no — VARCHAR(100)
  • payment_amt — BIGINT — NOT NULL
  • payment_result_cd — VARCHAR(30) — NOT NULL
  • failure_reason_cd — VARCHAR(50)
  • requested_at — DATETIME
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_ROL

  • role_id — BIGINT — Primary key — NOT NULL
  • role_cd — VARCHAR(50) — NOT NULL
  • role_nm — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

TB_FGC_RT

  • rate_table_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • rate_table_cd — VARCHAR(50) — NOT NULL
  • rate_table_nm — VARCHAR(200) — NOT NULL
  • rate_type_cd — VARCHAR(30) — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_RTD

  • rate_detail_id — BIGINT — Primary key — NOT NULL
  • rate_table_id — BIGINT — Foreign key → TB_FGC_RT.rate_table_id — NOT NULL
  • condition_type_cd — VARCHAR(30) — NOT NULL
  • condition_from — DECIMAL(18,6)
  • condition_to — DECIMAL(18,6)
  • rate_value — DECIMAL(12,6)
  • fixed_amount — BIGINT
  • rule_reference — VARCHAR(1000) — NOT NULL
  • priority_no — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_SRR

  • surrender_refund_rate_id — BIGINT — Primary key — NOT NULL
  • product_version_id — BIGINT — Foreign key → TB_FGC_PRV.product_version_id — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • from_tenor — INT — NOT NULL
  • to_tenor — INT — NOT NULL
  • surrender_refund_rate — DECIMAL(12,6) — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • created_at — DATETIME — NOT NULL

TB_FGC_STD

  • settlement_detail_id — BIGINT — Primary key — NOT NULL
  • settlement_target_id — BIGINT — Foreign key → TB_FGC_STT.settlement_target_id — NOT NULL
  • schedule_line_id — BIGINT — Foreign key → TB_FGC_CSL.schedule_line_id
  • clawback_case_id — BIGINT — Foreign key → TB_FGC_CBC.clawback_case_id
  • settlement_type_cd — VARCHAR(30) — NOT NULL
  • original_amt — BIGINT — NOT NULL
  • adjustment_amt — BIGINT — NOT NULL
  • settlement_amt — BIGINT — NOT NULL
  • source_type_cd — VARCHAR(30) — NOT NULL
  • rule_reference — VARCHAR(1000) — NOT NULL
  • result_cd — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_STR

  • settlement_run_id — BIGINT — Primary key — NOT NULL
  • batch_id — BIGINT — Foreign key → TB_FGC_BAT.batch_id — NOT NULL
  • settlement_cycle_cd — VARCHAR(20) — NOT NULL
  • settlement_from_dt — DATE — NOT NULL
  • settlement_to_dt — DATE — NOT NULL
  • payment_due_dt — DATE — NOT NULL
  • execution_no — INT — NOT NULL
  • settlement_status_cd — VARCHAR(30) — NOT NULL
  • total_payment_amt — BIGINT — NOT NULL
  • total_clawback_amt — BIGINT — NOT NULL
  • net_settlement_amt — BIGINT — NOT NULL
  • idempotency_key — VARCHAR(255) — NOT NULL
  • confirmed_at — DATETIME
  • created_at — DATETIME — NOT NULL

TB_FGC_STT

  • settlement_target_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → TB_FGC_STR.settlement_run_id — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • br_id — BIGINT — Foreign key → TB_FGC_BR.br_id — NOT NULL
  • gross_payment_amt — BIGINT — NOT NULL
  • clawback_amt — BIGINT — NOT NULL
  • adjustment_amt — BIGINT — NOT NULL
  • net_payment_amt — BIGINT — NOT NULL
  • payment_hold_yn — CHAR(1) — NOT NULL
  • hold_reason_cd — VARCHAR(30)
  • settlement_status_cd — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

TB_FGC_URL

  • user_role_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → TB_FGC_USR.user_id — NOT NULL
  • role_id — BIGINT — Foreign key → TB_FGC_ROL.role_id — NOT NULL
  • granted_at — DATETIME — NOT NULL
  • granted_by — BIGINT — Foreign key → TB_FGC_USR.user_id

TB_FGC_USR

  • user_id — BIGINT — Primary key — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id
  • login_id — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • user_nm — VARCHAR(100) — NOT NULL
  • user_status_cd — VARCHAR(20) — NOT NULL
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

TB_FGC_VCP

  • cap_validation_id — BIGINT — Primary key — NOT NULL
  • validation_id — BIGINT — Foreign key → TB_FGC_VRF.validation_id — NOT NULL
  • cap_rule_id — BIGINT — Foreign key → TB_FGC_CAP.cap_rule_id — NOT NULL
  • cap_basis_amt — BIGINT — NOT NULL
  • cap_multiplier — DECIMAL(12,6) — NOT NULL
  • cap_limit_amt — BIGINT — NOT NULL
  • calculated_reward_amt — BIGINT — NOT NULL
  • excess_amt — BIGINT — NOT NULL
  • result_cd — VARCHAR(30) — NOT NULL
  • calculation_json — TEXT
  • created_at — DATETIME — NOT NULL

TB_FGC_VRF

  • validation_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • commission_calc_id — BIGINT — Foreign key → TB_FGC_CCM.commission_calc_id
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • batch_id — BIGINT — Foreign key → TB_FGC_BAT.batch_id — NOT NULL
  • validation_type_cd — VARCHAR(30) — NOT NULL
  • validation_result_cd — VARCHAR(30) — NOT NULL
  • severity_cd — VARCHAR(20) — NOT NULL
  • error_cd — VARCHAR(50)
  • error_message — VARCHAR(2000)
  • detected_amt — BIGINT
  • override_yn — CHAR(1) — NOT NULL
  • overridden_by — BIGINT — Foreign key → TB_FGC_USR.user_id
  • overridden_at — DATETIME
  • validated_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL