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

Constraint Name Child Column Parent Column Delete Rule
cinvoice_cpayment c_payment.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_crecurring c_recurring.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_crecurringrun c_recurring_run.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_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_crecurring c_recurring.c_order_id c_order.c_order_id Restrict delete 
corder_crecurringrun c_recurring_run.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_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_crecurring c_recurring.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_crecurringrun c_recurring_run.c_payment_id c_payment.c_payment_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 
cproject_crecurring c_recurring.c_project_id c_project.c_project_id Restrict delete 
cproject_crecurringrun c_recurring_run.c_project_id c_project.c_project_id Restrict delete 
crecurring_crecurringrun c_recurring_run.c_recurring_id c_recurring.c_recurring_id Restrict delete 
crecurringgroup_crecurring c_recurring.c_recurringgroup_id c_recurringgroup.c_recurringgroup_id Restrict delete 
gljournalbatch_crecurring c_recurring.gl_journalbatch_id gl_journalbatch.gl_journalbatch_id Restrict delete 
gljournalbatch_crecurringrun c_recurring_run.gl_journalbatch_id gl_journalbatch.gl_journalbatch_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 
reversal_gljournalbatch gl_journalbatch.reversal_id gl_journalbatch.gl_journalbatch_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected