FGC

Tables (48)

CLAWBACK_ALLOCATION

  • clawback_allocation_id — BIGINT — Primary key — NOT NULL
  • clawback_case_id — BIGINT — Foreign key → CLAWBACK_CASE.clawback_case_id — NOT NULL
  • original_journal_line_id — BIGINT — Foreign key → JOURNAL_LINE.journal_line_id
  • responsible_party_type_cd — VARCHAR(20)
  • responsible_party_id — BIGINT
  • fc_id — BIGINT — Foreign key → TB_FGC_FC_BSC.fc_id
  • original_paid_amt — BIGINT
  • applied_clawback_rate — DECIMAL(12,8)
  • clawback_amt — BIGINT
  • recovered_amt — BIGINT
  • outstanding_amt — BIGINT
  • allocation_status_cd — VARCHAR(20)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

CLAWBACK_CASE

  • clawback_case_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → CONTRACT.contract_id — NOT NULL
  • trigger_status_history_id — BIGINT — Foreign key → CONTRACT_STATUS_HISTORY.status_history_id
  • statement_line_id — BIGINT — Foreign key → INSURER_STATEMENT_LINE.statement_line_id
  • ga_policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • elapsed_installment_no — INT
  • paid_amt — BIGINT
  • expected_clawback_amt — BIGINT
  • insurer_actual_clawback_amt — BIGINT
  • internal_clawback_amt — BIGINT
  • recovered_amt — BIGINT
  • outstanding_amt — BIGINT
  • case_status_cd — VARCHAR(30)
  • created_dt — DATETIME
  • confirmed_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

COMMISSION_ITEM

  • commission_item_cd — VARCHAR(30) — Primary key — NOT NULL
  • commission_item_nm — VARCHAR(100) — NOT NULL
  • item_group_cd — VARCHAR(30) — NOT NULL
  • amount_direction_cd — VARCHAR(20)
  • item_desc — VARCHAR(500)
  • use_yn — CHAR(1)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

COMMISSION_SCHEDULE

  • commission_schedule_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → CONTRACT.contract_id — NOT NULL
  • schedule_version_no — INT
  • commission_rate_version_id — BIGINT — Foreign key → INSURER_COMMISSION_RATE_VERSION.commission_rate_version_id
  • ga_policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • limit_policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • total_insurer_expected_amt — BIGINT
  • total_scheduled_amt — BIGINT
  • schedule_status_cd — VARCHAR(20)
  • generated_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

COMPLIANCE_LIMIT_ITEM

  • limit_item_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id — NOT NULL
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd — NOT NULL
  • include_yn — CHAR(1)
  • amount_basis_cd — VARCHAR(30)
  • exclusion_reason — VARCHAR(500)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

COMPLIANCE_LIMIT_RULE

  • limit_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id — NOT NULL
  • limit_type_cd — VARCHAR(30)
  • limit_scope_cd — VARCHAR(30)
  • base_premium_type_cd — VARCHAR(30)
  • limit_multiple — DECIMAL(9,4) — NOT NULL
  • limit_period_months — INT
  • formula_cd — VARCHAR(50)
  • rounding_rule_cd — VARCHAR(30)
  • warning_usage_rate — DECIMAL(9,4)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

CONTRACT

  • contract_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → INSURER.insurer_id — NOT NULL
  • product_version_id — BIGINT — Foreign key → INSURER_PRODUCT_VERSION.product_version_id — NOT NULL
  • policy_no — VARCHAR(100) — NOT NULL
  • application_no — VARCHAR(100)
  • customer_key — VARCHAR(100)
  • fc_id — BIGINT — Foreign key → TB_FGC_FC_BSC.fc_id — NOT NULL
  • fc_affiliation_id — BIGINT — Foreign key → FC_AFFILIATION.fc_affiliation_id
  • premium_cycle_cd — VARCHAR(20)
  • installment_premium_amt — BIGINT
  • monthly_equiv_premium_amt — BIGINT — NOT NULL
  • first_premium_amt — BIGINT
  • pay_term_months — INT
  • insurance_term_months — INT
  • application_dt — DATE
  • issued_dt — DATE
  • coverage_start_dt — DATE
  • current_status_cd — VARCHAR(20)
  • status_effective_dt — DATE
  • paid_installment_no — INT
  • source_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • source_row_no — INT
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

CONTRACT_STATUS_HISTORY

  • status_history_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → CONTRACT.contract_id
  • previous_status_cd — VARCHAR(20)
  • new_status_cd — VARCHAR(20)
  • status_effective_dt — DATE
  • received_dt — DATETIME
  • reason_cd — VARCHAR(30)
  • source_type_cd — VARCHAR(20)
  • source_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • source_row_no — INT
  • verification_status_cd — VARCHAR(20)
  • event_key — VARCHAR(150)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

FC_AFFILIATION

  • fc_affiliation_id — BIGINT — Primary key — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC_BSC.fc_id
  • insurer_id — BIGINT — Foreign key → INSURER.insurer_id
  • external_fc_cd — VARCHAR(100)
  • valid_from — DATE
  • valid_to — DATE
  • status_cd — VARCHAR(20)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

FIRST_YEAR_LIMIT_CHECK

  • limit_check_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → SETTLEMENT_RUN.settlement_run_id — NOT NULL
  • contract_id — BIGINT — Foreign key → CONTRACT.contract_id — NOT NULL
  • recipient_fc_id — BIGINT — Foreign key → TB_FGC_FC_BSC.fc_id
  • policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id — NOT NULL
  • limit_period_from — DATE
  • limit_period_to — DATE
  • monthly_equiv_premium_amt — BIGINT
  • limit_multiple — DECIMAL(9,4)
  • limit_amt — BIGINT — NOT NULL
  • previous_confirmed_amt — BIGINT
  • current_target_amt — BIGINT
  • adjustment_amt — BIGINT
  • after_used_amt — BIGINT
  • remaining_amt — BIGINT
  • excess_amt — BIGINT
  • usage_rate — DECIMAL(9,4)
  • check_result_cd — VARCHAR(20)
  • check_status_cd — VARCHAR(20)
  • checked_dt — DATETIME
  • confirmed_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

FIRST_YEAR_LIMIT_CHECK_ITEM

  • limit_check_item_id — BIGINT — Primary key — NOT NULL
  • limit_check_id — BIGINT — Foreign key → FIRST_YEAR_LIMIT_CHECK.limit_check_id — NOT NULL
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd
  • include_yn — CHAR(1)
  • previous_confirmed_amt — BIGINT
  • current_target_amt — BIGINT
  • adjustment_amt — BIGINT
  • after_used_amt — BIGINT
  • exclusion_reason — VARCHAR(500)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

GA_CLAWBACK_RATE

  • ga_clawback_rate_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • product_version_id — BIGINT — Foreign key → INSURER_PRODUCT_VERSION.product_version_id
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd
  • installment_from — INT
  • installment_to — INT
  • clawback_rate — DECIMAL(12,8)
  • responsibility_scope_cd — VARCHAR(30)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

GA_COMMON_COST_RULE

  • common_cost_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • product_version_id — BIGINT — Foreign key → INSURER_PRODUCT_VERSION.product_version_id
  • allocation_basis_cd — VARCHAR(30)
  • allocation_rate — DECIMAL(12,8)
  • limit_include_yn — CHAR(1)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

GA_INCENTIVE_RULE

  • incentive_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • product_version_id — BIGINT — Foreign key → INSURER_PRODUCT_VERSION.product_version_id
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd
  • installment_from — INT
  • installment_to — INT
  • allocation_basis_cd — VARCHAR(30)
  • incentive_rate — DECIMAL(12,8)
  • fixed_amt — BIGINT
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

GA_ORG_COMMISSION_RULE

  • org_commission_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • product_version_id — BIGINT — Foreign key → INSURER_PRODUCT_VERSION.product_version_id
  • fc_position_cd — VARCHAR(30) — Foreign key → TB_FGC_FC_POSITION.fc_position_cd
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd
  • allocation_rate — DECIMAL(12,8)
  • priority_no — INT
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

IMPORT_ERROR

  • import_error_id — BIGINT — Primary key — NOT NULL
  • import_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • import_row_id — BIGINT — Foreign key → IMPORT_ROW.import_row_id
  • error_cd — VARCHAR(50)
  • column_nm — VARCHAR(100)
  • raw_value — VARCHAR(1000)
  • error_message — VARCHAR(1000)
  • resolved_yn — CHAR(1)
  • resolved_user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • resolved_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

IMPORT_FILE

  • import_file_id — BIGINT — Primary key — NOT NULL
  • file_type_cd — VARCHAR(30)
  • insurer_id — BIGINT — Foreign key → INSURER.insurer_id
  • original_file_nm — VARCHAR(300)
  • storage_path — VARCHAR(1000)
  • file_hash — VARCHAR(128)
  • file_size — BIGINT
  • settlement_month — CHAR(6)
  • import_status_cd — VARCHAR(20)
  • total_row_cnt — INT
  • success_row_cnt — INT
  • error_row_cnt — INT
  • uploaded_user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • uploaded_dt — DATETIME

IMPORT_ROW

  • import_row_id — BIGINT — Primary key — NOT NULL
  • import_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • row_no — INT
  • raw_payload — LONGTEXT
  • mapping_status_cd — VARCHAR(20)
  • business_entity_type_cd — VARCHAR(30)
  • business_entity_id — BIGINT
  • processed_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

INSURER

  • 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)
  • effective_from — DATE
  • effective_to — DATE
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_CLAWBACK_RATE

  • clawback_rate_id — BIGINT — Primary key — NOT NULL
  • clawback_rate_version_id — BIGINT — Foreign key → INSURER_CLAWBACK_RATE_VERSION.clawback_rate_version_id
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd
  • installment_from — INT
  • installment_to — INT
  • clawback_rate — DECIMAL(12,8)
  • trigger_status_cd — VARCHAR(30)
  • rule_ref — VARCHAR(200)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_CLAWBACK_RATE_VERSION

  • clawback_rate_version_id — BIGINT — Primary key — NOT NULL
  • product_version_id — BIGINT — Foreign key → INSURER_PRODUCT_VERSION.product_version_id
  • version_no — INT
  • effective_from — DATE
  • effective_to — DATE
  • status_cd — VARCHAR(20)
  • source_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_COMMISSION_RATE

  • commission_rate_id — BIGINT — Primary key — NOT NULL
  • commission_rate_version_id — BIGINT — Foreign key → INSURER_COMMISSION_RATE_VERSION.commission_rate_version_id
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd
  • installment_from — INT
  • installment_to — INT
  • rate_basis_cd — VARCHAR(30)
  • rate_value — DECIMAL(12,8)
  • fixed_amt — BIGINT
  • payment_condition_cd — VARCHAR(30)
  • rule_ref — VARCHAR(200)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_COMMISSION_RATE_VERSION

  • commission_rate_version_id — BIGINT — Primary key — NOT NULL
  • product_version_id — BIGINT — Foreign key → INSURER_PRODUCT_VERSION.product_version_id
  • version_no — INT
  • effective_from — DATE
  • effective_to — DATE
  • status_cd — VARCHAR(20)
  • source_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_PRODUCT

  • insurer_product_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → INSURER.insurer_id — NOT NULL
  • product_cd — VARCHAR(100) — NOT NULL
  • product_nm — VARCHAR(200) — NOT NULL
  • product_type_cd — VARCHAR(30)
  • coverage_type_cd — VARCHAR(30)
  • status_cd — VARCHAR(20)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_PRODUCT_VERSION

  • product_version_id — BIGINT — Primary key — NOT NULL
  • insurer_product_id — BIGINT — Foreign key → INSURER_PRODUCT.insurer_product_id
  • version_no — INT
  • version_nm — VARCHAR(100)
  • effective_from — DATE
  • effective_to — DATE
  • version_status_cd — VARCHAR(20)
  • source_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_STATEMENT

  • statement_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → INSURER.insurer_id — NOT NULL
  • settlement_month — CHAR(6) — NOT NULL
  • statement_type_cd — VARCHAR(20)
  • import_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • statement_status_cd — VARCHAR(20)
  • imported_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_STATEMENT_LINE

  • statement_line_id — BIGINT — Primary key — NOT NULL
  • statement_id — BIGINT — Foreign key → INSURER_STATEMENT.statement_id — NOT NULL
  • contract_id — BIGINT — Foreign key → CONTRACT.contract_id
  • policy_no — VARCHAR(100)
  • fc_affiliation_id — BIGINT — Foreign key → FC_AFFILIATION.fc_affiliation_id
  • installment_no — INT
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd — NOT NULL
  • transaction_type_cd — VARCHAR(20)
  • calculated_amt — BIGINT
  • paid_amt — BIGINT
  • adjustment_amt — BIGINT
  • clawback_amt — BIGINT
  • net_amt — BIGINT
  • mapping_status_cd — VARCHAR(20)
  • source_row_no — INT
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

INSURER_SURRENDER_RATE

  • surrender_rate_id — BIGINT — Primary key — NOT NULL
  • surrender_rate_version_id — BIGINT — Foreign key → INSURER_SURRENDER_RATE_VERSION.surrender_rate_version_id
  • installment_from — INT
  • installment_to — INT
  • cash_surrender_value_rate — DECIMAL(12,8)
  • rule_ref — VARCHAR(200)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

INSURER_SURRENDER_RATE_VERSION

  • surrender_rate_version_id — BIGINT — Primary key — NOT NULL
  • product_version_id — BIGINT — Foreign key → INSURER_PRODUCT_VERSION.product_version_id
  • version_no — INT
  • effective_from — DATE
  • effective_to — DATE
  • status_cd — VARCHAR(20)
  • source_file_id — BIGINT — Foreign key → IMPORT_FILE.import_file_id
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

JOURNAL_ENTRY

  • journal_entry_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → SETTLEMENT_RUN.settlement_run_id — NOT NULL
  • entry_no — VARCHAR(50) — NOT NULL
  • entry_type_cd — VARCHAR(30)
  • entry_dt — DATE
  • entry_status_cd — VARCHAR(20)
  • description — VARCHAR(500)
  • reversal_of_entry_id — BIGINT — Foreign key → JOURNAL_ENTRY.journal_entry_id
  • posted_user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • posted_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

JOURNAL_LINE

  • journal_line_id — BIGINT — Primary key — NOT NULL
  • journal_entry_id — BIGINT — Foreign key → JOURNAL_ENTRY.journal_entry_id — NOT NULL
  • settlement_item_id — BIGINT — Foreign key → SETTLEMENT_ITEM.settlement_item_id
  • clawback_allocation_id — BIGINT
  • contract_id — BIGINT — Foreign key → CONTRACT.contract_id
  • recipient_fc_id — BIGINT — Foreign key → TB_FGC_FC_BSC.fc_id
  • account_cd — VARCHAR(30) — NOT NULL
  • dr_cr_cd — CHAR(1) — NOT NULL
  • amount — BIGINT — NOT NULL
  • source_type_cd — VARCHAR(30)
  • original_journal_line_id — BIGINT — Foreign key → JOURNAL_LINE.journal_line_id
  • rule_ref — VARCHAR(300)
  • posted_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

POLICY

  • policy_id — BIGINT — Primary key — NOT NULL
  • policy_cd — VARCHAR(50) — NOT NULL
  • policy_nm — VARCHAR(150) — NOT NULL
  • policy_type_cd — VARCHAR(30) — NOT NULL
  • policy_desc — VARCHAR(500)
  • use_yn — CHAR(1)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

POLICY_REGULATION

  • policy_regulation_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • regulation_id — BIGINT — Foreign key → REGULATION.regulation_id
  • basis_type_cd — VARCHAR(30)
  • note — VARCHAR(500)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

POLICY_VERSION

  • policy_version_id — BIGINT — Primary key — NOT NULL
  • policy_id — BIGINT — Foreign key → POLICY.policy_id — NOT NULL
  • version_no — INT — NOT NULL
  • version_nm — VARCHAR(100)
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • version_status_cd — VARCHAR(20)
  • approved_user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • approved_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

REGULATION

  • regulation_id — BIGINT — Primary key — NOT NULL
  • regulation_cd — VARCHAR(50)
  • regulation_type_cd — VARCHAR(30)
  • title — VARCHAR(300)
  • issuer — VARCHAR(150)
  • article_cd — VARCHAR(100)
  • reference_summary — VARCHAR(1000)
  • published_dt — DATE
  • effective_from — DATE
  • effective_to — DATE
  • source_url — VARCHAR(1000)
  • file_path — VARCHAR(1000)
  • status_cd — VARCHAR(20)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

SCHEDULE_LINE

  • schedule_line_id — BIGINT — Primary key — NOT NULL
  • commission_schedule_id — BIGINT — Foreign key → COMMISSION_SCHEDULE.commission_schedule_id — NOT NULL
  • contract_id — BIGINT — Foreign key → CONTRACT.contract_id — NOT NULL
  • recipient_fc_id — BIGINT — Foreign key → TB_FGC_FC_BSC.fc_id — NOT NULL
  • installment_no — INT — NOT NULL
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd — NOT NULL
  • insurer_rate_id — BIGINT — Foreign key → INSURER_COMMISSION_RATE.commission_rate_id
  • ga_policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • ga_policy_rule_id — BIGINT
  • insurer_expected_amt — BIGINT
  • ga_distribution_rate — DECIMAL(12,8)
  • scheduled_amt — BIGINT
  • scheduled_dt — DATE
  • line_status_cd — VARCHAR(20)
  • rule_ref — VARCHAR(300)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

SETTLEMENT_ITEM

  • settlement_item_id — BIGINT — Primary key — NOT NULL
  • settlement_run_id — BIGINT — Foreign key → SETTLEMENT_RUN.settlement_run_id — NOT NULL
  • schedule_line_id — BIGINT — Foreign key → SCHEDULE_LINE.schedule_line_id
  • statement_line_id — BIGINT — Foreign key → INSURER_STATEMENT_LINE.statement_line_id
  • contract_id — BIGINT — Foreign key → CONTRACT.contract_id — NOT NULL
  • recipient_fc_id — BIGINT — Foreign key → TB_FGC_FC_BSC.fc_id — NOT NULL
  • commission_item_cd — VARCHAR(30) — Foreign key → COMMISSION_ITEM.commission_item_cd — NOT NULL
  • ga_policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • limit_policy_version_id — BIGINT — Foreign key → POLICY_VERSION.policy_version_id
  • limit_check_id — BIGINT — Foreign key → FIRST_YEAR_LIMIT_CHECK.limit_check_id
  • expected_amt — BIGINT
  • actual_amt — BIGINT
  • difference_amt — BIGINT
  • calculated_amt — BIGINT
  • deduction_amt — BIGINT
  • confirmed_amt — BIGINT
  • limit_include_yn — CHAR(1)
  • limit_applied_amt — BIGINT
  • match_status_cd — VARCHAR(20)
  • settlement_status_cd — VARCHAR(20)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

SETTLEMENT_RUN

  • settlement_run_id — BIGINT — Primary key — NOT NULL
  • settlement_month — CHAR(6) — NOT NULL
  • ga_id — BIGINT — Foreign key → TB_FGC_ORG_GA.ga_id — NOT NULL
  • insurer_id — BIGINT — Foreign key → INSURER.insurer_id
  • run_no — INT
  • idempotency_key — VARCHAR(150)
  • basis_dt — DATE
  • run_status_cd — VARCHAR(20)
  • started_dt — DATETIME
  • completed_dt — DATETIME
  • confirmed_dt — DATETIME
  • executed_user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • confirmed_user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

TB_FGC_AUDT_LOG

  • audt_log_id — BIGINT — Primary key — NOT NULL
  • actor_user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • action_type_cd — VARCHAR(30)
  • target_entity_type_cd — VARCHAR(50)
  • target_entity_id — VARCHAR(100)
  • request_uri — VARCHAR(500)
  • http_method — VARCHAR(10)
  • before_data — LONGTEXT
  • after_data — LONGTEXT
  • result_cd — VARCHAR(20)
  • failure_reason — VARCHAR(500)
  • ip_address — VARCHAR(45)
  • user_agent — VARCHAR(500)
  • occurred_dt — DATETIME

TB_FGC_FC_ACCT

  • fc_acct_id — BIGINT — Primary key — NOT NULL
  • fc_id — BIGINT — Foreign key → TB_FGC_FC_BSC.fc_id
  • bank_cd — VARCHAR(10)
  • account_no_enc — VARCHAR(512)
  • account_holder_nm — VARCHAR(100)
  • primary_yn — CHAR(1)
  • valid_from — DATE
  • valid_to — DATE
  • account_status_cd — VARCHAR(30)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

TB_FGC_FC_BSC

  • fc_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • bran_id — BIGINT — Foreign key → TB_FGC_ORG_BRAN.bran_id — NOT NULL
  • fc_position_cd — VARCHAR(30) — Foreign key → TB_FGC_FC_POSITION.fc_position_cd — NOT NULL
  • fc_cd — VARCHAR(50) — NOT NULL
  • fc_nm — VARCHAR(100) — NOT NULL
  • tel_no — VARCHAR(20)
  • fc_status_cd — VARCHAR(30)
  • commission_grade_cd — VARCHAR(30)
  • appointment_dt — DATE
  • termination_dt — DATE
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

TB_FGC_FC_NOTIF

  • notif_id — BIGINT — Primary key — NOT NULL
  • recipient_user_id — BIGINT — Foreign key → TB_FGC_USER.user_id
  • notif_type_cd — VARCHAR(30)
  • title — VARCHAR(200)
  • content — TEXT
  • related_entity_type_cd — VARCHAR(30)
  • related_entity_id — BIGINT
  • read_yn — CHAR(1)
  • read_dt — DATETIME
  • expires_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME

TB_FGC_FC_POSITION

  • fc_position_cd — VARCHAR(30) — Primary key — NOT NULL
  • fc_position_nm — VARCHAR(50) — NOT NULL
  • position_level — INT
  • sort_order — INT
  • use_yn — CHAR(1)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

TB_FGC_ORG_BRAN

  • bran_id — BIGINT — Primary key — NOT NULL
  • hq_id — BIGINT — Foreign key → TB_FGC_ORG_HQ.hq_id — NOT NULL
  • bran_cd — VARCHAR(30) — NOT NULL
  • bran_nm — VARCHAR(100) — NOT NULL
  • leader_nm — VARCHAR(100)
  • tel_no — VARCHAR(20)
  • zip_cd — VARCHAR(10)
  • addr — VARCHAR(300)
  • status_cd — VARCHAR(20)
  • estb_dt — DATE
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

TB_FGC_ORG_GA

  • ga_id — BIGINT — Primary key — NOT NULL
  • ga_cd — VARCHAR(30) — NOT NULL
  • ga_nm — VARCHAR(100) — NOT NULL
  • ceo_nm — VARCHAR(100)
  • tel_no — VARCHAR(20)
  • eml_addr — VARCHAR(200)
  • zip_cd — VARCHAR(10)
  • addr — VARCHAR(300)
  • status_cd — VARCHAR(20)
  • estb_dt — DATE
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

TB_FGC_ORG_HQ

  • hq_id — BIGINT — Primary key — NOT NULL
  • ga_id — BIGINT — Foreign key → TB_FGC_ORG_GA.ga_id — NOT NULL
  • hq_cd — VARCHAR(30) — NOT NULL
  • hq_nm — VARCHAR(100) — NOT NULL
  • leader_nm — VARCHAR(100)
  • tel_no — VARCHAR(20)
  • eml_addr — VARCHAR(200)
  • zip_cd — VARCHAR(10)
  • addr — VARCHAR(300)
  • status_cd — VARCHAR(20)
  • estb_dt — DATE
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

TB_FGC_ROLE

  • role_id — BIGINT — Primary key — NOT NULL
  • role_cd — VARCHAR(30) — NOT NULL
  • role_nm — VARCHAR(50) — NOT NULL
  • role_desc — VARCHAR(300)
  • use_yn — CHAR(1)
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME

TB_FGC_USER

  • user_id — BIGINT — Primary key — NOT NULL
  • role_id — BIGINT — Foreign key → TB_FGC_ROLE.role_id — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • user_nm — VARCHAR(100) — NOT NULL
  • user_status_cd — VARCHAR(30)
  • valid_from — DATE
  • valid_to — DATE
  • last_login_dt — DATETIME
  • login_fail_cnt — INT
  • locked_dt — DATETIME
  • reg_user_id — BIGINT
  • reg_dt — DATETIME
  • upd_user_id — BIGINT
  • upd_dt — DATETIME