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

Constraint Name Child Column Parent Column Delete Rule
ad_column_field ad_field.ad_column_id ad_column.ad_column_id Restrict delete 
ad_element_ad_column ad_column.ad_element_id ad_element.ad_element_id Restrict delete 
ad_language_c_buspartner c_bpartner.ad_language ad_language.ad_language Restrict delete 
ad_printfont_adprintformat ad_printformat.ad_printfont_id ad_printfont.ad_printfont_id Restrict delete 
ad_table_column ad_column.ad_table_id ad_table.ad_table_id Cascade on delete 
adcolumn_adprintformatitem ad_printformatitem.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_adprintlabelline ad_printlabelline.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_adreportviewcol ad_reportview_col.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_adreportviewcolumn ad_reportview_column.ad_column_id ad_column.ad_column_id Restrict delete 
adelement_adprocesspara ad_process_para.ad_element_id ad_element.ad_element_id Restrict delete 
adlabelprinter_function ad_labelprinterfunction.ad_labelprinter_id ad_labelprinter.ad_labelprinter_id Restrict delete 
adlabelprinter_printlabel ad_printlabel.ad_labelprinter_id ad_labelprinter.ad_labelprinter_id Restrict delete 
adlabelprintfunc_labelline ad_printlabelline.ad_labelprinterfunction_id ad_labelprinterfunction.ad_labelprinterfunction_id Restrict delete 
adlanguage_adplabellinetrl ad_printlabelline_trl.ad_language ad_language.ad_language Restrict delete 
adlanguage_adprintformitemtrl ad_printformatitem_trl.ad_language ad_language.ad_language Restrict delete 
adprintcolor_adprintformat ad_printformat.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_adprintformatitem ad_printformatitem.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_tablefunctbg ad_printtableformat.functbg_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_tablefunctfg ad_printtableformat.functfg_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_tablehdrline ad_printtableformat.hdrline_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_tablehdrtextbg ad_printtableformat.hdrtextbg_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_tablehdrtextfg ad_printtableformat.hdrtextfg_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_tableline ad_printtableformat.line_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintfont_adprintformatitem ad_printformatitem.ad_printfont_id ad_printfont.ad_printfont_id Restrict delete 
adprintfont_tableformatfunc ad_printtableformat.funct_printfont_id ad_printfont.ad_printfont_id Restrict delete 
adprintfont_tablehdr ad_printtableformat.hdr_printfont_id ad_printfont.ad_printfont_id Restrict delete 
adprintformat_adprintgraph ad_printgraph.ad_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_adprocess ad_process.ad_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_cbankaccountdoc c_bankaccountdoc.check_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_cdoctype c_doctype.ad_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_cdunninglevel c_dunninglevel.dunning_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_forminvoice ad_printform.invoice_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_formorder ad_printform.order_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_formproject ad_printform.project_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_formremittance ad_printform.remittance_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_formshipment ad_printform.shipment_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformat_printformatchild ad_printformatitem.ad_printformatchild_id ad_printformat.ad_printformat_id Null on delete 
adprintformat_printformatitem ad_printformatitem.ad_printformat_id ad_printformat.ad_printformat_id Cascade on delete 
adprintformatinv_cbpartner c_bpartner.invoice_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformatitem_graphdata ad_printgraph.data_printformatitem_id ad_printformatitem.ad_printformatitem_id Restrict delete 
adprintformatitem_graphdata1 ad_printgraph.data1_printformatitem_id ad_printformatitem.ad_printformatitem_id Restrict delete 
adprintformatitem_graphdata2 ad_printgraph.data2_printformatitem_id ad_printformatitem.ad_printformatitem_id Restrict delete 
adprintformatitem_graphdata3 ad_printgraph.data3_printformatitem_id ad_printformatitem.ad_printformatitem_id Restrict delete 
adprintformatitem_graphdata4 ad_printgraph.data4_printformatitem_id ad_printformatitem.ad_printformatitem_id Restrict delete 
adprintformatitem_graphdescr ad_printgraph.description_printformatitem_id ad_printformatitem.ad_printformatitem_id Restrict delete 
adprintformatitem_trl ad_printformatitem_trl.ad_printformatitem_id ad_printformatitem.ad_printformatitem_id Cascade on delete 
adprintformattable_format ad_printformat.ad_printtableformat_id ad_printtableformat.ad_printtableformat_id Restrict delete 
adprintgraph_printformatitem ad_printformatitem.ad_printgraph_id ad_printgraph.ad_printgraph_id Restrict delete 
adprintheaderfooter_adprintfor ad_printformat.ad_printheaderfooter_id ad_printheaderfooter.ad_printheaderfooter_id Restrict delete 
adprintlabel_adprintlabelline ad_printlabelline.ad_printlabel_id ad_printlabel.ad_printlabel_id Restrict delete 
adprintlabelline_trl ad_printlabelline_trl.ad_printlabelline_id ad_printlabelline.ad_printlabelline_id Restrict delete 
adprintpaper_adlanguage ad_language.ad_printpaper_id ad_printpaper.ad_printpaper_id Restrict delete 
adprintpaper_adprintformat ad_printformat.ad_printpaper_id ad_printpaper.ad_printpaper_id Restrict delete 
adprintview_adprintformat ad_printformat.ad_reportview_id ad_reportview.ad_reportview_id Restrict delete 
adprocess_adcolumn ad_column.ad_process_id ad_process.ad_process_id Null on delete 
adprocess_adprocesspara ad_process_para.ad_process_id ad_process.ad_process_id Cascade on delete 
adreportview_adprocess ad_process.ad_reportview_id ad_reportview.ad_reportview_id Restrict delete 
adreportview_adreportviewcolum ad_reportview_column.ad_reportview_id ad_reportview.ad_reportview_id Restrict delete 
adreportview_col ad_reportview_col.ad_reportview_id ad_reportview.ad_reportview_id Restrict delete 
adtable_adprintformat ad_printformat.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adprintlabel ad_printlabel.ad_table_id ad_table.ad_table_id Restrict delete 
adtable_adreportview ad_reportview.ad_table_id ad_table.ad_table_id Cascade on delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_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 
distribordermailtext_adprintfo ad_printform.distrib_order_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
distriborderprintformat_adprin ad_printform.distrib_order_printformat_id ad_printformat.ad_printformat_id Restrict delete 
jasperprocess_adprintformat ad_printformat.jasperprocess_id ad_process.ad_process_id Restrict delete 
manufordermailtext_adprintform ad_printform.manuf_order_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
manuforderprintformat_adprintf ad_printform.manuf_order_printformat_id ad_printformat.ad_printformat_id Restrict delete 
rmailtext_invoiceadprintform ad_printform.invoice_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
rmailtext_orderadprintform ad_printform.order_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
rmailtext_projectadprintform ad_printform.project_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
rmailtext_remitadprintform ad_printform.remittance_mailtext_id r_mailtext.r_mailtext_id Restrict delete 
rmailtext_shipadprintform ad_printform.shipment_mailtext_id r_mailtext.r_mailtext_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected