Constraints

368 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
m_provisioning_criteria_definition_ibfk_3
m_provisioning_criteria_definition.liability_account
acc_gl_account.id
Restrict delete
m_provisioning_criteria_definition_ibfk_4
m_provisioning_criteria_definition.expense_account
acc_gl_account.id
Restrict delete
m_provisioning_criteria_definition_ibfk_1
m_provisioning_criteria_definition.criteria_id
m_provisioning_criteria.id
Restrict delete
m_provisioning_criteria_definition_ibfk_2
m_provisioning_criteria_definition.category_id
m_provision_category.id
Restrict delete
m_report_mailing_job_run_history_ibfk_1
m_report_mailing_job_run_history.job_id
m_report_mailing_job.id
Restrict delete
FK_acc_accounting_rule_acc_gl_account_debit
acc_accounting_rule.debit_account_id
acc_gl_account.id
Restrict delete
FK_acc_accounting_rule_acc_gl_account_credit
acc_accounting_rule.credit_account_id
acc_gl_account.id
Restrict delete
FK_acc_accounting_rule_m_office
acc_accounting_rule.office_id
m_office.id
Restrict delete
FK_access_type_code_m_code_value
m_entity_to_entity_access.access_type_code_value_id
m_code_value.id
Restrict delete
FK_m_product_mix_product_id_to_m_product_loan
m_product_mix.product_id
m_product_loan.id
Restrict delete
FK_m_product_mix_restricted_product_id_to_m_product_loan
m_product_mix.restricted_product_id
m_product_loan.id
Restrict delete
FK_acc_gl_journal_entry_acc_gl_account
acc_gl_journal_entry.account_id
acc_gl_account.id
Restrict delete
FK_acc_gl_journal_entry_m_appuser_2
acc_gl_journal_entry.lastmodifiedby_id
m_appuser.id
Restrict delete
FK_acc_gl_journal_entry_m_loan_transaction
acc_gl_journal_entry.loan_transaction_id
m_loan_transaction.id
Restrict delete
FK_acc_gl_journal_entry_m_savings_account_transaction
acc_gl_journal_entry.savings_transaction_id
m_savings_account_transaction.id
Restrict delete
FK_acc_gl_journal_entry_m_office
acc_gl_journal_entry.office_id
m_office.id
Restrict delete
FK_acc_gl_journal_entry_m_payment_detail
acc_gl_journal_entry.payment_details_id
m_payment_detail.id
Restrict delete
FK_acc_gl_journal_entry_m_client_transaction
acc_gl_journal_entry.client_transaction_id
m_client_transaction.id
Restrict delete
FK_acc_gl_journal_entry_m_appuser
acc_gl_journal_entry.createdby_id
m_appuser.id
Restrict delete
FK_acc_gl_journal_entry_acc_gl_journal_entry
acc_gl_journal_entry.reversal_id
acc_gl_journal_entry.id
Restrict delete
FK_acc_gl_journal_entry_m_share_account_transaction
acc_gl_journal_entry.share_transaction_id
m_share_account_transactions.id
Restrict delete
FK__m_loan_transaction
m_loan_charge_paid_by.loan_transaction_id
m_loan_transaction.id
Restrict delete
FK__m_loan_charge
m_loan_charge_paid_by.loan_charge_id
m_loan_charge.id
Restrict delete
FK_m_loan_m_loan_recalculation_details
m_loan_recalculation_details.loan_id
m_loan.id
Restrict delete
m_share_product_market_price_ibfk_1
m_share_product_market_price.product_id
m_share_product.id
Restrict delete
FK_acc_accounting_rule_id
acc_rule_tags.acc_rule_id
acc_accounting_rule.id
Restrict delete
FK_m_code_value_id
acc_rule_tags.tag_id
m_code_value.id
Restrict delete
FK2291C477E2551DCC
m_office.parent_id
m_office.id
Restrict delete
Parent_levelId_reference
m_group_level.parent_id
m_group_level.id
Restrict delete
FK1_request_audit_table_m_client
request_audit_table.client_id
m_client.id
Restrict delete
FKMSS0000000001
m_mandatory_savings_schedule.savings_account_id
m_savings_account.id
Restrict delete
m_entity_datatable_check_ibfk_1
m_entity_datatable_check.x_registered_table_name
x_registered_table.registered_table_name
Restrict delete
FK488B92AA40BE0710
m_loan_repayment_schedule.loan_id
m_loan.id
Restrict delete
FK_m_calendar_m_calendar_history
m_calendar_history.calendar_id
m_calendar.id
Restrict delete
FK_m_standing_instructions_account_transfer_details
m_account_transfer_standing_instructions.account_transfer_details_id
m_account_transfer_details.id
Restrict delete
FK_m_client_document_m_client
m_client_identifier.client_id
m_client.id
Restrict delete
FK_m_client_document_m_code_value
m_client_identifier.document_type_id
m_code_value.id
Restrict delete
FK_guarantee_details_loan_product
m_product_loan_guarantee_details.loan_product_id
m_product_loan.id
Restrict delete
FK1_client_device_registration_m_client
client_device_registration.client_id
m_client.id
Restrict delete
m_survey_responses_ibfk_1
m_survey_responses.question_id
m_survey_questions.id
Restrict delete
notification_mapper_ibfk_3
notification_mapper.notification_id
notification_generator.id
Restrict delete
notification_mapper_ibfk_2
notification_mapper.user_id
m_appuser.id
Restrict delete
FK_m_savings_account_transaction_m_payment_detail
m_savings_account_transaction.payment_detail_id
m_payment_detail.id
Restrict delete
FKSAT0000000001
m_savings_account_transaction.savings_account_id
m_savings_account.id
Restrict delete
FK_m_savings_account_transaction_m_office
m_savings_account_transaction.office_id
m_office.id
Restrict delete
FK_m_calendar_instance_m_meeting
m_meeting.calendar_instance_id
m_calendar_instance.id
Restrict delete
FKDPTP00000000000001
m_deposit_product_term_and_preclosure.savings_product_id
m_savings_product.id
Restrict delete
fk_topic_has_m_appuser_m_appuser1
topic_subscriber.user_id
m_appuser.id
Restrict delete
fk_topic_has_m_appuser_topic
topic_subscriber.topic_id
topic.id
Restrict delete
scheduled_email_campaign_ibfk_1
scheduled_email_campaign.stretchy_report_id
stretchy_report.id
Restrict delete
m_survey_lookup_tables_ibfk_1
m_survey_lookup_tables.survey_id
m_surveys.id
Restrict delete
m_savings_account_charge_ibfk_1
m_savings_account_charge.charge_id
m_charge.id
Restrict delete
m_savings_account_charge_ibfk_2
m_savings_account_charge.savings_account_id
m_savings_account.id
Restrict delete
borrower_cycle_loan_product_FK
m_product_loan_variations_borrower_cycle.loan_product_id
m_product_loan.id
Restrict delete
FK_mappings_m_variable_product_loan_id
m_product_loan_variable_installment_config.loan_product_id
m_product_loan.id
Restrict delete
scheduledjobsFK
job_run_history.job_id
job.id
Restrict delete
cbConfigfk1
m_creditbureau_configuration.organisation_creditbureau_id
m_creditbureau.id
Restrict delete
FKDPIRC00000000000001
m_deposit_product_interest_rate_chart.deposit_product_id
m_savings_product.id
Restrict delete
FKDPIRC00000000000002
m_deposit_product_interest_rate_chart.interest_rate_chart_id
m_interest_rate_chart.id
Restrict delete
FK_m_cashiers_m_staff
m_cashiers.staff_id
m_staff.id
Restrict delete
FK_m_cashiers_m_teller
m_cashiers.teller_id
m_tellers.id
Restrict delete
FK_m_staff_m_image
m_staff.image_id
m_image.id
Restrict delete
FK_m_staff_m_office
m_staff.office_id
m_office.id
Restrict delete
FK7C9708924D26803
m_note.loan_transaction_id
m_loan_transaction.id
Restrict delete
FK7C970898F889C3F
m_note.lastmodifiedby_id
m_appuser.id
Restrict delete
FK_m_note_m_group
m_note.group_id
m_group.id
Restrict delete
FK7C9708940BE0710
m_note.loan_id
m_loan.id
Restrict delete
FK7C97089541F0A56
m_note.createdby_id
m_appuser.id
Restrict delete
FK_savings_account_id
m_note.savings_account_id
m_savings_account.id
Restrict delete
FK7C970897179A0CB
m_note.client_id
m_client.id
Restrict delete
fkClientCollateral
m_loan_collateral_management.client_collateral_id
m_client_collateral_management.id
Cascade on delete
fkLoan
m_loan_collateral_management.loan_id
m_loan.id
Cascade on delete
fkTransaction
m_loan_collateral_management.transaction_id
m_loan_transaction.id
Cascade on delete
FK_mappings_m_floating_rates
m_floating_rates_periods.floating_rates_id
m_floating_rates.id
Restrict delete
address_fields_codefk2
m_address.country_id
m_code_value.id
Restrict delete
address_fields_codefk1
m_address.state_province_id
m_code_value.id
Restrict delete
m_loanproduct_provisioning_entry_ibfk_1
m_loanproduct_provisioning_entry.history_id
m_provisioning_history.id
Restrict delete
m_loanproduct_provisioning_entry_ibfk_2
m_loanproduct_provisioning_entry.criteria_id
m_provisioning_criteria.id
Restrict delete
m_loanproduct_provisioning_entry_ibfk_3
m_loanproduct_provisioning_entry.office_id
m_office.id
Restrict delete
m_loanproduct_provisioning_entry_ibfk_4
m_loanproduct_provisioning_entry.product_id
m_product_loan.id
Restrict delete
m_loanproduct_provisioning_entry_ibfk_5
m_loanproduct_provisioning_entry.category_id
m_provision_category.id
Restrict delete
m_loanproduct_provisioning_entry_ibfk_6
m_loanproduct_provisioning_entry.liability_account
acc_gl_account.id
Restrict delete
m_loanproduct_provisioning_entry_ibfk_7
m_loanproduct_provisioning_entry.expense_account
acc_gl_account.id
Restrict delete
m_share_product_ibfk_1
m_share_product.createdby_id
m_appuser.id
Restrict delete
m_share_product_ibfk_2
m_share_product.lastmodifiedby_id
m_appuser.id
Restrict delete
FKDPRD00000000000001
m_deposit_product_recurring_detail.savings_product_id
m_savings_product.id
Restrict delete
FK_m_charge_m_tax_group
m_charge.tax_group_id
m_tax_group.id
Restrict delete
FK_m_payment_detail_m_payment_types
m_charge.payment_type_id
m_payment_type.id
Restrict delete
FK_m_charge_acc_gl_account
m_charge.income_or_liability_account_id
acc_gl_account.id
Restrict delete
FK_additional_details_repayment_schedule_id
m_loan_interest_recalculation_additional_details.loan_repayment_schedule_id
m_loan_repayment_schedule.id
Restrict delete
FKSTAFF000000001
sms_messages_outbound.staff_id
m_staff.id
Restrict delete
FKGROUP000000001
sms_messages_outbound.group_id
m_group.id
Restrict delete
FKCLIENT00000001
sms_messages_outbound.client_id
m_client.id
Restrict delete
FKCAMPAIGN00000001
sms_messages_outbound.campaign_id
sms_campaign.id
Restrict delete
m_loan_paid_in_advance_ibfk_1
m_loan_paid_in_advance.loan_id
m_loan.id
Restrict delete
FKGLACC000000002
acc_gl_account.tag_id
m_code_value.id
Restrict delete
FK_ACC_0000000001
acc_gl_account.parent_id
acc_gl_account.id
Restrict delete
m_survey_scorecards_ibfk_2
m_survey_scorecards.question_id
m_survey_questions.id
Restrict delete
m_survey_scorecards_ibfk_3
m_survey_scorecards.response_id
m_survey_responses.id
Restrict delete
m_survey_scorecards_ibfk_4
m_survey_scorecards.user_id
m_appuser.id
Restrict delete
m_survey_scorecards_ibfk_5
m_survey_scorecards.client_id
m_client.id
Restrict delete
m_survey_scorecards_ibfk_1
m_survey_scorecards.survey_id
m_surveys.id
Restrict delete
FK_c_external_service_properties_c_external_service
c_external_service_properties.external_service_id
c_external_service.id
Restrict delete
Parent_Id_reference
m_group.parent_id
m_group.id
Restrict delete
m_group_ibfk_1
m_group.office_id
m_office.id
Restrict delete
FK_m_group_m_staff
m_group.staff_id
m_staff.id
Restrict delete
FK_m_group_level
m_group.level_id
m_group_level.id
Restrict delete
FK_m_group_m_code
m_group.closure_reason_cv_id
m_code_value.id
Restrict delete
FK_m_teller_transactions_m_cashiers
m_cashier_transactions.cashier_id
m_cashiers.id
Cascade on delete
FKSAIRS00000000000001
m_savings_account_interest_rate_slab.savings_account_interest_rate_chart_id
m_savings_account_interest_rate_chart.id
Restrict delete
FK_M_LOAN_RATE_RATE
m_loan_rate.rate_id
m_rate.id
Restrict delete
FK_M_LOAN_RATE_LOAN
m_loan_rate.loan_id
m_loan.id
Restrict delete
FK_m_client_transfer_details_m_appuser
m_client_transfer_details.submitted_by
m_appuser.id
Restrict delete
FK_m_client_transfer_details_m_office
m_client_transfer_details.from_office_id
m_office.id
Restrict delete
FK_m_client_transfer_details_m_client
m_client_transfer_details.client_id
m_client.id
Restrict delete
FK_m_client_transfer_details_m_office_2
m_client_transfer_details.to_office_id
m_office.id
Restrict delete
FK_mappings_m_loan_repayment_schedule
m_loan_transaction_repayment_schedule_mapping.loan_repayment_schedule_id
m_loan_repayment_schedule.id
Restrict delete
FK_mappings_m_loan_transaction
m_loan_transaction_repayment_schedule_mapping.loan_transaction_id
m_loan_transaction.id
Restrict delete
linked_loan_fk
m_portfolio_account_associations.linked_loan_account_id
m_loan.id
Restrict delete
account_association_loan_fk
m_portfolio_account_associations.loan_account_id
m_loan.id
Restrict delete
account_association_savings_fk
m_portfolio_account_associations.savings_account_id
m_savings_account.id
Restrict delete
linked_savings_fk
m_portfolio_account_associations.linked_savings_account_id
m_savings_account.id
Restrict delete
m_holiday_id_ibfk_1
m_holiday_office.holiday_id
m_holiday.id
Restrict delete
m_office_id_ibfk_2
m_holiday_office.office_id
m_office.id
Restrict delete
m_deposit_account_term_and_preclosure_ibfk_1
m_deposit_account_term_and_preclosure.transfer_to_savings_account_id
m_savings_account.id
Restrict delete
FKDATP00000000000001
m_deposit_account_term_and_preclosure.savings_account_id
m_savings_account.id
Restrict delete
fk_m_savings_officer_assignment_history_0001
m_savings_officer_assignment_history.account_id
m_savings_account.id
Restrict delete
fk_m_savings_officer_assignment_history_0002
m_savings_officer_assignment_history.savings_officer_id
m_staff.id
Restrict delete
FKCFCEA42640BE0710
m_loan_transaction.loan_id
m_loan.id
Restrict delete
FK_m_loan_transaction_m_payment_detail
m_loan_transaction.payment_detail_id
m_payment_detail.id
Restrict delete
FK_m_loan_transaction_m_office
m_loan_transaction.office_id
m_office.id
Restrict delete
FK_m_account_transfer_details_to_client
m_account_transfer_details.to_client_id
m_client.id
Restrict delete
FK_m_account_transfer_details_from_client
m_account_transfer_details.from_client_id
m_client.id
Restrict delete
FK_m_account_transfer_details_to_savings_account
m_account_transfer_details.to_savings_account_id
m_savings_account.id
Restrict delete
FK_m_account_transfer_details_to_loan_account
m_account_transfer_details.to_loan_account_id
m_loan.id
Restrict delete
FK_m_account_transfer_details_from_office
m_account_transfer_details.from_office_id
m_office.id
Restrict delete
FK_m_account_transfer_details_from_loan_account
m_account_transfer_details.from_loan_account_id
m_loan.id
Restrict delete
FK_m_account_transfer_details_to_office
m_account_transfer_details.to_office_id
m_office.id
Restrict delete
FK_m_account_transfer_details_from_savings_account
m_account_transfer_details.from_savings_account_id
m_savings_account.id
Restrict delete
FKSA00000000000002
m_savings_account.group_id
m_group.id
Restrict delete
FKSA00000000000001
m_savings_account.client_id
m_client.id
Restrict delete
FK_gsim_id
m_savings_account.gsim_id
gsim_accounts.id
Restrict delete
FK_savings_account_tax_group
m_savings_account.tax_group_id
m_tax_group.id
Restrict delete
FKSA00000000000003
m_savings_account.product_id
m_savings_product.id
Restrict delete
FK_collateral_code_value
m_loan_collateral.type_cv_id
m_code_value.id
Restrict delete
FK_collateral_m_loan
m_loan_collateral.loan_id
m_loan.id
Restrict delete
FK_m_product_loan_m_product_loan_recalculation_details
m_product_loan_recalculation_details.product_id
m_product_loan.id
Restrict delete
FK_job_id
job_parameters.job_id
job.id
Restrict delete
FK__rel_id_m_entity_relation_id
m_entity_to_entity_mapping.rel_id
m_entity_relation.id
Restrict delete
FK_m_share_account_dividend_details_account_id
m_share_account_dividend_details.account_id
m_share_account.id
Restrict delete
FK_m_share_account_dividend_details_dividend_pay_out_id
m_share_account_dividend_details.dividend_pay_out_id
m_share_product_dividend_pay_out.id
Restrict delete
SEFKGROUP000000001
scheduled_email_messages_outbound.group_id
m_group.id
Restrict delete
SEFKSTAFF000000001
scheduled_email_messages_outbound.staff_id
m_staff.id
Restrict delete
fk_schedule_email_campign1
scheduled_email_messages_outbound.email_campaign_id
scheduled_email_campaign.id
Restrict delete
SEFKCLIENT00000001
scheduled_email_messages_outbound.client_id
m_client.id
Restrict delete
fk_report_parameter_002
stretchy_report_parameter.parameter_id
stretchy_parameter.id
Restrict delete
fk_report_parameter_001
stretchy_report_parameter.report_id
stretchy_report.id
Cascade on delete
FK_tax_group_createdby
m_tax_group.createdby_id
m_appuser.id
Restrict delete
FK_tax_group_lastmodifiedby
m_tax_group.lastmodifiedby_id
m_appuser.id
Restrict delete
FK_m_tellers_gl_account_credit_account_id
m_tellers.credit_account_id
acc_gl_account.id
Restrict delete
FK_m_tellers_gl_account_debit_account_id
m_tellers.debit_account_id
acc_gl_account.id
Restrict delete
FK_m_tellers_m_office
m_tellers.office_id
m_office.id
Restrict delete
FK7662CE59B4100309
m_appuser_role.appuser_id
m_appuser.id
Restrict delete
FK7662CE5915CEC7AB
m_appuser_role.role_id
m_role.id
Restrict delete
fk_2fa_access_token_user_id
twofactor_access_token.appuser_id
m_appuser.id
Restrict delete
fkCurrencyCode
m_collateral_management.currency
m_currency.id
Cascade on delete
FK_gsim_group_id
gsim_accounts.group_id
m_group.id
Restrict delete
FK_m_interest_incentives_m_interest_rate_slab
m_interest_incentives.interest_rate_slab_id
m_interest_rate_slab.id
Restrict delete
m_loan_reschedule_request_ibfk_1
m_loan_reschedule_request.loan_id
m_loan.id
Restrict delete
m_loan_reschedule_request_ibfk_2
m_loan_reschedule_request.reschedule_reason_cv_id
m_code_value.id
Restrict delete
m_loan_reschedule_request_ibfk_3
m_loan_reschedule_request.submitted_by_user_id
m_appuser.id
Restrict delete
m_loan_reschedule_request_ibfk_4
m_loan_reschedule_request.approved_by_user_id
m_appuser.id
Restrict delete
m_loan_reschedule_request_ibfk_5
m_loan_reschedule_request.rejected_by_user_id
m_appuser.id
Restrict delete
FK_m_guarantor_m_code_value
m_guarantor.client_reln_cv_id
m_code_value.id
Restrict delete
FK_m_guarantor_m_loan
m_guarantor.loan_id
m_loan.id
Restrict delete
FK_m_account_transfer_standing_instructions_m_history
m_account_transfer_standing_instructions_history.standing_instruction_id
m_account_transfer_standing_instructions.id
Restrict delete
m_loan_topup_FK_closure_loan_id
m_loan_topup.closure_loan_id
m_loan.id
Restrict delete
m_loan_topup_FK_loan_id
m_loan_topup.loan_id
m_loan.id
Restrict delete
m_loan_topup_FK_account_transfer_details_id
m_loan_topup.account_transfer_details_id
m_account_transfer_details.id
Restrict delete
m_share_account_ibfk_2
m_share_account.savings_account_id
m_savings_account.id
Restrict delete
m_share_account_ibfk_1
m_share_account.product_id
m_share_product.id
Restrict delete
m_share_account_ibfk_4
m_share_account.approved_userid
m_appuser.id
Restrict delete
m_share_account_ibfk_3
m_share_account.submitted_userid
m_appuser.id
Restrict delete
m_share_account_ibfk_6
m_share_account.activated_userid
m_appuser.id
Restrict delete
m_share_account_ibfk_5
m_share_account.rejected_userid
m_appuser.id
Restrict delete
m_share_account_ibfk_8
m_share_account.lastmodifiedby_id
m_appuser.id
Restrict delete
m_share_account_ibfk_7
m_share_account.closed_userid
m_appuser.id
Restrict delete
m_share_account_ibfk_9
m_share_account.client_id
m_client.id
Restrict delete
FK_x_code_id
x_table_column_code_mappings.code_id
m_code.id
Restrict delete
FK__m_appuser__pocket
m_pocket.app_user_id
m_appuser.id
Restrict delete
FK_m_loan_overdue_installment_charge_m_loan_repayment_schedule
m_loan_overdue_installment_charge.loan_schedule_id
m_loan_repayment_schedule.id
Restrict delete
FK_m_loan_overdue_installment_charge_m_loan_charge
m_loan_overdue_installment_charge.loan_charge_id
m_loan_charge.id
Restrict delete
FK_acc_gl_closure_m_appuser_2
acc_gl_closure.lastmodifiedby_id
m_appuser.id
Restrict delete
FK_acc_gl_closure_m_office
acc_gl_closure.office_id
m_office.id
Restrict delete
FK_acc_gl_closure_m_appuser
acc_gl_closure.createdby_id
m_appuser.id
Restrict delete
FK_m_loan_tranche_disbursement_charge_m_loan_charge
m_loan_tranche_disbursement_charge.loan_charge_id
m_loan_charge.id
Restrict delete
FK_m_loan_tranche_disbursement_charge_m_loan_disbursement_detail
m_loan_tranche_disbursement_charge.disbursement_detail_id
m_loan_disbursement_detail.id
Restrict delete
m_report_mailing_job_ibfk_1
m_report_mailing_job.createdby_id
m_appuser.id
Restrict delete
m_report_mailing_job_ibfk_4
m_report_mailing_job.run_as_userid
m_appuser.id
Restrict delete
m_report_mailing_job_ibfk_2
m_report_mailing_job.lastmodifiedby_id
m_appuser.id
Restrict delete
m_report_mailing_job_ibfk_3
m_report_mailing_job.stretchy_report_id
stretchy_report.id
Restrict delete
FK1E37728B783C5C25
m_office_transaction.from_office_id
m_office.id
Restrict delete
FK1E37728B93C6C1B6
m_office_transaction.to_office_id
m_office.id
Restrict delete
FK_deposit_on_hold_transaction_m_savings_account
m_deposit_account_on_hold_transaction.savings_account_id
m_savings_account.id
Restrict delete
fk_hook_template_id
m_hook_schema.hook_template_id
m_hook_templates.id
Restrict delete
FK_m_savings_interest_incentives_m_savings_interest_rate_slab
m_savings_interest_incentives.deposit_account_interest_rate_slab_id
m_savings_account_interest_rate_slab.id
Restrict delete
fk_hook_id_cfg
m_hook_configuration.hook_id
m_hook.id
Restrict delete
FK_m_family_members_client_id_m_client
m_family_members.client_id
m_client.id
Restrict delete
FK_m_family_members_marital_status_m_code_value
m_family_members.marital_status_cv_id
m_code_value.id
Restrict delete
FK_m_family_members_relationship_m_code_value
m_family_members.relationship_cv_id
m_code_value.id
Restrict delete
FK_m_family_members_gender_m_code_value
m_family_members.gender_cv_id
m_code_value.id
Restrict delete
FK_m_family_members_profession_m_code_value
m_family_members.profession_cv_id
m_code_value.id
Restrict delete
fk_template_id
m_hook.template_id
m_hook_templates.id
Restrict delete
fk_ugd_template_id
m_hook.ugd_template_id
m_template.id
Restrict delete
FK_tax_component_history_lastmodifiedby
m_tax_component_history.lastmodifiedby_id
m_appuser.id
Restrict delete
FK_tax_component_history_createdby
m_tax_component_history.createdby_id
m_appuser.id
Restrict delete
FK_tax_component_history_tax_component_id
m_tax_component_history.tax_component_id
m_tax_component.id
Restrict delete
m_loan_arrears_aging_ibfk_1
m_loan_arrears_aging.loan_id
m_loan.id
Restrict delete
FKDARD00000000000001
m_deposit_account_recurring_detail.savings_account_id
m_savings_account.id
Restrict delete
fk_interop_identifier_account
interop_identifier.account_id
m_savings_account.id
Restrict delete
m_share_product_charge_ibfk_1
m_share_product_charge.charge_id
m_charge.id
Restrict delete
m_share_product_charge_ibfk_2
m_share_product_charge.product_id
m_share_product.id
Restrict delete
FK_loan_disbursement_detail_loan_id
m_loan_disbursement_detail.loan_id
m_loan.id
Restrict delete
FK_grouprole_m_codevalue
m_group_roles.role_cv_id
m_code_value.id
Restrict delete
FKGroupRoleGroupId
m_group_roles.group_id
m_group.id
Restrict delete
FKGroupRoleClientId
m_group_roles.client_id
m_client.id
Restrict delete
FK_loan_schedule_id_charge_schedule
m_loan_installment_charge.loan_schedule_id
m_loan_repayment_schedule.id
Restrict delete
FK_loan_charge_id_charge_schedule
m_loan_installment_charge.loan_charge_id
m_loan_charge.id
Restrict delete
FK_m_client_m_savings_product
m_client.default_savings_product
m_savings_product.id
Restrict delete
FK_m_client_substatus_m_code_value
m_client.sub_status
m_code_value.id
Restrict delete
FK_m_client_m_staff
m_client.staff_id
m_staff.id
Restrict delete
FK1_m_client_gender_m_code_value
m_client.gender_cv_id
m_code_value.id
Restrict delete
FK_m_client_m_code
m_client.closure_reason_cv_id
m_code_value.id
Restrict delete
FK_m_client_m_image
m_client.image_id
m_image.id
Restrict delete
FK_m_client_type_mcode_value_reject
m_client.reject_reason_cv_id
m_code_value.id
Restrict delete
FKCE00CAB3E0DD567A
m_client.office_id
m_office.id
Restrict delete
FK_m_client_type_m_code_value_withdraw
m_client.withdraw_reason_cv_id
m_code_value.id
Restrict delete
FK_m_client_m_office
m_client.transfer_to_office_id
m_office.id
Restrict delete
FK_m_client_classification_m_code_value
m_client.client_classification_cv_id
m_code_value.id
Restrict delete
FK_m_client_type_m_code_value
m_client.client_type_cv_id
m_code_value.id
Restrict delete
FK_m_client_m_savings_account
m_client.default_savings_account
m_savings_account.id
Restrict delete
fk_hook_idc
m_hook_registered_events.hook_id
m_hook.id
Restrict delete
FK_M_PRODUCT_LOAN_RATE_LOAN
m_product_loan_rate.product_loan_id
m_product_loan.id
Restrict delete
FK_M_PRODUCT_LOAN_RATE_RATE
m_product_loan_rate.rate_id
m_rate.id
Restrict delete
FK_guarantor_transaction_guarantor_fund_detail
m_guarantor_transaction.guarantor_fund_detail_id
m_guarantor_funding_details.id
Restrict delete
FK_guarantor_transaction_m_deposit_account_on_hold_transaction
m_guarantor_transaction.deposit_on_hold_transaction_id
m_deposit_account_on_hold_transaction.id
Restrict delete
FK_guarantor_transaction_m_loan_transaction
m_guarantor_transaction.loan_transaction_id
m_loan_transaction.id
Restrict delete
FK__m_savings_account_transaction
m_savings_account_charge_paid_by.savings_account_transaction_id
m_savings_account_transaction.id
Restrict delete
FK__m_savings_account_charge
m_savings_account_charge_paid_by.savings_account_charge_id
m_savings_account_charge.id
Restrict delete
m_provisioning_history_ibfk_1
m_provisioning_history.createdby_id
m_appuser.id
Restrict delete
m_provisioning_history_ibfk_2
m_provisioning_history.lastmodifiedby_id
m_appuser.id
Restrict delete
FK_client_id
m_client_non_person.client_id
m_client.id
Restrict delete
FK_m_guarantor_fund_details_account_associations_id
m_guarantor_funding_details.account_associations_id
m_portfolio_account_associations.id
Restrict delete
FK_m_guarantor_fund_details_m_guarantor
m_guarantor_funding_details.guarantor_id
m_guarantor.id
Restrict delete
fkrepaymentwithpostdated
m_repayment_with_post_dated_checks.repayment_id
m_loan_repayment_schedule.id
Cascade on delete
fkloanrepayment
m_repayment_with_post_dated_checks.loan_id
m_loan.id
Cascade on delete
FK_office_mapping_acc_gl_account
acc_gl_financial_activity_account.gl_account_id
acc_gl_account.id
Restrict delete
FK_acc_product_mapping_m_payment_type
acc_product_mapping.payment_type
m_payment_type.id
Restrict delete
FK_acc_product_mapping_m_charge
acc_product_mapping.charge_id
m_charge.id
Restrict delete
FK_savings_product_tax_group
m_savings_product.tax_group_id
m_tax_group.id
Restrict delete
m_loan_charge_ibfk_2
m_loan_charge.loan_id
m_loan.id
Restrict delete
m_loan_charge_ibfk_1
m_loan_charge.charge_id
m_charge.id
Restrict delete
FK_M_RATE_APPROVE_USER
m_rate.approve_user
m_appuser.id
Restrict delete
FK_M_RATE_CREATE_USER
m_rate.createdby_id
m_appuser.id
Restrict delete
fk_stretchy_parameter_001
stretchy_parameter.parent_id
stretchy_parameter.id
Restrict delete
FK_tax_component_credit_gl_account
m_tax_component.credit_account_id
acc_gl_account.id
Restrict delete
FK_tax_component_debit_gl_account
m_tax_component.debit_account_id
acc_gl_account.id
Restrict delete
FK_tax_component_createdby
m_tax_component.createdby_id
m_appuser.id
Restrict delete
FK_tax_component_lastmodifiedby
m_tax_component.lastmodifiedby_id
m_appuser.id
Restrict delete
m_share_account_purchased_shares_ibfk_1
m_share_account_transactions.account_id
m_share_account.id
Restrict delete
FK_m_account_transfer_transaction_from_m_loan_transaction
m_account_transfer_transaction.from_loan_transaction_id
m_loan_transaction.id
Restrict delete
FK_m_account_transfer_transaction_account_detail
m_account_transfer_transaction.account_transfer_details_id
m_account_transfer_details.id
Restrict delete
FK_m_account_transfer_transaction_to_m_savings_transaction
m_account_transfer_transaction.to_savings_transaction_id
m_savings_account_transaction.id
Restrict delete
FK_m_account_transfer_transaction_to_m_loan_transaction
m_account_transfer_transaction.to_loan_transaction_id
m_loan_transaction.id
Restrict delete
FK_m_account_transfer_transaction_from_m_savings_transaction
m_account_transfer_transaction.from_savings_transaction_id
m_savings_account_transaction.id
Restrict delete
FK_loan_ltp_strategy
m_loan.loan_transaction_strategy_id
ref_loan_transaction_processing_strategy.id
Restrict delete
FK_closedon_userid
m_loan.closedon_userid
m_appuser.id
Restrict delete
m_loan_ibfk_1
m_loan.group_id
m_group.id
Restrict delete
FKB6F935D87179A0CB
m_loan.client_id
m_client.id
Restrict delete
FK_m_loan_m_staff
m_loan.loan_officer_id
m_staff.id
Restrict delete
FK7C885877240145
m_loan.fund_id
m_fund.id
Restrict delete
FK_rejectedon_userid
m_loan.rejectedon_userid
m_appuser.id
Restrict delete
FK_glim_id
m_loan.glim_id
glim_accounts.id
Restrict delete
FK_withdrawnon_userid
m_loan.withdrawnon_userid
m_appuser.id
Restrict delete
FK_m_loanpurpose_codevalue
m_loan.loanpurpose_cv_id
m_code_value.id
Restrict delete
FK_writeoffreason_m_loan_m_code_value
m_loan.writeoff_reason_cv_id
m_code_value.id
Restrict delete
FK_disbursedon_userid
m_loan.disbursedon_userid
m_appuser.id
Restrict delete
FK_submittedon_userid
m_loan.submittedon_userid
m_appuser.id
Restrict delete
FK_approvedon_userid
m_loan.approvedon_userid
m_appuser.id
Restrict delete
FKB6F935D8C8D4B434
m_loan.product_id
m_product_loan.id
Restrict delete
FKSAIRC00000000000001
m_savings_account_interest_rate_chart.savings_account_id
m_savings_account.id
Restrict delete
m_share_account_charge_ibfk_2
m_share_account_charge.account_id
m_share_account.id
Restrict delete
m_share_account_charge_ibfk_1
m_share_account_charge.charge_id
m_charge.id
Restrict delete
m_share_account_transactions_charge_mapping_ibfk1
m_share_account_charge_paid_by.share_transaction_id
m_share_account_transactions.id
Restrict delete
m_share_account_transactions_charge_mapping_ibfk2
m_share_account_charge_paid_by.charge_transaction_id
m_share_account_charge.id
Restrict delete
m_survey_components_ibfk_1
m_survey_components.survey_id
m_surveys.id
Restrict delete
m_provisioning_criteria_ibfk_2
m_provisioning_criteria.lastmodifiedby_id
m_appuser.id
Restrict delete
m_provisioning_criteria_ibfk_1
m_provisioning_criteria.createdby_id
m_appuser.id
Restrict delete
FK_m_import_m_document
m_import_document.document_id
m_document.id
Restrict delete
FK_m_import_m_appuser
m_import_document.createdby_id
m_appuser.id
Restrict delete
m_loanproduct_provisioning_mapping_ibfk_2
m_loanproduct_provisioning_mapping.criteria_id
m_provisioning_criteria.id
Restrict delete
m_loanproduct_provisioning_mapping_ibfk_1
m_loanproduct_provisioning_mapping.product_id
m_product_loan.id
Restrict delete
m_savings_product_charge_ibfk_1
m_savings_product_charge.charge_id
m_charge.id
Restrict delete
m_savings_product_charge_ibfk_2
m_savings_product_charge.savings_product_id
m_savings_product.id
Restrict delete
FK_group_id
glim_accounts.group_id
m_group.id
Restrict delete
FK_m_client_charge_paid_by_m_client_charge
m_client_charge_paid_by.client_charge_id
m_client_charge.id
Restrict delete
FK_m_client_charge_paid_by_m_client_transaction
m_client_charge_paid_by.client_transaction_id
m_client_transaction.id
Restrict delete
m_survey_questions_ibfk_1
m_survey_questions.survey_id
m_surveys.id
Restrict delete
FK_m_payment_detail_m_payment_type
m_payment_detail.payment_type_id
m_payment_type.id
Restrict delete
FK_m_calendar_m_calendar_instance
m_calendar_instance.calendar_id
m_calendar.id
Restrict delete
FK_mappings_m_product_loan_id
m_product_loan_floating_rates.loan_product_id
m_product_loan.id
Restrict delete
FK_mappings_m_floating_rates_id
m_product_loan_floating_rates.floating_rates_id
m_floating_rates.id
Restrict delete
m_appuser_previous_password_ibfk_1
m_appuser_previous_password.user_id
m_appuser.id
Restrict delete
sms_campaign_ibfk_1
sms_campaign.report_id
stretchy_report.id
Restrict delete
cbId
m_creditreport.credit_bureau_id
m_creditbureau.id
Restrict delete
m_loan_repayment_schedule_history_ibfk_1
m_loan_repayment_schedule_history.loan_id
m_loan.id
Restrict delete
m_loan_repayment_schedule_history_ibfk_2
m_loan_repayment_schedule_history.loan_reschedule_request_id
m_loan_reschedule_request.id
Restrict delete
FK_savings_account_transaction_tax_details_tax_component
m_savings_account_transaction_tax_details.tax_component_id
m_tax_component.id
Restrict delete
FK_savings_account_transaction_tax_details_savings_transaction
m_savings_account_transaction_tax_details.savings_transaction_id
m_savings_account_transaction.id
Restrict delete
lastmodifiedby_id
m_adhoc.lastmodifiedby_id
m_appuser.id
Restrict delete
createdby_id
m_adhoc.createdby_id
m_appuser.id
Restrict delete
FK_m_share_product_dividend_pay_out_lastmodifiedby_id
m_share_product_dividend_pay_out.lastmodifiedby_id
m_appuser.id
Restrict delete
FK_m_share_product_dividend_pay_out_product_id
m_share_product_dividend_pay_out.product_id
m_share_product.id
Restrict delete
FK_m_share_product_dividend_pay_out_createdby_id
m_share_product_dividend_pay_out.createdby_id
m_appuser.id
Restrict delete
FK__m_pocket
m_pocket_accounts_mapping.pocket_id
m_pocket.id
Restrict delete
FKA6A8A7D77240145
m_product_loan.fund_id
m_fund.id
Restrict delete
FK_ltp_strategy
m_product_loan.loan_transaction_strategy_id
ref_loan_transaction_processing_strategy.id
Restrict delete
fk_cb_lp2
m_creditbureau_loanproduct_mapping.loan_product_id
m_product_loan.id
Restrict delete
cblpfk2
m_creditbureau_loanproduct_mapping.organisation_creditbureau_id
m_organisation_creditbureau.id
Restrict delete
FK_loan_id_m_loan_id
m_loan_term_variations.loan_id
m_loan.id
Restrict delete
fk_m_loan_officer_assignment_history_0001
m_loan_officer_assignment_history.loan_id
m_loan.id
Restrict delete
fk_m_loan_officer_assignment_history_0002
m_loan_officer_assignment_history.loan_officer_id
m_staff.id
Restrict delete
address_codefk
m_client_address.address_type_id
m_code_value.id
Restrict delete
clientaddressfk
m_client_address.client_id
m_client.id
Restrict delete
FKCFCEA42640BE071Z
m_code_value.code_id
m_code.id
Restrict delete
fkCollateral
m_client_collateral_management.collateral_id
m_collateral_management.id
Cascade on delete
fkClient
m_client_collateral_management.client_id
m_client.id
Cascade on delete
FK_m_client_transaction_m_appuser
m_client_transaction.appuser_id
m_appuser.id
Restrict delete
FK_m_client_transaction_m_client
m_client_transaction.client_id
m_client.id
Restrict delete
FKIRS00000000000001
m_interest_rate_slab.interest_rate_chart_id
m_interest_rate_chart.id
Restrict delete
FK_m_staff_assignment_history_centre_id_m_group
m_staff_assignment_history.centre_id
m_group.id
Restrict delete
FK_m_staff_assignment_history_m_staff
m_staff_assignment_history.staff_id
m_staff.id
Restrict delete
m_selfservice_appuser_id
m_selfservice_user_client_mapping.appuser_id
m_appuser.id
Restrict delete
m_selfservice_client_id
m_selfservice_user_client_mapping.client_id
m_client.id
Restrict delete
FK_m_client_charge_m_charge
m_client_charge.charge_id
m_charge.id
Restrict delete
FK_m_client_charge_m_client
m_client_charge.client_id
m_client.id
Restrict delete
orgcb_cbfk
m_organisation_creditbureau.creditbureau_id
m_creditbureau.id
Restrict delete
FK8DEDB048103B544B
m_role_permission.permission_id
m_permission.id
Restrict delete
FK8DEDB04815CEC7AB
m_role_permission.role_id
m_role.id
Restrict delete
FK_tax_group_mappings_tax_group
m_tax_group_mappings.tax_group_id
m_tax_group.id
Restrict delete
FK_tax_group_mappings_lastmodifiedby
m_tax_group_mappings.lastmodifiedby_id
m_appuser.id
Restrict delete
FK_tax_group_mappings_createdby
m_tax_group_mappings.createdby_id
m_appuser.id
Restrict delete
FK_tax_group_mappings_tax_component
m_tax_group_mappings.tax_component_id
m_tax_component.id
Restrict delete
m_product_loan_charge_ibfk_1
m_product_loan_charge.charge_id
m_charge.id
Restrict delete
m_product_loan_charge_ibfk_2
m_product_loan_charge.product_loan_id
m_product_loan.id
Restrict delete
FK_m_loan_tranche_charges_m_charge
m_loan_tranche_charges.charge_id
m_charge.id
Restrict delete
FK_m_loan_tranche_charges_m_loan
m_loan_tranche_charges.loan_id
m_loan.id
Restrict delete
m_group_client_ibfk_1
m_group_client.group_id
m_group.id
Restrict delete
m_group_client_ibfk_2
m_group_client.client_id
m_client.id
Restrict delete
fk_m_product_loan_configurable_attributes_0001
m_product_loan_configurable_attributes.loan_product_id
m_product_loan.id
Restrict delete
FK_m_checker_m_appuser
m_portfolio_command_source.checker_id
m_appuser.id
Restrict delete
FK_m_maker_m_appuser
m_portfolio_command_source.maker_id
m_appuser.id
Restrict delete
FK__m_loan_reschedule_request
m_loan_reschedule_request_term_variations_mapping.loan_reschedule_request_id
m_loan_reschedule_request.id
Restrict delete
FK__m_loan_term_variations
m_loan_reschedule_request_term_variations_mapping.loan_term_variations_id
m_loan_term_variations.id
Restrict delete
FKB3D587CE0DD567A
m_appuser.office_id
m_office.id
Restrict delete
fk_m_appuser_002
m_appuser.staff_id
m_staff.id
Restrict delete
FK_m_client_m_client_attendance
m_client_attendance.client_id
m_client.id
Restrict delete
FK_m_meeting_m_client_attendance
m_client_attendance.meeting_id
m_meeting.id
Restrict delete

Check Constraints

Table Constraint Name Constraint