SchemaSpy Analysis of idempiere11.adempiere - ConstraintsBank Statement Generated by
Quality Systems & Solutions
37 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
cbank_cbankaccount c_bankaccount.c_bank_id c_bank.c_bank_id Cascade on delete 
cbankaccount_cbadoc c_bankaccountdoc.c_bankaccount_id c_bankaccount.c_bankaccount_id Cascade on delete 
cbankaccount_cbankstatement c_bankstatement.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_cdepositbatch c_depositbatch.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_cpayment c_payment.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_cpaymtprocessor c_paymentprocessor.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_ibankstatement i_bankstatement.c_bankaccount_id c_bankaccount.c_bankaccount_id Null on delete 
cbankacct_cbankstmtloader c_bankstatementloader.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankstatement_ibankstatement i_bankstatement.c_bankstatement_id c_bankstatement.c_bankstatement_id Null on delete 
cbankstmtline_ibankstmt i_bankstatement.c_bankstatementline_id c_bankstatementline.c_bankstatementline_id Null on delete 
cbpartner_cbankstatementline c_bankstatementline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cinvoice c_invoice.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpayment c_payment.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_ibankstatement i_bankstatement.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbstatement_cbstatementline c_bankstatementline.c_bankstatement_id c_bankstatement.c_bankstatement_id Cascade on delete 
ccurrency_cbankaccount c_bankaccount.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cbankstmtline c_bankstatementline.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cinvoice c_invoice.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cpayment c_payment.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cpaymentprocessor c_paymentprocessor.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ibankstatement i_bankstatement.c_currency_id c_currency.c_currency_id Null on delete 
cdepositbatch_cdepositbatchlin c_depositbatchline.c_depositbatch_id c_depositbatch.c_depositbatch_id Restrict delete 
cdepositbatch_cpayment c_payment.c_depositbatch_id c_depositbatch.c_depositbatch_id Restrict delete 
cinvoice_cbankstatementline c_bankstatementline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cpayment c_payment.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_ibankstatement i_bankstatement.c_invoice_id c_invoice.c_invoice_id Null on delete 
cinvoice_ref c_invoice.ref_invoice_id c_invoice.c_invoice_id Restrict delete 
cpayment_cbankstmtline c_bankstatementline.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cdepositbatchline c_depositbatchline.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cinvoice c_invoice.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_ibankstatement i_bankstatement.c_payment_id c_payment.c_payment_id Null on delete 
cpaymentprocessor_cpayment c_payment.c_paymentprocessor_id c_paymentprocessor.c_paymentprocessor_id Restrict delete 
refpayment_cpayment c_payment.ref_payment_id c_payment.c_payment_id Restrict delete 
relatedinvoice_cinvoice c_invoice.relatedinvoice_id c_invoice.c_invoice_id Restrict delete 
reversal_cinvoice c_invoice.reversal_id c_invoice.c_invoice_id Restrict delete 
reversal_cpayment c_payment.reversal_id c_payment.c_payment_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected