ds_fisrtPJ
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