FGC
Tables (50)
TB_FGC_ACL
- acl_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
- source_type — VARCHAR(14) — NOT NULL
- gross_amount — NUMERIC(15,2) — NOT NULL
- payout_rate_applied — NUMERIC(5,2)
- net_amount — NUMERIC(15,2) — NOT NULL
- accrual_year — INTEGER — NOT NULL
- due_date — DATE
- pay_mode — VARCHAR(10) — NOT NULL
- status — VARCHAR(12) — NOT NULL
- cap_included_snapshot — BOOLEAN — NOT NULL
- cap_check_id — BIGINT — Foreign key → TB_FGC_VCP.cap_check_id
- batch_exec_id — BIGINT
- close_id — BIGINT — Foreign key → TB_FGC_CLS.close_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_AFF
- aff_id — BIGINT — Primary key — NOT NULL
- agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
- insurer_agent_code — VARCHAR(30) — NOT NULL
- registered_on — DATE
- status — VARCHAR(12) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_ARB
- arb_check_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- checked_at — TIMESTAMPTZ — NOT NULL
- applies_yn — BOOLEAN — NOT NULL
- fee_sum_3y — NUMERIC(15,2) — NOT NULL
- surrender_36m — NUMERIC(15,2) — NOT NULL
- clawback_sum — NUMERIC(15,2) — NOT NULL
- paid_premium_sum — NUMERIC(15,2) — NOT NULL
- verdict — VARCHAR(8) — NOT NULL
- excluded_reason — VARCHAR(20)
- formula_snapshot — JSONB — NOT NULL
- exception_id — BIGINT — Foreign key → TB_FGC_EXC.exception_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_AUD
- audit_id — BIGINT — Primary key — NOT NULL
- actor_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
- actor_label — VARCHAR(50)
- action — VARCHAR(40) — NOT NULL
- entity_name — VARCHAR(60) — NOT NULL
- entity_id — BIGINT
- before_data — JSONB
- after_data — JSONB
- reason — VARCHAR(300)
- occurred_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
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
- multiplier — NUMERIC(6,2) — NOT NULL
- base_type — VARCHAR(30) — NOT NULL
- target_coverage — VARCHAR(12) — NOT NULL
- compliance_deduct_rate — NUMERIC(5,2)
- compliance_apply_from — DATE
- rule_from — DATE — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — 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
- trigger_event_id — BIGINT — Foreign key → TB_FGC_CSH.status_event_id — NOT NULL
- reason — VARCHAR(20) — NOT NULL
- lapse_installment — INTEGER — NOT NULL
- case_status — VARCHAR(14) — NOT NULL
- noticed_at — DATE
- objection_due — DATE
- repayment_due — DATE
- notice_amount — NUMERIC(15,2)
- amount_provisional_yn — BOOLEAN — NOT NULL
- notice_method — VARCHAR(20)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CBD
- clawback_line_id — BIGINT — Primary key — NOT NULL
- clawback_case_id — BIGINT — Foreign key → TB_FGC_CBC.clawback_case_id — NOT NULL
- target_acl_id — BIGINT — Foreign key → TB_FGC_ACL.acl_id — NOT NULL
- item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
- kind — VARCHAR(12) — NOT NULL
- paid_amount_base — NUMERIC(15,2) — NOT NULL
- clawback_rate_id — BIGINT — Foreign key → TB_FGC_CBR.clawback_rate_id
- applied_rate — NUMERIC(6,2) — NOT NULL
- clawback_amount — NUMERIC(15,2) — NOT NULL
- liable_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- calc_snapshot — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CBR
- clawback_rate_id — BIGINT — Primary key — NOT NULL
- policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
- scope — VARCHAR(14) — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id
- sector — VARCHAR(10)
- product_group_code — VARCHAR(2)
- item_scope — VARCHAR(30)
- reason_scope — VARCHAR(20)
- lapse_installment_from — INTEGER — NOT NULL
- lapse_installment_to — INTEGER — NOT NULL
- rate — NUMERIC(6,2) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CBV
- recovery_id — BIGINT — Primary key — NOT NULL
- clawback_case_id — BIGINT — Foreign key → TB_FGC_CBC.clawback_case_id — NOT NULL
- method — VARCHAR(18) — NOT NULL
- amount — NUMERIC(15,2) — NOT NULL
- recovered_on — DATE — NOT NULL
- payout_statement_id — BIGINT — Foreign key → TB_FGC_PYS.payout_statement_id
- remaining_balance — NUMERIC(15,2) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CCA
- alloc_id — BIGINT — Primary key — NOT NULL
- pool_id — BIGINT — Foreign key → TB_FGC_CCP.pool_id — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- allocated_amount — NUMERIC(15,2) — NOT NULL
- formula_snapshot — JSONB — NOT NULL
- acl_id — BIGINT — Foreign key → TB_FGC_ACL.acl_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CCP
- pool_id — BIGINT — Primary key — NOT NULL
- period_month — VARCHAR(7) — NOT NULL
- org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id
- cost_item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
- total_amount — NUMERIC(15,2) — NOT NULL
- alloc_basis — VARCHAR(24) — NOT NULL
- policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CLS
- close_id — BIGINT — Primary key — NOT NULL
- period_month — VARCHAR(7) — NOT NULL
- status — VARCHAR(12) — NOT NULL
- precheck_result — JSONB
- closed_by — BIGINT — Foreign key → TB_FGC_USR.user_id
- closed_at — TIMESTAMPTZ
- note — VARCHAR(300)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CON
- contract_id — BIGINT — Primary key — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
- policy_no — VARCHAR(40) — NOT NULL
- product_id — BIGINT — Foreign key → TB_FGC_PRD.product_id — NOT NULL
- writing_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- servicing_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id — NOT NULL
- contract_date — DATE — NOT NULL
- converted_monthly_premium — NUMERIC(15,2) — NOT NULL
- raw_premium_amount — NUMERIC(15,2)
- raw_premium_basis — VARCHAR(30)
- pay_cycle — VARCHAR(10) — NOT NULL
- pay_period_months — INTEGER
- coverage_class — VARCHAR(12) — NOT NULL
- status — VARCHAR(14) — NOT NULL
- regime — VARCHAR(10) — NOT NULL
- customer_ref — VARCHAR(60)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CSC
- schedule_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- plan_id — BIGINT — Foreign key → TB_FGC_DST.plan_id — NOT NULL
- acquisition_cost — NUMERIC(15,2) — NOT NULL
- basis_note — VARCHAR(300)
- monthly_maint_amount — NUMERIC(15,2) — NOT NULL
- policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
- generated_at — TIMESTAMPTZ — NOT NULL
- regenerated_of — BIGINT — Foreign key → TB_FGC_CSC.schedule_id
- active_yn — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CSH
- status_event_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- event_type — VARCHAR(20) — NOT NULL
- event_date — DATE — NOT NULL
- elapsed_installment — INTEGER
- amount — NUMERIC(15,2)
- before_status — VARCHAR(14) — NOT NULL
- after_status — VARCHAR(14) — NOT NULL
- source_upload_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_CSL
- schedule_line_id — BIGINT — Primary key — NOT NULL
- schedule_id — BIGINT — Foreign key → TB_FGC_CSC.schedule_id — NOT NULL
- seq — INTEGER — NOT NULL
- due_month — VARCHAR(7) — NOT NULL
- component_item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
- planned_amount — NUMERIC(15,2) — NOT NULL
- recipient_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- status_reason — VARCHAR(200)
- acl_id — BIGINT — Foreign key → TB_FGC_ACL.acl_id
- ledger_entry_id — BIGINT — Foreign key → TB_FGC_JEL.entry_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_DSC
- component_id — BIGINT — Primary key — NOT NULL
- plan_id — BIGINT — Foreign key → TB_FGC_DST.plan_id — NOT NULL
- component_code — VARCHAR(20) — NOT NULL
- monthly_rate — NUMERIC(6,3) — NOT NULL
- basis — VARCHAR(20) — NOT NULL
- from_seq — INTEGER — NOT NULL
- to_seq — INTEGER — NOT NULL
- cap_note — VARCHAR(200)
- reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id — NOT NULL
- unconfirmed_yn — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_DST
- plan_id — BIGINT — Primary key — NOT NULL
- plan_code — VARCHAR(10) — NOT NULL
- plan_name — VARCHAR(60) — NOT NULL
- total_installments — INTEGER — NOT NULL
- applies_contract_from — DATE — NOT NULL
- applies_contract_to — DATE
- reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_EXC
- exception_id — BIGINT — Primary key — NOT NULL
- exc_type — VARCHAR(24) — NOT NULL
- severity — VARCHAR(8) — NOT NULL
- status — VARCHAR(12) — NOT NULL
- ref_entity — VARCHAR(60) — NOT NULL
- ref_id — BIGINT — NOT NULL
- assignee_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
- opened_at — TIMESTAMPTZ — NOT NULL
- resolved_at — TIMESTAMPTZ
- resolution_note — VARCHAR(400)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_EXP
- expected_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
- installment_no — INTEGER
- period_month — VARCHAR(7) — NOT NULL
- expected_amount — NUMERIC(15,2) — NOT NULL
- basis_snapshot — JSONB — NOT NULL
- batch_exec_id — BIGINT
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_FC
- agent_id — BIGINT — Primary key — NOT NULL
- agent_code — VARCHAR(20) — NOT NULL
- agent_name — VARCHAR(60) — NOT NULL
- rank — VARCHAR(14) — NOT NULL
- org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id — NOT NULL
- recruiter_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
- appointed_on — DATE — NOT NULL
- terminated_on — DATE
- status — VARCHAR(12) — NOT NULL
- life_registered_yn — BOOLEAN — NOT NULL
- nonlife_registered_yn — BOOLEAN — NOT NULL
- guarantee_insured_yn — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_FCH
- agent_change_id — BIGINT — Primary key — NOT NULL
- agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- change_type — VARCHAR(14) — NOT NULL
- before_value — VARCHAR(60)
- after_value — VARCHAR(60)
- effective_from — DATE — NOT NULL
- reason — VARCHAR(200)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_INC
- incentive_id — BIGINT — Primary key — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id
- program_name — VARCHAR(200) — NOT NULL
- product_scope — VARCHAR(300)
- valid_from — DATE — NOT NULL
- valid_to — DATE — NOT NULL
- next_month_rate — NUMERIC(7,2)
- y2_after_rate — NUMERIC(7,2)
- condition_note — VARCHAR(400)
- source_doc — VARCHAR(200)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_INS
- insurer_id — BIGINT — Primary key — NOT NULL
- insurer_code — VARCHAR(20) — NOT NULL
- insurer_name — VARCHAR(100) — NOT NULL
- sector — VARCHAR(10) — NOT NULL
- lapse_deduct_timing — VARCHAR(12) — NOT NULL
- active_yn — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_IPD
- ipd_id — BIGINT — Primary key — NOT NULL
- ips_id — BIGINT — Foreign key → TB_FGC_IPS.ips_id — NOT NULL
- from_installment — INTEGER — NOT NULL
- to_installment — INTEGER — NOT NULL
- payable_yn — BOOLEAN — NOT NULL
- pay_timing — VARCHAR(10)
- note — VARCHAR(200)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_IPS
- ips_id — BIGINT — Primary key — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
- product_scope — VARCHAR(300)
- changed_from — DATE
- rule_note — VARCHAR(400)
- reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_ISL
- statement_line_id — BIGINT — Primary key — NOT NULL
- statement_id — BIGINT — Foreign key → TB_FGC_ISM.statement_id — NOT NULL
- line_type — VARCHAR(12) — NOT NULL
- policy_no_raw — VARCHAR(40) — NOT NULL
- matched_contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id
- item_raw — VARCHAR(60)
- matched_item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id
- installment_no — INTEGER
- amount — NUMERIC(15,2) — NOT NULL
- pay_date — DATE
- agent_code_raw — VARCHAR(30)
- matched_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_ISM
- statement_id — BIGINT — Primary key — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
- period_month — VARCHAR(7) — NOT NULL
- upload_file_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id — NOT NULL
- total_amount — NUMERIC(15,2)
- line_count — INTEGER
- status — VARCHAR(12) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_ITM
- item_id — BIGINT — Primary key — NOT NULL
- item_code — VARCHAR(30) — NOT NULL
- item_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(16) — NOT NULL
- cap_included_yn — BOOLEAN — NOT NULL
- arbitrage_included_yn — BOOLEAN — NOT NULL
- allocation_type — VARCHAR(12) — NOT NULL
- reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id — NOT NULL
- note — VARCHAR(300)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_JEH
- journal_id — BIGINT — Primary key — NOT NULL
- journal_no — VARCHAR(30) — NOT NULL
- journal_type — VARCHAR(14) — NOT NULL
- posted_at — TIMESTAMPTZ — NOT NULL
- reversal_of — BIGINT — Foreign key → TB_FGC_JEH.journal_id
- close_id — BIGINT — Foreign key → TB_FGC_CLS.close_id
- batch_exec_id — BIGINT
- description — VARCHAR(300)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_JEL
- entry_id — BIGINT — Primary key — NOT NULL
- journal_id — BIGINT — Foreign key → TB_FGC_JEH.journal_id — NOT NULL
- line_no — INTEGER — NOT NULL
- account_code — VARCHAR(30) — NOT NULL
- debit — NUMERIC(15,2) — NOT NULL
- credit — NUMERIC(15,2) — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id
- agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
- source_acl_id — BIGINT — Foreign key → TB_FGC_ACL.acl_id
- source_clawback_id — BIGINT — Foreign key → TB_FGC_CBD.clawback_line_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_MPC
- profile_col_id — BIGINT — Primary key — NOT NULL
- profile_id — BIGINT — Foreign key → TB_FGC_MPP.profile_id — NOT NULL
- source_column — VARCHAR(100) — NOT NULL
- target_field — VARCHAR(100) — NOT NULL
- transform_expr — VARCHAR(300)
- required_yn — BOOLEAN — NOT NULL
- sample_value — VARCHAR(100)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_MPP
- profile_id — BIGINT — Primary key — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
- file_type — VARCHAR(20) — NOT NULL
- profile_name — VARCHAR(100) — NOT NULL
- version_no — INTEGER — NOT NULL
- status — VARCHAR(10) — NOT NULL
- note — VARCHAR(300)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_ORG
- org_id — BIGINT — Primary key — NOT NULL
- org_code — VARCHAR(20) — NOT NULL
- org_name — VARCHAR(100) — NOT NULL
- org_type — VARCHAR(12) — NOT NULL
- parent_org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id
- manager_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
- assoc_registered_yn — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_PLV
- policy_version_id — BIGINT — Primary key — NOT NULL
- policy_type — VARCHAR(20) — NOT NULL
- version_no — INTEGER — NOT NULL
- effective_from — DATE — NOT NULL
- effective_to — DATE
- status — VARCHAR(10) — NOT NULL
- reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id — NOT NULL
- params — JSONB
- approved_by — VARCHAR(50)
- approved_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_PMH
- payment_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- installment_no — INTEGER — NOT NULL
- paid_on — DATE — NOT NULL
- paid_amount — NUMERIC(15,2) — NOT NULL
- method — VARCHAR(20)
- source_upload_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — 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_code — VARCHAR(30) — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- line — VARCHAR(12) — NOT NULL
- coverage_class — VARCHAR(12) — NOT NULL
- product_group — VARCHAR(30)
- sales_channel — VARCHAR(10) — NOT NULL
- clawback_group — VARCHAR(2)
- version_no — INTEGER — NOT NULL
- effective_from — DATE — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_PRT
- payout_rate_id — BIGINT — Primary key — NOT NULL
- policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
- scope — VARCHAR(14) — NOT NULL
- rank — VARCHAR(14)
- agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
- line — VARCHAR(12) — NOT NULL
- perf_band_from — NUMERIC(15,2)
- perf_band_to — NUMERIC(15,2)
- rate — NUMERIC(5,2) — NOT NULL
- agreement_type — VARCHAR(10) — NOT NULL
- valid_from_quarter — VARCHAR(7) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_PST
- persistency_id — BIGINT — Primary key — NOT NULL
- scope — VARCHAR(8) — NOT NULL
- scope_id — BIGINT
- base_month — VARCHAR(7) — NOT NULL
- k_installment — INTEGER — NOT NULL
- rate — NUMERIC(5,2) — NOT NULL
- numerator — NUMERIC(15,2)
- denominator — NUMERIC(15,2)
- include_flags — VARCHAR(100)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_PYS
- payout_statement_id — BIGINT — Primary key — NOT NULL
- agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- period_month — VARCHAR(7) — NOT NULL
- gross_total — NUMERIC(15,2) — NOT NULL
- clawback_offset — NUMERIC(15,2) — NOT NULL
- ops_fee_deduct — NUMERIC(15,2) — NOT NULL
- work_support_deduct — NUMERIC(15,2) — NOT NULL
- risk_reserve_deduct — NUMERIC(15,2) — NOT NULL
- taxable_income — NUMERIC(15,2) — NOT NULL
- income_tax — NUMERIC(15,2) — NOT NULL
- local_tax — NUMERIC(15,2) — NOT NULL
- net_pay — NUMERIC(15,2) — NOT NULL
- close_id — BIGINT — Foreign key → TB_FGC_CLS.close_id
- status — VARCHAR(12) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_RAS
- reassign_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- from_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- to_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
- reason — VARCHAR(20) — NOT NULL
- successor_pay_rate — NUMERIC(5,2) — NOT NULL
- effective_from — DATE — NOT NULL
- approved_by — BIGINT — Foreign key → TB_FGC_USR.user_id
- approved_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_RCL
- recon_line_id — BIGINT — Primary key — NOT NULL
- recon_run_id — BIGINT — Foreign key → TB_FGC_RCR.recon_run_id — NOT NULL
- expected_id — BIGINT — Foreign key → TB_FGC_EXP.expected_id
- statement_line_id — BIGINT — Foreign key → TB_FGC_ISL.statement_line_id
- diff_amount — NUMERIC(15,2) — NOT NULL
- mismatch_type — VARCHAR(20) — NOT NULL
- judgement — VARCHAR(10) — NOT NULL
- exception_id — BIGINT — Foreign key → TB_FGC_EXC.exception_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_RCR
- recon_run_id — BIGINT — Primary key — NOT NULL
- period_month — VARCHAR(7) — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
- ran_at — TIMESTAMPTZ — NOT NULL
- tolerance_policy_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
- matched_count — INTEGER
- mismatched_count — INTEGER
- status — VARCHAR(12) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_REG
- reg_id — BIGINT — Primary key — NOT NULL
- reg_code — VARCHAR(20) — NOT NULL
- title — VARCHAR(300) — NOT NULL
- source_type — VARCHAR(16) — NOT NULL
- source_ref — VARCHAR(300)
- effective_date — DATE
- unconfirmed_yn — BOOLEAN — NOT NULL
- note — VARCHAR(400)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_ROL
- role_id — BIGINT — Primary key — NOT NULL
- role_code — VARCHAR(20) — NOT NULL
- role_name — VARCHAR(60) — NOT NULL
- description — VARCHAR(200)
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_SRV
- surrender_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- as_of_installment — INTEGER — NOT NULL
- as_of_date — DATE
- amount — NUMERIC(15,2) — NOT NULL
- source — VARCHAR(10) — NOT NULL
- source_upload_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_STG
- staging_row_id — BIGINT — Primary key — NOT NULL
- upload_file_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id — NOT NULL
- row_no — INTEGER — NOT NULL
- raw_data — JSONB — NOT NULL
- normalized_data — JSONB
- valid_yn — BOOLEAN — NOT NULL
- error_message — VARCHAR(400)
- applied_entity — VARCHAR(60)
- applied_id — BIGINT
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_UPF
- upload_file_id — BIGINT — Primary key — NOT NULL
- file_name — VARCHAR(200) — NOT NULL
- file_hash — VARCHAR(64) — NOT NULL
- insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id
- file_type — VARCHAR(20) — NOT NULL
- period_month — VARCHAR(7) — NOT NULL
- uploaded_by — BIGINT — Foreign key → TB_FGC_USR.user_id — NOT NULL
- status — VARCHAR(12) — NOT NULL
- row_count — INTEGER
- error_count — INTEGER
- storage_path — VARCHAR(300) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_USR
- user_id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- user_name — VARCHAR(60) — NOT NULL
- role_id — BIGINT — Foreign key → TB_FGC_ROL.role_id — NOT NULL
- scope_org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id
- agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
- status — VARCHAR(12) — NOT NULL
- last_login_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL
TB_FGC_VCP
- cap_check_id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
- trigger_type — VARCHAR(20) — NOT NULL
- checked_at — TIMESTAMPTZ — NOT NULL
- cap_rule_id — BIGINT — Foreign key → TB_FGC_CAP.cap_rule_id — NOT NULL
- limit_amount — NUMERIC(15,2) — NOT NULL
- included_total — NUMERIC(15,2) — NOT NULL
- usage_pct — NUMERIC(7,2) — NOT NULL
- verdict — VARCHAR(8) — NOT NULL
- detail_snapshot — JSONB — NOT NULL
- exception_id — BIGINT — Foreign key → TB_FGC_EXC.exception_id
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT
- updated_at — TIMESTAMPTZ — NOT NULL