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