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

Constraint Name Child Column Parent Column Delete Rule
adpinstance_adpinstancepara ad_pinstance_para.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_pilog ad_pinstance_log.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_taging t_aging.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_tinventoryvalue t_inventoryvalue.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_tinvoicegl t_invoicegl.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_treplenish t_replenish.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_tspool t_spool.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
adpinstance_ttransaction t_transaction.ad_pinstance_id ad_pinstance.ad_pinstance_id Cascade on delete 
c_buspartner_fact_acct fact_acct.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
c_currency_fact_acct fact_acct.c_currency_id c_currency.c_currency_id Restrict delete 
c_project_fact_acct fact_acct.c_project_id c_project.c_project_id Restrict delete 
cactivity_cinvoice c_invoice.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_cproject c_project.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_factacct fact_acct.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_taging t_aging.c_activity_id c_activity.c_activity_id Cascade on delete 
cbpartner_cinvoice c_invoice.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_taging t_aging.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartnersr_cproject c_project.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
cbpgroup_cbpartner c_bpartner.c_bp_group_id c_bp_group.c_bp_group_id Restrict delete 
cbpgroup_taging t_aging.c_bp_group_id c_bp_group.c_bp_group_id Cascade on delete 
ccampaign_cinvoice c_invoice.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_cproject c_project.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_taging t_aging.c_campaign_id c_campaign.c_campaign_id Cascade on delete 
cconversiontype_cinvoice c_invoice.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_tinvoicegl t_invoicegl.c_conversiontypereval_id c_conversiontype.c_conversiontype_id Cascade on delete 
ccurrency_cinvoice c_invoice.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_taging t_aging.c_currency_id c_currency.c_currency_id Cascade on delete 
ccurrency_tinventoryvalue t_inventoryvalue.c_currency_id c_currency.c_currency_id Cascade on delete 
cdoctype_cinvoice c_invoice.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 
cdoctype_tinvoicegl t_invoicegl.c_doctypereval_id c_doctype.c_doctype_id Cascade on delete 
cdoctype_treplenish t_replenish.c_doctype_id c_doctype.c_doctype_id Cascade on 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 
cinvoice_cinvoicepaysched c_invoicepayschedule.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_ref c_invoice.ref_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_tinvoicegl t_invoicegl.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoiceschedule_cbpartner c_bpartner.c_invoiceschedule_id c_invoiceschedule.c_invoiceschedule_id Restrict delete 
cpayschedule_cinvoicepaysched c_invoicepayschedule.c_payschedule_id c_payschedule.c_payschedule_id Restrict delete 
cproject_cinvoice c_invoice.c_project_id c_project.c_project_id Restrict delete 
cproject_taging t_aging.c_project_id c_project.c_project_id Cascade on delete 
factacct_tinvoicegl t_invoicegl.fact_acct_id fact_acct.fact_acct_id Cascade on delete 
mtransaction_ttransaction t_transaction.m_transaction_id m_transaction.m_transaction_id Cascade on 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 
so_campaign_fact_acct fact_acct.c_campaign_id c_campaign.c_campaign_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected