SchemaSpy Analysis of idempiere11.adempiere - ConstraintsCurrency Generated by
Quality Systems & Solutions
42 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
c_acctschema_gl_journal gl_journal.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
c_currency_c_acctschema c_acctschema.c_currency_id c_currency.c_currency_id Restrict delete 
c_currencyconvrateto c_conversion_rate.c_currency_id_to c_currency.c_currency_id Restrict delete 
cacctschema_ccurrencyacct c_currency_acct.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_igljournal i_gljournal.c_acctschema_id c_acctschema.c_acctschema_id Null on delete 
cconversionrate_iconvrate i_conversion_rate.c_conversion_rate_id c_conversion_rate.c_conversion_rate_id Null on delete 
cconversiontype_cconvrate c_conversion_rate.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_cinvoice c_invoice.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_corder c_order.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_cpayment c_payment.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_gljournal gl_journal.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_gljournalline gl_journalline.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_igljournal i_gljournal.c_conversiontype_id c_conversiontype.c_conversiontype_id Null on delete 
cconversiontype_mdiscschline m_discountschemaline.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconvtype_iconvrate i_conversion_rate.c_conversiontype_id c_conversiontype.c_conversiontype_id Null on delete 
ccurrency_cconversionrate c_conversion_rate.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ccurrencyacct c_currency_acct.c_currency_id c_currency.c_currency_id Cascade on 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_gljournal gl_journal.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_gljournalline gl_journalline.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_iconvrate i_conversion_rate.c_currency_id c_currency.c_currency_id Null on delete 
ccurrency_iconvrateto i_conversion_rate.c_currency_id_to c_currency.c_currency_id Null on delete 
ccurrency_igljournal i_gljournal.c_currency_id c_currency.c_currency_id Null on delete 
cinvoice_cpayment c_payment.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_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 
gljourbelline_igljournal i_gljournal.gl_journalline_id gl_journalline.gl_journalline_id Null on delete 
gljournal_gljournalline gl_journalline.gl_journal_id gl_journal.gl_journal_id Cascade on delete 
gljournal_igljournal i_gljournal.gl_journal_id gl_journal.gl_journal_id Null on delete 
linkorder_corder c_order.link_order_id c_order.c_order_id Null on 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_gljournal gl_journal.reversal_id gl_journal.gl_journal_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected