SchemaSpy Analysis of idempiere9.adempiere - ConstraintsPayment Generated by
Quality Systems & Solutions
109 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
c_doctype_corder c_order.c_doctype_id c_doctype.c_doctype_id Restrict delete 
callocation_callocationline c_allocationline.c_allocationhdr_id c_allocationhdr.c_allocationhdr_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_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_cpayselection c_payselection.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_ipayment i_payment.c_bankaccount_id c_bankaccount.c_bankaccount_id Null on delete 
cbankacct_ccashline c_cashline.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbpartner_callocationline c_allocationline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cbankstatementline c_bankstatementline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cbpbankaccount c_bp_bankaccount.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_ccharge c_charge.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_corder c_order.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_cpayselectioncheck c_payselectioncheck.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_cproject c_project.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_ipayment i_payment.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbpartnerbill_corder c_order.bill_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerpay_corder c_order.pay_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_cproject c_project.c_bpartnersr_id c_bpartner.c_bpartner_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 
ccash_ccashline c_cashline.c_cash_id c_cash.c_cash_id Cascade on delete 
ccashline_callocationline c_allocationline.c_cashline_id c_cashline.c_cashline_id Restrict delete 
ccashline_cinvoice c_invoice.c_cashline_id c_cashline.c_cashline_id Restrict delete 
ccashline_corder c_order.c_cashline_id c_cashline.c_cashline_id Restrict delete 
ccharge_callocationline c_allocationline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cbankstmtlime c_bankstatementline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_ccashline c_cashline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cinvoice c_invoice.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_corder c_order.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cpayment c_payment.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_ipayment i_payment.c_charge_id c_charge.c_charge_id Null on delete 
ccurrency_callocation c_allocationhdr.c_currency_id c_currency.c_currency_id Restrict 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_ccashline c_cashline.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_corder c_order.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_cproject c_project.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ipayment i_payment.c_currency_id c_currency.c_currency_id Restrict 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 
cdoctype_callocationhdr c_allocationhdr.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_cdepositbatch c_depositbatch.c_doctype_id c_doctype.c_doctype_id Restrict 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_ipayment i_payment.c_doctype_id c_doctype.c_doctype_id Null on 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 
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_ccashline c_cashline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cinvoicepaysched c_invoicepayschedule.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_cpayment c_payment.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cpaymentallocate c_paymentallocate.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_ipayment i_payment.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 
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_ccashline c_cashline.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_corder c_order.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cpaymentallocate c_paymentallocate.c_payment_id c_payment.c_payment_id Cascade on delete 
cpayment_cpayselectioncheck c_payselectioncheck.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_ipayment i_payment.c_payment_id c_payment.c_payment_id Null on delete 
cpaymentbatch_cpayment c_payment.c_paymentbatch_id c_paymentbatch.c_paymentbatch_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 
cpaymentterm_cbpartner c_bpartner.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cinvoice c_invoice.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cpayschedule c_payschedule.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cproject c_project.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_soheader c_order.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymtallocate_callocationline c_paymentallocate.c_allocationline_id c_allocationline.c_allocationline_id Null on delete 
cpaymtprocessor_cpaymtbatch c_paymentbatch.c_paymentprocessor_id c_paymentprocessor.c_paymentprocessor_id Restrict delete 
cpayschedule_cinvoicepaysched c_invoicepayschedule.c_payschedule_id c_payschedule.c_payschedule_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 
cpopaymentterm_cbpartner c_bpartner.po_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cproject_ccash c_cash.c_project_id c_project.c_project_id Restrict delete 
cproject_cinvoice c_invoice.c_project_id c_project.c_project_id Restrict delete 
cproject_corder c_order.c_project_id c_project.c_project_id Restrict delete 
cproject_cpayment c_payment.c_project_id c_project.c_project_id Restrict delete 
dropshipbpartner_corder c_order.dropship_bpartner_id c_bpartner.c_bpartner_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_callocationhdr c_allocationhdr.reversal_id c_allocationhdr.c_allocationhdr_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