sample

Tables (44)

TB_FGC_ACC

  • account_code_id — BIGINT — Primary key — NOT NULL
  • account_code — VARCHAR(30) — NOT NULL
  • account_name — VARCHAR(100) — NOT NULL
  • account_type_code — VARCHAR(20) — NOT NULL
  • active_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_AFF

  • affiliation_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
  • affiliation_code — VARCHAR(100) — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_AUD

  • audit_log_id — BIGINT — Primary key — NOT NULL
  • actor_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • action_code — VARCHAR(50) — NOT NULL
  • target_type_code — VARCHAR(50) — NOT NULL
  • target_id — BIGINT
  • request_trace_id — VARCHAR(100)
  • before_payload — JSON
  • after_payload — JSON
  • occurred_at — DATETIME(6) — NOT NULL

TB_FGC_BR

  • branch_id — BIGINT — Primary key — NOT NULL
  • hq_id — BIGINT — Foreign key → TB_FGC_HQ.hq_id — NOT NULL
  • branch_code — VARCHAR(30) — NOT NULL
  • branch_name — VARCHAR(100) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — 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_status_history_id — BIGINT — Foreign key → TB_FGC_CSH.contract_status_history_id — NOT NULL
  • trigger_code — VARCHAR(30) — NOT NULL
  • paid_amount — BIGINT — NOT NULL
  • unamortized_amount — BIGINT — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • calculated_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_CBR

  • clawback_responsibility_id — BIGINT — Primary key — NOT NULL
  • clawback_case_id — BIGINT — Foreign key → TB_FGC_CBC.clawback_case_id — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • responsibility_type_code — VARCHAR(30) — NOT NULL
  • responsibility_rate — DECIMAL(9,4)
  • responsibility_amount — BIGINT
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_CFH

  • contract_fc_history_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
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • change_reason_code — VARCHAR(30)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_CIT

  • commission_item_id — BIGINT — Primary key — NOT NULL
  • item_code — VARCHAR(40) — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL
  • cap_include_default_yn — CHAR(1) — NOT NULL
  • active_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_CMP

  • column_mapping_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • file_type_code — VARCHAR(30) — NOT NULL
  • version_no — INT — NOT NULL
  • mapping_name — VARCHAR(100) — NOT NULL
  • mapping_definition — JSON — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — 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
  • customer_ref_id — BIGINT — Foreign key → TB_FGC_CUS.customer_ref_id — NOT NULL
  • current_fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • policy_no — VARCHAR(100) — NOT NULL
  • monthly_premium — BIGINT — NOT NULL
  • pay_term_months — INT — NOT NULL
  • issued_at — DATE — NOT NULL
  • status_code — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_CPS

  • contract_policy_snapshot_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • rate_table_id — BIGINT — Foreign key → TB_FGC_RT.rate_table_id — NOT NULL
  • retro_exception_id — BIGINT — Foreign key → TB_FGC_PRE.retro_exception_id
  • cap_multiplier — DECIMAL(9,4) — NOT NULL
  • cap_limit_amount — BIGINT — NOT NULL
  • schedule_months — INT — NOT NULL
  • rounding_code — VARCHAR(20) — NOT NULL
  • effective_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_CSC

  • commission_schedule_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • contract_policy_snapshot_id — BIGINT — Foreign key → TB_FGC_CPS.contract_policy_snapshot_id — NOT NULL
  • version_no — INT — NOT NULL
  • active_yn — CHAR(1) — NOT NULL
  • total_promised_amount — BIGINT — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • generated_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_CSH

  • contract_status_history_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • previous_status_code — VARCHAR(30)
  • new_status_code — VARCHAR(30) — NOT NULL
  • event_code — VARCHAR(30) — NOT NULL
  • event_at — DATETIME(6) — NOT NULL
  • reason_code — VARCHAR(30)
  • source_code — VARCHAR(30) — NOT NULL
  • created_by_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_CUS

  • customer_ref_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • customer_token — VARCHAR(255) — NOT NULL
  • token_type_code — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_CVR

  • cap_validation_id — BIGINT — Primary key — NOT NULL
  • settlement_item_id — BIGINT — Foreign key → TB_FGC_STI.settlement_item_id — NOT NULL
  • contract_policy_snapshot_id — BIGINT — Foreign key → TB_FGC_CPS.contract_policy_snapshot_id — NOT NULL
  • paid_before_amount — BIGINT — NOT NULL
  • current_amount — BIGINT — NOT NULL
  • total_after_amount — BIGINT — NOT NULL
  • cap_limit_amount — BIGINT — NOT NULL
  • excess_amount — BIGINT — NOT NULL
  • result_code — VARCHAR(20) — NOT NULL
  • validated_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_EXC

  • exception_case_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id
  • exception_type_code — VARCHAR(30) — NOT NULL
  • cap_validation_id — BIGINT — Foreign key → TB_FGC_CVR.cap_validation_id
  • replacement_case_id — BIGINT — Foreign key → TB_FGC_RPC.replacement_case_id
  • reconciliation_item_id — BIGINT
  • status_code — VARCHAR(20) — NOT NULL
  • reason_code — VARCHAR(50) — NOT NULL
  • assigned_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • decision_code — VARCHAR(30)
  • decision_note — VARCHAR(1000)
  • decided_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_FC

  • fc_id — BIGINT — Primary key — NOT NULL
  • fc_code — VARCHAR(50) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • appointment_date — DATE
  • termination_date — DATE
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_FOH

  • fc_org_history_id — BIGINT — Primary key — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id — NOT NULL
  • hq_id — BIGINT — Foreign key → TB_FGC_HQ.hq_id
  • branch_id — BIGINT — Foreign key → TB_FGC_BR.branch_id
  • position_code — VARCHAR(30) — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • primary_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_GA

  • ga_id — BIGINT — Primary key — NOT NULL
  • ga_code — VARCHAR(30) — NOT NULL
  • ga_name — VARCHAR(100) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_HLD

  • payment_hold_id — BIGINT — Primary key — NOT NULL
  • exception_case_id — BIGINT — Foreign key → TB_FGC_EXC.exception_case_id — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • hold_reason_code — VARCHAR(50) — NOT NULL
  • held_at — DATETIME(6) — NOT NULL
  • released_at — DATETIME(6)
  • released_by_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • release_reason — VARCHAR(1000)
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_HQ

  • hq_id — BIGINT — Primary key — NOT NULL
  • ga_id — BIGINT — Foreign key → TB_FGC_GA.ga_id — NOT NULL
  • hq_code — VARCHAR(30) — NOT NULL
  • hq_name — VARCHAR(100) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_IFL

  • import_file_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • column_mapping_id — BIGINT — Foreign key → TB_FGC_CMP.column_mapping_id
  • file_type_code — VARCHAR(30) — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • file_hash — VARCHAR(128) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • total_rows — INT — NOT NULL
  • success_rows — INT — NOT NULL
  • error_rows — INT — NOT NULL
  • uploaded_by_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • imported_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_INC

  • incentive_condition_id — BIGINT — Primary key — NOT NULL
  • rate_line_id — BIGINT — Foreign key → TB_FGC_RTL.rate_line_id — NOT NULL
  • condition_type_code — VARCHAR(30) — NOT NULL
  • operator_code — VARCHAR(20) — NOT NULL
  • threshold_value — DECIMAL(19,4)
  • threshold_unit_code — VARCHAR(20)
  • target_product_id — BIGINT — Foreign key → TB_FGC_PRD.product_id
  • maintenance_weeks — INT
  • description — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_INS

  • insurer_id — BIGINT — Primary key — NOT NULL
  • insurer_code — VARCHAR(30) — NOT NULL
  • insurer_name — VARCHAR(100) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_IRW

  • import_row_id — BIGINT — Primary key — NOT NULL
  • import_file_id — BIGINT — Foreign key → TB_FGC_IFL.import_file_id — NOT NULL
  • row_no — INT — NOT NULL
  • raw_payload — JSON — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id
  • fc_id — BIGINT — Foreign key → TB_FGC_FC.fc_id
  • contract_ref — VARCHAR(100)
  • fc_ref — VARCHAR(100)
  • insurer_code — VARCHAR(30)
  • tenor — INT
  • amount — BIGINT
  • payment_date — DATE
  • base_month — DATE
  • surrender_amount — BIGINT
  • standardize_status_code — VARCHAR(20) — NOT NULL
  • error_code — VARCHAR(50)
  • error_message — VARCHAR(1000)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_JE

  • journal_entry_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → TB_FGC_STR.settlement_run_id
  • settlement_item_id — BIGINT — Foreign key → TB_FGC_STI.settlement_item_id
  • clawback_case_id — BIGINT — Foreign key → TB_FGC_CBC.clawback_case_id
  • event_code — VARCHAR(30) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • reversal_of_entry_id — BIGINT — Foreign key → TB_FGC_JE.journal_entry_id
  • posted_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_JL

  • journal_line_id — BIGINT — Primary key — NOT NULL
  • journal_entry_id — BIGINT — Foreign key → TB_FGC_JE.journal_entry_id — NOT NULL
  • line_no — INT — NOT NULL
  • account_code_id — BIGINT — Foreign key → TB_FGC_ACC.account_code_id — NOT NULL
  • dr_cr_code — CHAR(1) — NOT NULL
  • amount — BIGINT — NOT NULL
  • rule_ref — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_NTF

  • notification_id — BIGINT — Primary key — NOT NULL
  • recipient_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id — NOT NULL
  • exception_case_id — BIGINT — Foreign key → TB_FGC_EXC.exception_case_id
  • notification_type_code — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • message — VARCHAR(2000) — NOT NULL
  • read_yn — CHAR(1) — NOT NULL
  • read_at — DATETIME(6)
  • created_at — DATETIME(6) — 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(50) — NOT NULL
  • version_no — INT — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • product_group_code — VARCHAR(30)
  • protection_yn — CHAR(1) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_PRE

  • retro_exception_id — BIGINT — Primary key — NOT NULL
  • rate_table_id — BIGINT — Foreign key → TB_FGC_RT.rate_table_id — NOT NULL
  • exception_code — VARCHAR(30) — NOT NULL
  • legal_basis — VARCHAR(500) — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • approved_by_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_RCI

  • reconciliation_item_id — BIGINT — Primary key — NOT NULL
  • reconciliation_run_id — BIGINT — Foreign key → TB_FGC_RCR.reconciliation_run_id — NOT NULL
  • settlement_item_id — BIGINT — Foreign key → TB_FGC_STI.settlement_item_id
  • import_row_id — BIGINT — Foreign key → TB_FGC_IRW.import_row_id
  • expected_amount — BIGINT
  • actual_amount — BIGINT
  • difference_amount — BIGINT
  • result_code — VARCHAR(20) — NOT NULL
  • reason_code — VARCHAR(50)
  • reviewed_by_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • reviewed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_RCR

  • reconciliation_run_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → TB_FGC_STR.settlement_run_id — NOT NULL
  • import_file_id — BIGINT — Foreign key → TB_FGC_IFL.import_file_id — NOT NULL
  • tolerance_amount — BIGINT — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • started_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_ROLE

  • role_id — BIGINT — Primary key — NOT NULL
  • role_code — VARCHAR(30) — NOT NULL
  • role_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_RPC

  • replacement_case_id — BIGINT — Primary key — NOT NULL
  • new_contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • customer_ref_id — BIGINT — Foreign key → TB_FGC_CUS.customer_ref_id — NOT NULL
  • detection_rule_code — VARCHAR(50) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • reviewer_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • review_decision_code — VARCHAR(30)
  • review_note — VARCHAR(1000)
  • detected_at — DATETIME(6) — NOT NULL
  • reviewed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_RPM

  • replacement_match_id — BIGINT — Primary key — NOT NULL
  • replacement_case_id — BIGINT — Foreign key → TB_FGC_RPC.replacement_case_id — NOT NULL
  • previous_contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id
  • external_contract_ref — VARCHAR(255)
  • similarity_reason_code — VARCHAR(50) — NOT NULL
  • matched_months — INT
  • similarity_score — DECIMAL(9,4)
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_RT

  • rate_table_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id
  • product_id — BIGINT — Foreign key → TB_FGC_PRD.product_id
  • policy_code — VARCHAR(50) — NOT NULL
  • version_no — INT — NOT NULL
  • policy_name — VARCHAR(200) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE
  • schedule_months — INT — NOT NULL
  • cap_multiplier — DECIMAL(9,4) — NOT NULL
  • rounding_code — VARCHAR(20) — NOT NULL
  • rule_ref — VARCHAR(255) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_RTL

  • rate_line_id — BIGINT — Primary key — NOT NULL
  • rate_table_id — BIGINT — Foreign key → TB_FGC_RT.rate_table_id — NOT NULL
  • commission_item_id — BIGINT — Foreign key → TB_FGC_CIT.commission_item_id — NOT NULL
  • from_tenor — INT — NOT NULL
  • to_tenor — INT — NOT NULL
  • calculation_base_code — VARCHAR(30) — NOT NULL
  • rate_value — DECIMAL(19,4) — NOT NULL
  • cap_include_yn — CHAR(1) — NOT NULL
  • advance_yn — CHAR(1) — NOT NULL
  • rule_ref — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_SCL

  • schedule_line_id — BIGINT — Primary key — NOT NULL
  • commission_schedule_id — BIGINT — Foreign key → TB_FGC_CSC.commission_schedule_id — NOT NULL
  • commission_item_id — BIGINT — Foreign key → TB_FGC_CIT.commission_item_id — NOT NULL
  • tenor — INT — NOT NULL
  • due_date — DATE — NOT NULL
  • calculated_amount — DECIMAL(19,4) — NOT NULL
  • posted_amount — BIGINT — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • rule_ref — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_SIM

  • simulation_scenario_id — BIGINT — Primary key — NOT NULL
  • scenario_name — VARCHAR(100) — NOT NULL
  • scenario_type_code — VARCHAR(30) — NOT NULL
  • input_parameters — JSON — NOT NULL
  • result_summary — JSON
  • created_by_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_STI

  • settlement_item_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → TB_FGC_STR.settlement_run_id — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • schedule_line_id — BIGINT — Foreign key → TB_FGC_SCL.schedule_line_id — NOT NULL
  • expected_amount — DECIMAL(19,4) — NOT NULL
  • common_expense_amount — BIGINT — NOT NULL
  • payable_amount — BIGINT — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • error_code — VARCHAR(50)
  • error_message — VARCHAR(1000)
  • retry_count — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

TB_FGC_STR

  • settlement_run_id — BIGINT — Primary key — NOT NULL
  • settlement_month — DATE — NOT NULL
  • run_no — INT — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • started_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • closed_at — DATETIME(6)
  • created_by_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_SVS

  • surrender_snapshot_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • base_month — DATE — NOT NULL
  • surrender_amount — BIGINT — NOT NULL
  • surrender_rate — DECIMAL(13,4)
  • import_row_id — BIGINT — Foreign key → TB_FGC_IRW.import_row_id
  • created_at — DATETIME(6) — NOT NULL

TB_FGC_UR

  • 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_ROLE.role_id — NOT NULL
  • effective_from — DATETIME(6) — NOT NULL
  • effective_to — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

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_name — VARCHAR(100) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • last_login_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL