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