568 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| m_provisioning_criteria_definition_ibfk_3 |
|
|
Restrict delete | ||
| m_provisioning_criteria_definition_ibfk_4 |
|
|
Restrict delete | ||
| m_provisioning_criteria_definition_ibfk_1 |
|
|
Restrict delete | ||
| m_provisioning_criteria_definition_ibfk_2 |
|
|
Restrict delete | ||
| m_report_mailing_job_run_history_ibfk_1 |
|
|
Restrict delete | ||
| FK_acc_accounting_rule_acc_gl_account_debit |
|
|
Restrict delete | ||
| FK_acc_accounting_rule_acc_gl_account_credit |
|
|
Restrict delete | ||
| FK_acc_accounting_rule_m_office |
|
|
Restrict delete | ||
| FK_wc_delinquency_range_schedule_created_by |
|
|
Restrict delete | ||
| FK_wc_delinquency_range_schedule_loan |
|
|
Restrict delete | ||
| FK_wc_delinquency_range_schedule_last_modified_by |
|
|
Restrict delete | ||
| FK_m_product_mix_product_id_to_m_product_loan |
|
|
Restrict delete | ||
| FK_m_product_mix_restricted_product_id_to_m_product_loan |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_acc_gl_account |
|
|
Restrict delete | ||
| FK_journal_entry_created_by |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_m_appuser_2 |
|
|
Restrict delete | ||
| FK_journal_entry_last_modified_by |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_m_loan_transaction |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_m_savings_account_transaction |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_m_office |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_m_payment_detail |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_m_client_transaction |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_m_appuser |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_acc_gl_journal_entry |
|
|
Restrict delete | ||
| FK_acc_gl_journal_entry_m_share_account_transaction |
|
|
Restrict delete | ||
| FK_wc_loan_product_fund |
|
|
Restrict delete | ||
| FK_m_wc_loan_product_breach_cfg |
|
|
Restrict delete | ||
| FK_wc_loan_product_delinquency_bucket |
|
|
Restrict delete | ||
| FK_m_wc_loan_product_near_breach |
|
|
Restrict delete | ||
| FK__m_loan_transaction |
|
|
Restrict delete | ||
| FK__m_loan_charge |
|
|
Restrict delete | ||
| FK_m_loan_m_loan_recalculation_details |
|
|
Restrict delete | ||
| m_share_product_market_price_ibfk_1 |
|
|
Restrict delete | ||
| FK_acc_accounting_rule_id |
|
|
Restrict delete | ||
| FK_m_code_value_id |
|
|
Restrict delete | ||
| job_exec_ctx_fk |
|
|
Restrict delete | ||
| fk2291c477e2551dcc |
|
|
Restrict delete | ||
| Parent_levelId_reference |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_details_created_by |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_details_modified_by |
|
|
Restrict delete | ||
| FK_mandatory_savings_schedule_last_modified_by |
|
|
Restrict delete | ||
| fkmss0000000001 |
|
|
Restrict delete | ||
| FK_mandatory_savings_schedule_created_by |
|
|
Restrict delete | ||
| m_entity_datatable_check_ibfk_1 |
|
|
Restrict delete | ||
| FK_loan_repayment_schedule_last_modified_by |
|
|
Restrict delete | ||
| FK_loan_repayment_schedule_created_by |
|
|
Restrict delete | ||
| fk488b92aa40be0710 |
|
|
Restrict delete | ||
| FK_m_standing_instructions_account_transfer_details |
|
|
Restrict delete | ||
| FK_m_calendar_m_calendar_history |
|
|
Restrict delete | ||
| fk_m_wc_delinquency_configuration_on_bucket |
|
|
Restrict delete | ||
| FK_wc_loan_originator_mapping_modified_by |
|
|
Restrict delete | ||
| FK_wc_loan_originator_mapping_wc_loan |
|
|
Restrict delete | ||
| FK_wc_loan_originator_mapping_originator |
|
|
Restrict delete | ||
| FK_wc_loan_originator_mapping_created_by |
|
|
Restrict delete | ||
| FK_m_client_document_m_client |
|
|
Restrict delete | ||
| FK_client_identifier_last_modified_by |
|
|
Restrict delete | ||
| FK_m_client_document_m_code_value |
|
|
Restrict delete | ||
| FK_client_identifier_created_by |
|
|
Restrict delete | ||
| FK_loan_originator_mapping_created_by |
|
|
Restrict delete | ||
| FK_loan_originator_mapping_originator |
|
|
Restrict delete | ||
| FK_loan_originator_mapping_modified_by |
|
|
Restrict delete | ||
| FK_loan_originator_mapping_loan |
|
|
Restrict delete | ||
| FK_guarantee_details_loan_product |
|
|
Restrict delete | ||
| m_survey_responses_ibfk_1 |
|
|
Restrict delete | ||
| notification_mapper_ibfk_3 |
|
|
Restrict delete | ||
| notification_mapper_ibfk_2 |
|
|
Restrict delete | ||
| FK_m_calendar_instance_m_meeting |
|
|
Restrict delete | ||
| FK_savings_account_transaction_created_by |
|
|
Restrict delete | ||
| FK_savings_account_transaction_last_modified_by |
|
|
Restrict delete | ||
| FK_m_savings_account_transaction_m_payment_detail |
|
|
Restrict delete | ||
| fksat0000000001 |
|
|
Restrict delete | ||
| FK_m_savings_account_transaction_m_office |
|
|
Restrict delete | ||
| fkdptp00000000000001 |
|
|
Restrict delete | ||
| scheduled_email_campaign_ibfk_1 |
|
|
Restrict delete | ||
| job_exec_params_fk |
|
|
Restrict delete | ||
| m_survey_lookup_tables_ibfk_1 |
|
|
Restrict delete | ||
| borrower_cycle_loan_product_FK |
|
|
Restrict delete | ||
| FK_savings_account_charge_created_by |
|
|
Restrict delete | ||
| FK_savings_account_charge_last_modified_by |
|
|
Restrict delete | ||
| m_savings_account_charge_ibfk_1 |
|
|
Restrict delete | ||
| m_savings_account_charge_ibfk_2 |
|
|
Restrict delete | ||
| FK_mappings_m_variable_product_loan_id |
|
|
Restrict delete | ||
| FK_wc_breach_schedule_created_by |
|
|
Restrict delete | ||
| FK_wc_breach_schedule_loan |
|
|
Restrict delete | ||
| FK_wc_breach_schedule_last_modified_by |
|
|
Restrict delete | ||
| cbConfigfk1 |
|
|
Restrict delete | ||
| fkdpirc00000000000001 |
|
|
Restrict delete | ||
| fkdpirc00000000000002 |
|
|
Restrict delete | ||
| FK_m_cashiers_m_staff |
|
|
Restrict delete | ||
| FK_m_cashiers_m_teller |
|
|
Restrict delete | ||
| FK_m_staff_m_image |
|
|
Restrict delete | ||
| FK_m_staff_m_office |
|
|
Restrict delete | ||
| FK_m_wc_loan_disbursement_detail_user |
|
|
Restrict delete | ||
| FK_m_wc_loan_disbursement_detail_loan |
|
|
Restrict delete | ||
| FK_note_created_by |
|
|
Restrict delete | ||
| fk7c9708924d26803 |
|
|
Restrict delete | ||
| FK_note_last_modified_by |
|
|
Restrict delete | ||
| fk7c970898f889c3f |
|
|
Restrict delete | ||
| FK_m_note_m_group |
|
|
Restrict delete | ||
| fk7c9708940be0710 |
|
|
Restrict delete | ||
| fk7c97089541f0a56 |
|
|
Restrict delete | ||
| FK_savings_account_id |
|
|
Restrict delete | ||
| fk7c970897179a0cb |
|
|
Restrict delete | ||
| fkClientCollateral |
|
|
Cascade on delete | ||
| fkLoan |
|
|
Cascade on delete | ||
| fkTransaction |
|
|
Cascade on delete | ||
| FK_m_wc_loan_balance_loan |
|
|
Restrict delete | ||
| address_fields_codefk2 |
|
|
Restrict delete | ||
| address_fields_codefk1 |
|
|
Restrict delete | ||
| FK_floating_rates_period_created_by |
|
|
Restrict delete | ||
| FK_mappings_m_floating_rates |
|
|
Restrict delete | ||
| FK_floating_rates_period_last_modified_by |
|
|
Restrict delete | ||
| FK_loan_buy_down_fees_balance_last_modified_by |
|
|
Restrict delete | ||
| FK_loan_buy_down_fees_balance_transaction_id |
|
|
Restrict delete | ||
| FK_loan_buy_down_fees_balance_created_by |
|
|
Restrict delete | ||
| FK_loan_buy_down_fees_balance_loan_id |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_entry_ibfk_1 |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_entry_ibfk_2 |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_entry_ibfk_3 |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_entry_ibfk_4 |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_entry_ibfk_5 |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_entry_ibfk_6 |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_entry_ibfk_7 |
|
|
Restrict delete | ||
| FK_m_wc_loan_note_loan |
|
|
Restrict delete | ||
| FK_m_wc_loan_note_created_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_note_last_modified_by |
|
|
Restrict delete | ||
| m_share_product_ibfk_1 |
|
|
Restrict delete | ||
| m_share_product_ibfk_2 |
|
|
Restrict delete | ||
| fkdprd00000000000001 |
|
|
Restrict delete | ||
| FK_m_charge_m_tax_group |
|
|
Restrict delete | ||
| FK_m_payment_detail_m_payment_types |
|
|
Restrict delete | ||
| FK_m_charge_acc_gl_account |
|
|
Restrict delete | ||
| FK_additional_details_repayment_schedule_id |
|
|
Restrict delete | ||
| fkstaff000000001 |
|
|
Restrict delete | ||
| fkgroup000000001 |
|
|
Restrict delete | ||
| fkclient00000001 |
|
|
Restrict delete | ||
| fkcampaign00000001 |
|
|
Restrict delete | ||
| FK_loan_status_change_history_last_modified_by |
|
|
Restrict delete | ||
| FK_oan_status_change_history_created_by |
|
|
Restrict delete | ||
| m_loan_status_change_history_fk |
|
|
Restrict delete | ||
| FK_m_delinquency_tags_range |
|
|
Restrict delete | ||
| FK_m_delinquency_tags_loan |
|
|
Restrict delete | ||
| fkglacc000000002 |
|
|
Restrict delete | ||
| fk_acc_0000000001 |
|
|
Restrict delete | ||
| FK_c_external_service_properties_c_external_service |
|
|
Restrict delete | ||
| FK_ext_asset_owner_lp_conf_attr_modified_by |
|
|
Restrict delete | ||
| FK_ext_asset_owner_lp_conf_attr_created_by |
|
|
Restrict delete | ||
| FK_ext_asset_owner_lp_conf_attr_loan_product_id |
|
|
Restrict delete | ||
| m_survey_scorecards_ibfk_2 |
|
|
Restrict delete | ||
| m_survey_scorecards_ibfk_3 |
|
|
Restrict delete | ||
| m_survey_scorecards_ibfk_4 |
|
|
Restrict delete | ||
| m_survey_scorecards_ibfk_5 |
|
|
Restrict delete | ||
| m_survey_scorecards_ibfk_1 |
|
|
Restrict delete | ||
| Parent_Id_reference |
|
|
Restrict delete | ||
| m_group_ibfk_1 |
|
|
Restrict delete | ||
| FK_m_group_m_staff |
|
|
Restrict delete | ||
| FK_m_group_level |
|
|
Restrict delete | ||
| FK_m_group_m_code |
|
|
Restrict delete | ||
| FK_annual_report_created_by |
|
|
Restrict delete | ||
| FK_annual_report_last_modified_by |
|
|
Restrict delete | ||
| FK_m_teller_transactions_m_cashiers |
|
|
Cascade on delete | ||
| fk_m_wc_loan_amort_model_loan |
|
|
Restrict delete | ||
| fksairs00000000000001 |
|
|
Restrict delete | ||
| FK_m_client_transfer_details_m_appuser |
|
|
Restrict delete | ||
| FK_m_client_transfer_details_m_office |
|
|
Restrict delete | ||
| FK_m_client_transfer_details_m_client |
|
|
Restrict delete | ||
| FK_m_client_transfer_details_m_office_2 |
|
|
Restrict delete | ||
| fk_m_loan_rate_rate |
|
|
Restrict delete | ||
| fk_m_loan_rate_loan |
|
|
Restrict delete | ||
| FK_mappings_m_loan_repayment_schedule |
|
|
Restrict delete | ||
| FK_mappings_m_loan_transaction |
|
|
Restrict delete | ||
| linked_loan_fk |
|
|
Restrict delete | ||
| account_association_loan_fk |
|
|
Restrict delete | ||
| account_association_savings_fk |
|
|
Restrict delete | ||
| linked_savings_fk |
|
|
Restrict delete | ||
| FK_loan_payment_allocation_rule_last_modified_by |
|
|
Restrict delete | ||
| m_loan_payment_allocation_rule_fk |
|
|
Restrict delete | ||
| FK_loan_payment_allocation_rule_created_by |
|
|
Restrict delete | ||
| m_holiday_id_ibfk_1 |
|
|
Restrict delete | ||
| m_office_id_ibfk_2 |
|
|
Restrict delete | ||
| FK_reage_reason_code_m_code_value |
|
|
Restrict delete | ||
| m_deposit_account_term_and_preclosure_ibfk_1 |
|
|
Restrict delete | ||
| fkdatp00000000000001 |
|
|
Restrict delete | ||
| FK_loan_capitalized_income_balance_transaction_id |
|
|
Restrict delete | ||
| FK_loan_capitalized_income_balance_last_modified_by |
|
|
Restrict delete | ||
| FK_loan_capitalized_income_balance_loan_id |
|
|
Restrict delete | ||
| FK_loan_capitalized_income_balance_created_by |
|
|
Restrict delete | ||
| fk_m_savings_officer_assignment_history_0001 |
|
|
Restrict delete | ||
| FK_savings_officer_assignment_history_last_modified_by |
|
|
Restrict delete | ||
| fk_m_savings_officer_assignment_history_0002 |
|
|
Restrict delete | ||
| FK_savings_officer_assignment_history_created_by |
|
|
Restrict delete | ||
| FK_m_account_transfer_details_to_client |
|
|
Restrict delete | ||
| FK_m_account_transfer_details_from_client |
|
|
Restrict delete | ||
| FK_m_account_transfer_details_to_savings_account |
|
|
Restrict delete | ||
| FK_m_account_transfer_details_to_loan_account |
|
|
Restrict delete | ||
| FK_m_account_transfer_details_from_office |
|
|
Restrict delete | ||
| FK_m_account_transfer_details_from_loan_account |
|
|
Restrict delete | ||
| FK_m_account_transfer_details_to_office |
|
|
Restrict delete | ||
| FK_m_account_transfer_details_from_savings_account |
|
|
Restrict delete | ||
| fkcfcea42640be0710 |
|
|
Restrict delete | ||
| FK_m_loan_transaction_m_payment_detail |
|
|
Restrict delete | ||
| FK_loan_transaction_created_by |
|
|
Restrict delete | ||
| FK_loan_transaction_last_modified_by |
|
|
Restrict delete | ||
| FK_m_loan_transaction_m_office |
|
|
Restrict delete | ||
| FK_m_delinquency_installment_tags_loan |
|
|
Restrict delete | ||
| FK_m_delinquency_installment_tags_range |
|
|
Restrict delete | ||
| fk_m_loan_progressive_model_on_loan |
|
|
Restrict delete | ||
| fksa00000000000002 |
|
|
Restrict delete | ||
| FK_savings_account_created_by |
|
|
Restrict delete | ||
| fksa00000000000001 |
|
|
Restrict delete | ||
| FK_gsim_id |
|
|
Restrict delete | ||
| FK_savings_account_tax_group |
|
|
Restrict delete | ||
| fksa00000000000003 |
|
|
Restrict delete | ||
| FK_savings_account_last_modified_by |
|
|
Restrict delete | ||
| FK_collateral_code_value |
|
|
Restrict delete | ||
| FK_collateral_m_loan |
|
|
Restrict delete | ||
| FK_m_product_loan_m_product_loan_recalculation_details |
|
|
Restrict delete | ||
| FK_job_id |
|
|
Restrict delete | ||
| FK__rel_id_m_entity_relation_id |
|
|
Restrict delete | ||
| FK_m_share_account_dividend_details_account_id |
|
|
Restrict delete | ||
| FK_m_share_account_dividend_details_dividend_pay_out_id |
|
|
Restrict delete | ||
| sefkgroup000000001 |
|
|
Restrict delete | ||
| sefkstaff000000001 |
|
|
Restrict delete | ||
| fk_schedule_email_campign1 |
|
|
Restrict delete | ||
| sefkclient00000001 |
|
|
Restrict delete | ||
| fk_report_parameter_002 |
|
|
Restrict delete | ||
| fk_report_parameter_001 |
|
|
Cascade on delete | ||
| FK_tax_group_createdby |
|
|
Restrict delete | ||
| FK_tax_group_lastmodifiedby |
|
|
Restrict delete | ||
| FK_m_tellers_gl_account_credit_account_id |
|
|
Restrict delete | ||
| FK_m_tellers_gl_account_debit_account_id |
|
|
Restrict delete | ||
| FK_m_tellers_m_office |
|
|
Restrict delete | ||
| FK_wc_loan_breach_action_loan |
|
|
Restrict delete | ||
| FK_wc_loan_breach_action_last_modified_by |
|
|
Restrict delete | ||
| FK_wc_loan_breach_action_created_by |
|
|
Restrict delete | ||
| fk7662ce59b4100309 |
|
|
Restrict delete | ||
| fk7662ce5915cec7ab |
|
|
Restrict delete | ||
| fk_2fa_access_token_user_id |
|
|
Restrict delete | ||
| fkCurrencyCode |
|
|
Cascade on delete | ||
| fk_m_wc_loan_transaction_relation_on_to_loan_transaction |
|
|
Restrict delete | ||
| fk_m_wc_loan_transaction_relation_on_to_loan_charge |
|
|
Restrict delete | ||
| fk_m_wc_loan_transaction_relation_on_from_loan_transaction |
|
|
Restrict delete | ||
| fk_wc_near_breach_action_created_by |
|
|
Restrict delete | ||
| fk_wc_near_breach_action_last_modified_by |
|
|
Restrict delete | ||
| fk_wc_near_breach_action_loan |
|
|
Restrict delete | ||
| FK_gsim_group_id |
|
|
Restrict delete | ||
| FK_m_interest_incentives_m_interest_rate_slab |
|
|
Restrict delete | ||
| FK_external_asset_owner_modified_by |
|
|
Restrict delete | ||
| FK_external_asset_owner_created_by |
|
|
Restrict delete | ||
| m_loan_reschedule_request_ibfk_1 |
|
|
Restrict delete | ||
| m_loan_reschedule_request_ibfk_2 |
|
|
Restrict delete | ||
| m_loan_reschedule_request_ibfk_3 |
|
|
Restrict delete | ||
| m_loan_reschedule_request_ibfk_4 |
|
|
Restrict delete | ||
| m_loan_reschedule_request_ibfk_5 |
|
|
Restrict delete | ||
| FK_m_guarantor_m_code_value |
|
|
Restrict delete | ||
| FK_m_guarantor_m_loan |
|
|
Restrict delete | ||
| FK_m_account_transfer_standing_instructions_m_history |
|
|
Restrict delete | ||
| step_exec_ctx_fk |
|
|
Restrict delete | ||
| m_loan_topup_FK_closure_loan_id |
|
|
Restrict delete | ||
| m_loan_topup_FK_loan_id |
|
|
Restrict delete | ||
| m_loan_topup_FK_account_transfer_details_id |
|
|
Restrict delete | ||
| FK_loan_product_payment_allocation_rule_last_modified_by |
|
|
Restrict delete | ||
| FK_loan_product_payment_allocation_rule_created_by |
|
|
Restrict delete | ||
| m_loan_product_payment_allocation_rule_fk |
|
|
Restrict delete | ||
| m_share_account_ibfk_2 |
|
|
Restrict delete | ||
| m_share_account_ibfk_1 |
|
|
Restrict delete | ||
| m_share_account_ibfk_4 |
|
|
Restrict delete | ||
| m_share_account_ibfk_3 |
|
|
Restrict delete | ||
| m_share_account_ibfk_6 |
|
|
Restrict delete | ||
| m_share_account_ibfk_5 |
|
|
Restrict delete | ||
| m_share_account_ibfk_8 |
|
|
Restrict delete | ||
| m_share_account_ibfk_7 |
|
|
Restrict delete | ||
| m_share_account_ibfk_9 |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_summary_on_created_by |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_summary_on_external_owner_id |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_summary_on_gl_account_id |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_summary_on_office_id |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_summary_on_job_execution_id |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_summary_on_last_modified_by |
|
|
Restrict delete | ||
| FK_x_code_id |
|
|
Restrict delete | ||
| FK_m_loan_overdue_installment_charge_m_loan_repayment_schedule |
|
|
Restrict delete | ||
| FK_m_loan_overdue_installment_charge_m_loan_charge |
|
|
Restrict delete | ||
| FK_acc_gl_closure_m_appuser_2 |
|
|
Restrict delete | ||
| FK_acc_gl_closure_m_office |
|
|
Restrict delete | ||
| FK_acc_gl_closure_m_appuser |
|
|
Restrict delete | ||
| FK_m_loan_tranche_disbursement_charge_m_loan_charge |
|
|
Restrict delete | ||
| FK_m_loan_tranche_disbursement_charge_m_loan_disbursement_detai |
|
|
Restrict delete | ||
| fk1e37728b783c5c25 |
|
|
Restrict delete | ||
| fk1e37728b93c6c1b6 |
|
|
Restrict delete | ||
| m_report_mailing_job_ibfk_1 |
|
|
Restrict delete | ||
| m_report_mailing_job_ibfk_4 |
|
|
Restrict delete | ||
| m_report_mailing_job_ibfk_2 |
|
|
Restrict delete | ||
| m_report_mailing_job_ibfk_3 |
|
|
Restrict delete | ||
| FK_deposit_account_on_hold_transaction_last_modified_by |
|
|
Restrict delete | ||
| FK_deposit_account_on_hold_transaction_created_by |
|
|
Restrict delete | ||
| FK_deposit_on_hold_transaction_m_savings_account |
|
|
Restrict delete | ||
| fk_hook_template_id |
|
|
Restrict delete | ||
| FK_m_savings_interest_incentives_m_savings_interest_rate_slab |
|
|
Restrict delete | ||
| FK_m_wc_loan_transaction_allocation_transaction |
|
|
Restrict delete | ||
| FK_m_wc_loan_transaction_allocation_last_modified_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_transaction_allocation_created_by |
|
|
Restrict delete | ||
| fk_hook_id_cfg |
|
|
Restrict delete | ||
| FK_m_family_members_client_id_m_client |
|
|
Restrict delete | ||
| FK_m_family_members_marital_status_m_code_value |
|
|
Restrict delete | ||
| FK_m_family_members_relationship_m_code_value |
|
|
Restrict delete | ||
| FK_m_family_members_gender_m_code_value |
|
|
Restrict delete | ||
| FK_m_family_members_profession_m_code_value |
|
|
Restrict delete | ||
| FK_business_date_created_by |
|
|
Restrict delete | ||
| FK_business_date_last_modified_by |
|
|
Restrict delete | ||
| FK_m_loan_delinquency_action_loan |
|
|
Restrict delete | ||
| fk_template_id |
|
|
Restrict delete | ||
| fk_ugd_template_id |
|
|
Restrict delete | ||
| m_loan_arrears_aging_ibfk_1 |
|
|
Restrict delete | ||
| FK_tax_component_history_lastmodifiedby |
|
|
Restrict delete | ||
| FK_tax_component_history_createdby |
|
|
Restrict delete | ||
| FK_tax_component_history_tax_component_id |
|
|
Restrict delete | ||
| fkdard00000000000001 |
|
|
Restrict delete | ||
| FK_laam_loan_id |
|
|
Restrict delete | ||
| FK_laam_amortization_transaction_id |
|
|
Restrict delete | ||
| FK_laam_base_transaction_id |
|
|
Restrict delete | ||
| FK_laam_last_modified_by |
|
|
Restrict delete | ||
| FK_laam_created_by |
|
|
Restrict delete | ||
| fk_interop_identifier_account |
|
|
Restrict delete | ||
| m_share_product_charge_ibfk_1 |
|
|
Restrict delete | ||
| m_share_product_charge_ibfk_2 |
|
|
Restrict delete | ||
| FK_loan_disbursement_detail_loan_id |
|
|
Restrict delete | ||
| FK_grouprole_m_codevalue |
|
|
Restrict delete | ||
| FKGroupRoleGroupId |
|
|
Restrict delete | ||
| FKGroupRoleClientId |
|
|
Restrict delete | ||
| FK_ext_asset_owner_transfer_je_mapping_journal_entry_id |
|
|
Restrict delete | ||
| FK_ext_asset_owner_transfer_je_mapping_modified_by |
|
|
Restrict delete | ||
| FK_ext_asset_owner_transfer_je_mapping_created_by |
|
|
Restrict delete | ||
| FK_ext_asset_owner_transfer_je_mapping_owner_transfer_id |
|
|
Restrict delete | ||
| FK_loan_schedule_id_charge_schedule |
|
|
Restrict delete | ||
| FK_loan_charge_id_charge_schedule |
|
|
Restrict delete | ||
| FK_wc_loan_delinquency_action_created_by |
|
|
Restrict delete | ||
| FK_wc_loan_delinquency_action_loan |
|
|
Restrict delete | ||
| FK_wc_loan_delinquency_action_last_modified_by |
|
|
Restrict delete | ||
| fk_wc_charge_paid_by_transaction |
|
|
Restrict delete | ||
| fk_wc_charge_paid_by_charge |
|
|
Restrict delete | ||
| FK_m_client_m_savings_product |
|
|
Restrict delete | ||
| FK_client_created_by |
|
|
Restrict delete | ||
| FK_m_client_substatus_m_code_value |
|
|
Restrict delete | ||
| FK_m_client_m_staff |
|
|
Restrict delete | ||
| FK1_m_client_gender_m_code_value |
|
|
Restrict delete | ||
| FK_m_client_m_code |
|
|
Restrict delete | ||
| FK_m_client_m_image |
|
|
Restrict delete | ||
| FK_m_client_type_mcode_value_reject |
|
|
Restrict delete | ||
| fkce00cab3e0dd567a |
|
|
Restrict delete | ||
| FK_client_last_modified_by |
|
|
Restrict delete | ||
| FK_m_client_type_m_code_value_withdraw |
|
|
Restrict delete | ||
| FK_m_client_m_office |
|
|
Restrict delete | ||
| FK_m_client_classification_m_code_value |
|
|
Restrict delete | ||
| FK_m_client_type_m_code_value |
|
|
Restrict delete | ||
| FK_m_client_m_savings_account |
|
|
Restrict delete | ||
| fk_hook_idc |
|
|
Restrict delete | ||
| FK_guarantor_transaction_guarantor_fund_detail |
|
|
Restrict delete | ||
| FK_guarantor_transaction_m_deposit_account_on_hold_transaction |
|
|
Restrict delete | ||
| FK_guarantor_transaction_m_loan_transaction |
|
|
Restrict delete | ||
| fk_m_product_loan_rate_loan |
|
|
Restrict delete | ||
| fk_m_product_loan_rate_rate |
|
|
Restrict delete | ||
| FK__m_savings_account_transaction |
|
|
Restrict delete | ||
| FK__m_savings_account_charge |
|
|
Restrict delete | ||
| FK_client_id |
|
|
Restrict delete | ||
| m_provisioning_history_ibfk_1 |
|
|
Restrict delete | ||
| m_provisioning_history_ibfk_2 |
|
|
Restrict delete | ||
| m_wc_loan_payment_allocation_rule_loan_fk |
|
|
Restrict delete | ||
| FK_m_wc_loan_par_last_modified_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_par_created_by |
|
|
Restrict delete | ||
| FK_m_guarantor_fund_details_account_associations_id |
|
|
Restrict delete | ||
| FK_m_guarantor_fund_details_m_guarantor |
|
|
Restrict delete | ||
| fkrepaymentwithpostdated |
|
|
Cascade on delete | ||
| fkloanrepayment |
|
|
Cascade on delete | ||
| FK_office_mapping_acc_gl_account |
|
|
Restrict delete | ||
| fk_acc_product_mapping_capitalized_income_classification |
|
|
Restrict delete | ||
| fk_acc_product_mapping_charge_off_reason |
|
|
Restrict delete | ||
| FK_acc_product_mapping_m_payment_type |
|
|
Restrict delete | ||
| FK_acc_product_mapping_gl_account_id |
|
|
Restrict delete | ||
| fk_acc_product_mapping_buydown_fee_classification |
|
|
Restrict delete | ||
| FK_acc_product_mapping_m_charge |
|
|
Restrict delete | ||
| FK_savings_product_tax_group |
|
|
Restrict delete | ||
| fk_m_wc_loan_range_delinquency_tag_on_range |
|
|
Restrict delete | ||
| fk_m_wc_loan_range_delinquency_tag_on_delinquency_range |
|
|
Restrict delete | ||
| fk_m_wc_loan_range_delinquency_tag_on_loan |
|
|
Restrict delete | ||
| m_loan_charge_ibfk_2 |
|
|
Restrict delete | ||
| m_loan_charge_ibfk_1 |
|
|
Restrict delete | ||
| FK_loan_charge_created_by |
|
|
Restrict delete | ||
| FK_loan_charge_last_modified_by |
|
|
Restrict delete | ||
| fk_wc_rate_change_created_by |
|
|
Restrict delete | ||
| fk_wc_rate_change_last_modified_by |
|
|
Restrict delete | ||
| fk_wc_rate_change_loan |
|
|
Restrict delete | ||
| FK_wc_loan_product_payment_allocation_rule_created_by |
|
|
Restrict delete | ||
| FK_wc_loan_product_payment_allocation_rule_last_modified_by |
|
|
Restrict delete | ||
| m_wc_loan_product_payment_allocation_rule_fk |
|
|
Restrict delete | ||
| fk_m_rate_approve_user |
|
|
Restrict delete | ||
| fk_m_rate_create_user |
|
|
Restrict delete | ||
| fk_stretchy_parameter_001 |
|
|
Restrict delete | ||
| FK_tax_component_credit_gl_account |
|
|
Restrict delete | ||
| FK_tax_component_debit_gl_account |
|
|
Restrict delete | ||
| FK_tax_component_createdby |
|
|
Restrict delete | ||
| FK_tax_component_lastmodifiedby |
|
|
Restrict delete | ||
| job_exec_step_fk |
|
|
Restrict delete | ||
| FK_m_account_transfer_transaction_from_m_loan_transaction |
|
|
Restrict delete | ||
| FK_m_account_transfer_transaction_account_detail |
|
|
Restrict delete | ||
| FK_m_account_transfer_transaction_m_payment_detail |
|
|
Restrict delete | ||
| FK_m_account_transfer_transaction_to_m_savings_transaction |
|
|
Restrict delete | ||
| FK_m_account_transfer_transaction_to_m_loan_transaction |
|
|
Restrict delete | ||
| FK_m_account_transfer_transaction_from_m_savings_transaction |
|
|
Restrict delete | ||
| m_share_account_purchased_shares_ibfk_1 |
|
|
Restrict delete | ||
| FK_m_wc_loan_transaction_last_modified_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_transaction_payment_detail |
|
|
Restrict delete | ||
| FK_m_wc_loan_transaction_classification_cv |
|
|
Restrict delete | ||
| FK_m_wc_loan_transaction_created_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_transaction_loan |
|
|
Restrict delete | ||
| FK_closedon_userid |
|
|
Restrict delete | ||
| m_loan_ibfk_1 |
|
|
Restrict delete | ||
| FK_loan_created_by |
|
|
Restrict delete | ||
| fkb6f935d87179a0cb |
|
|
Restrict delete | ||
| FK_m_loan_m_staff |
|
|
Restrict delete | ||
| fk7c885877240145 |
|
|
Restrict delete | ||
| FK_rejectedon_userid |
|
|
Restrict delete | ||
| FK_glim_id |
|
|
Restrict delete | ||
| FK_loan_last_modified_by |
|
|
Restrict delete | ||
| FK_withdrawnon_userid |
|
|
Restrict delete | ||
| FK_m_loanpurpose_codevalue |
|
|
Restrict delete | ||
| FK_writeoffreason_m_loan_m_code_value |
|
|
Restrict delete | ||
| FK_disbursedon_userid |
|
|
Restrict delete | ||
| FK_approvedon_userid |
|
|
Restrict delete | ||
| fkb6f935d8c8d4b434 |
|
|
Restrict delete | ||
| FK_wc_loan_charge_last_modified_by |
|
|
Restrict delete | ||
| FK_wc_loan_charge_created_by |
|
|
Restrict delete | ||
| fksairc00000000000001 |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_tracking_on_job_execution_id |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_tracking_on_last_modified_by |
|
|
Restrict delete | ||
| fk_gl_journal_entry_aggregation_tracking_on_created_by |
|
|
Restrict delete | ||
| m_share_account_charge_ibfk_2 |
|
|
Restrict delete | ||
| m_share_account_charge_ibfk_1 |
|
|
Restrict delete | ||
| m_share_account_transactions_charge_mapping_ibfk1 |
|
|
Restrict delete | ||
| m_share_account_transactions_charge_mapping_ibfk2 |
|
|
Restrict delete | ||
| FK_calendar_last_modified_by |
|
|
Restrict delete | ||
| FK_calendar_created_by |
|
|
Restrict delete | ||
| m_survey_components_ibfk_1 |
|
|
Restrict delete | ||
| m_provisioning_criteria_ibfk_2 |
|
|
Restrict delete | ||
| m_provisioning_criteria_ibfk_1 |
|
|
Restrict delete | ||
| FK_m_import_m_document |
|
|
Restrict delete | ||
| FK_m_import_m_appuser |
|
|
Restrict delete | ||
| FK_m_wc_loan_approved_by |
|
|
Restrict delete | ||
| FK_wc_loan_product |
|
|
Restrict delete | ||
| FK_m_wc_loan_rejected_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_created_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_fund |
|
|
Restrict delete | ||
| FK_m_wc_loan_client |
|
|
Restrict delete | ||
| FK_m_wc_loan_closed_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_delinquency_bucket |
|
|
Restrict delete | ||
| FK_m_wc_loan_charge_off_reason |
|
|
Restrict delete | ||
| FK_m_wc_loan_product |
|
|
Restrict delete | ||
| FK_m_wc_loan_last_modified_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_breach_cfg |
|
|
Restrict delete | ||
| FK_m_wc_loan_near_breach |
|
|
Restrict delete | ||
| FK_m_wc_loan_charged_off_by |
|
|
Restrict delete | ||
| FK_m_wc_loan_write_off_reason |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_mapping_ibfk_2 |
|
|
Restrict delete | ||
| m_loanproduct_provisioning_mapping_ibfk_1 |
|
|
Restrict delete | ||
| FK_loan_originator_created_by |
|
|
Restrict delete | ||
| FK_loan_originator_type_cv |
|
|
Restrict delete | ||
| FK_loan_originator_modified_by |
|
|
Restrict delete | ||
| FK_loan_originator_channel_cv |
|
|
Restrict delete | ||
| m_savings_product_charge_ibfk_1 |
|
|
Restrict delete | ||
| m_savings_product_charge_ibfk_2 |
|
|
Restrict delete | ||
| fk_loan_id |
|
|
Restrict delete | ||
| FK_reamortization_reason_code_m_code_value |
|
|
Restrict delete | ||
| FK_group_id |
|
|
Restrict delete | ||
| FK_m_client_charge_paid_by_m_client_charge |
|
|
Restrict delete | ||
| FK_m_client_charge_paid_by_m_client_transaction |
|
|
Restrict delete | ||
| m_survey_questions_ibfk_1 |
|
|
Restrict delete | ||
| FK_m_payment_detail_m_payment_type |
|
|
Restrict delete | ||
| FK_floating_rates_last_modified_by |
|
|
Restrict delete | ||
| FK_floating_rates_created_by |
|
|
Restrict delete | ||
| FK_m_calendar_m_calendar_instance |
|
|
Restrict delete | ||
| FK_ext_asset_owner_je_mapping_modified_by |
|
|
Restrict delete | ||
| FK_ext_asset_owner_je_mapping_created_by |
|
|
Restrict delete | ||
| FK_ext_asset_owner_je_mapping_owner_id |
|
|
Restrict delete | ||
| FK_ext_asset_owner_je_mapping_journal_entry_id |
|
|
Restrict delete | ||
| FK_mappings_m_product_loan_id |
|
|
Restrict delete | ||
| FK_mappings_m_floating_rates_id |
|
|
Restrict delete | ||
| m_appuser_previous_password_ibfk_1 |
|
|
Restrict delete | ||
| job_inst_exec_fk |
|
|
Restrict delete | ||
| sms_campaign_ibfk_1 |
|
|
Restrict delete | ||
| cbId |
|
|
Restrict delete | ||
| m_loan_repayment_schedule_history_ibfk_1 |
|
|
Restrict delete | ||
| m_loan_repayment_schedule_history_ibfk_2 |
|
|
Restrict delete | ||
| FK_savings_account_transaction_tax_details_tax_component |
|
|
Restrict delete | ||
| FK_savings_account_transaction_tax_details_savings_transaction |
|
|
Restrict delete | ||
| lastmodifiedby_id |
|
|
Restrict delete | ||
| createdby_id |
|
|
Restrict delete | ||
| FK_m_delinquency_range_mapping |
|
|
Restrict delete | ||
| FK_m_delinquency_bucket_mapping |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_loan_mapping_owner_transfer_id |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_loan_mapping_loan_id |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_loan_mapping_created_by |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_loan_mapping_modified_by |
|
|
Restrict delete | ||
| FK_m_share_product_dividend_pay_out_lastmodifiedby_id |
|
|
Restrict delete | ||
| FK_m_share_product_dividend_pay_out_product_id |
|
|
Restrict delete | ||
| FK_m_share_product_dividend_pay_out_createdby_id |
|
|
Restrict delete | ||
| fka6a8a7d77240145 |
|
|
Restrict delete | ||
| FK_m_product_loan_m_delinquency_bucket |
|
|
Restrict delete | ||
| fk_cb_lp2 |
|
|
Restrict delete | ||
| cblpfk2 |
|
|
Restrict delete | ||
| address_codefk |
|
|
Restrict delete | ||
| clientaddressfk |
|
|
Restrict delete | ||
| fk_m_loan_officer_assignment_history_0001 |
|
|
Restrict delete | ||
| fk_m_loan_officer_assignment_history_0002 |
|
|
Restrict delete | ||
| FK_loan_term_variations_last_modified_by |
|
|
Restrict delete | ||
| FK_loan_term_variations_created_by |
|
|
Restrict delete | ||
| FK_loan_id_m_loan_id |
|
|
Restrict delete | ||
| m_wc_loan_product_configurable_attributes_fk |
|
|
Restrict delete | ||
| fkcfcea42640be071z |
|
|
Restrict delete | ||
| fk_loan_charge_tax_details_charge |
|
|
Restrict delete | ||
| fk_loan_charge_tax_details_component |
|
|
Restrict delete | ||
| FK_m_loan_transaction_to_relation |
|
|
Restrict delete | ||
| FK_m_loan_charge_to_relation |
|
|
Restrict delete | ||
| FK_m_loan_transaction_from_relation |
|
|
Restrict delete | ||
| fkCollateral |
|
|
Cascade on delete | ||
| fkClient |
|
|
Cascade on delete | ||
| FK_m_client_transaction_m_client |
|
|
Restrict delete | ||
| FK_client_transaction_last_modified_by |
|
|
Restrict delete | ||
| FK_client_transaction_created_by |
|
|
Restrict delete | ||
| fkirs00000000000001 |
|
|
Restrict delete | ||
| FK_m_staff_assignment_history_centre_id_m_group |
|
|
Restrict delete | ||
| FK_m_staff_assignment_history_m_staff |
|
|
Restrict delete | ||
| FK_m_client_charge_m_charge |
|
|
Restrict delete | ||
| FK_m_client_charge_m_client |
|
|
Restrict delete | ||
| FK_loan_credit_allocation_rule_created_by |
|
|
Restrict delete | ||
| m_loan_credit_allocation_rule_fk |
|
|
Restrict delete | ||
| FK_loan_credit_allocation_rule_last_modified_by |
|
|
Restrict delete | ||
| orgcb_cbfk |
|
|
Restrict delete | ||
| fk8dedb048103b544b |
|
|
Restrict delete | ||
| fk8dedb04815cec7ab |
|
|
Restrict delete | ||
| FK_tax_group_mappings_tax_group |
|
|
Restrict delete | ||
| FK_tax_group_mappings_lastmodifiedby |
|
|
Restrict delete | ||
| FK_tax_group_mappings_createdby |
|
|
Restrict delete | ||
| FK_tax_group_mappings_tax_component |
|
|
Restrict delete | ||
| FK_loan_approved_amount_history_last_modified_by |
|
|
Restrict delete | ||
| FK_loan_approved_amount_history_created_by |
|
|
Restrict delete | ||
| FK_loan_approved_amount_history_loan_id |
|
|
Restrict delete | ||
| m_product_loan_charge_ibfk_1 |
|
|
Restrict delete | ||
| m_product_loan_charge_ibfk_2 |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_previous_owner |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_owner_id |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_loan_id |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_modified_by |
|
|
Restrict delete | ||
| FK_external_asset_owner_transfer_created_by |
|
|
Restrict delete | ||
| m_group_client_ibfk_1 |
|
|
Restrict delete | ||
| m_group_client_ibfk_2 |
|
|
Restrict delete | ||
| FK_m_loan_tranche_charges_m_charge |
|
|
Restrict delete | ||
| FK_m_loan_tranche_charges_m_loan |
|
|
Restrict delete | ||
| FK_m_checker_m_appuser |
|
|
Restrict delete | ||
| FK_m_maker_m_appuser |
|
|
Restrict delete | ||
| fk_m_product_loan_configurable_attributes_0001 |
|
|
Restrict delete | ||
| FK_loan_product_credit_allocation_rule_created_by |
|
|
Restrict delete | ||
| m_loan_product_credit_allocation_rule_fk |
|
|
Restrict delete | ||
| FK_loan_product_credit_allocation_rule_last_modified_by |
|
|
Restrict delete | ||
| FK__m_loan_reschedule_request |
|
|
Restrict delete | ||
| FK__m_loan_term_variations |
|
|
Restrict delete | ||
| fkb3d587ce0dd567a |
|
|
Restrict delete | ||
| fk_m_appuser_002 |
|
|
Restrict delete | ||
| FK_m_client_m_client_attendance |
|
|
Restrict delete | ||
| FK_m_meeting_m_client_attendance |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| m_group_level | m_group_level_id_not_null1 | id IS NOT NULL |
| m_wc_loan | m_wc_loan_product_id_not_null1 | product_id IS NOT NULL |