SchemaSpy Analysis of idempiere9.adempiere - ConstraintsBank & Cash Generated by
Quality Systems & Solutions
58 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ad_sequence_doctypedoc c_doctype.docnosequence_id ad_sequence.ad_sequence_id Restrict delete 
adsequence_cpaymentprocessor c_paymentprocessor.ad_sequence_id ad_sequence.ad_sequence_id Restrict delete 
c_doctype_corder c_order.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cbank_cbankaccount c_bankaccount.c_bank_id c_bank.c_bank_id Cascade on delete 
cbank_cbpbankaccount c_bp_bankaccount.c_bank_id c_bank.c_bank_id Null on delete 
cbankaccount_cbadoc c_bankaccountdoc.c_bankaccount_id c_bankaccount.c_bankaccount_id Cascade on delete 
cbankaccount_cbankaccountproce c_bankaccount_processor.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_cbankstatement c_bankstatement.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_cpayselection c_payselection.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbpbankaccount_cpayselectionch c_payselectioncheck.c_bp_bankaccount_id c_bp_bankaccount.c_bp_bankaccount_id Restrict delete 
cbpbankacct_cpayment c_payment.c_bp_bankaccount_id c_bp_bankaccount.c_bp_bankaccount_id Null on delete 
cbstatement_cbstatementline c_bankstatementline.c_bankstatement_id c_bankstatement.c_bankstatement_id Cascade on delete 
cdoctype_cinvoice c_invoice.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_cpayment c_payment.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_invoice c_doctype.c_doctypeinvoice_id c_doctype.c_doctype_id Restrict delete 
cdoctype_proforma c_doctype.c_doctypeproforma_id c_doctype.c_doctype_id Restrict delete 
cdoctype_shipment c_doctype.c_doctypeshipment_id c_doctype.c_doctype_id Restrict delete 
cdoctypedifference_cdoctype c_doctype.c_doctypedifference_id c_doctype.c_doctype_id Restrict delete 
cdoctypetarget_cinvoice c_invoice.c_doctypetarget_id c_doctype.c_doctype_id Restrict delete 
cdoctypetarget_corder c_order.c_doctypetarget_id c_doctype.c_doctype_id Restrict delete 
cdunninglevel_cdunningrun c_dunningrun.c_dunninglevel_id c_dunninglevel.c_dunninglevel_id Restrict delete 
cdunninglevel_cdunningrunentry c_dunningrunentry.c_dunninglevel_id c_dunninglevel.c_dunninglevel_id Restrict delete 
cdunninglevel_cinvoice c_invoice.c_dunninglevel_id c_dunninglevel.c_dunninglevel_id Restrict delete 
cdunningrun_cdunningrunentry c_dunningrunentry.c_dunningrun_id c_dunningrun.c_dunningrun_id Cascade on delete 
cdunningrunentry_line c_dunningrunline.c_dunningrunentry_id c_dunningrunentry.c_dunningrunentry_id Cascade on delete 
cinvoice_callocationline c_allocationline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cbankstatementline c_bankstatementline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cdunningrunline c_dunningrunline.c_invoice_id c_invoice.c_invoice_id Null on delete 
cinvoice_cpayment c_payment.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cpayselectline c_payselectionline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_ref c_invoice.ref_invoice_id c_invoice.c_invoice_id Restrict delete 
corder_callocation c_allocationline.c_order_id c_order.c_order_id Restrict delete 
corder_cinvoice c_invoice.c_order_id c_order.c_order_id Restrict delete 
corder_cpayment c_payment.c_order_id c_order.c_order_id Restrict delete 
corder_ref c_order.ref_order_id c_order.c_order_id Restrict delete 
cpayment_callocationline c_allocationline.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cbankstmtline c_bankstatementline.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cdunningrunline c_dunningrunline.c_payment_id c_payment.c_payment_id Null on delete 
cpayment_cinvoice c_invoice.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_corder c_order.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cpayselectioncheck c_payselectioncheck.c_payment_id c_payment.c_payment_id Restrict delete 
cpaymentbatch_cpayment c_payment.c_paymentbatch_id c_paymentbatch.c_paymentbatch_id Restrict delete 
cpaymentprocessor_cbankaccount c_bankaccount_processor.c_paymentprocessor_id c_paymentprocessor.c_paymentprocessor_id Restrict delete 
cpaymentprocessor_cbpbankaccou c_bp_bankaccount.c_paymentprocessor_id c_paymentprocessor.c_paymentprocessor_id Restrict delete 
cpaymentprocessor_cpayment c_payment.c_paymentprocessor_id c_paymentprocessor.c_paymentprocessor_id Restrict delete 
cpaymtprocessor_cpaymtbatch c_paymentbatch.c_paymentprocessor_id c_paymentprocessor.c_paymentprocessor_id Restrict delete 
cpaysel_cpayselline c_payselectionline.c_payselection_id c_payselection.c_payselection_id Cascade on delete 
cpayselcheck_cpayselline c_payselectionline.c_payselectioncheck_id c_payselectioncheck.c_payselectioncheck_id Restrict delete 
cpayselection_cpayselectcheck c_payselectioncheck.c_payselection_id c_payselection.c_payselection_id Restrict delete 
definitesequence_cdoctype c_doctype.definitesequence_id ad_sequence.ad_sequence_id Restrict delete 
linkorder_corder c_order.link_order_id c_order.c_order_id Restrict delete 
quotationorder_corder c_order.quotationorder_id c_order.c_order_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